Symptom
During service upload using an Excel template, the system performs field validation and terminates the upload due to an invalid value maintained in a valuation status–related field.
Environment
SAP Business ByDesign
Reproducing the Issue
- Navigate to the Product Data work center.
- Go to Services and choose New Services from Excel Template.
- Download and maintain the Excel template with service data.
- From the SAP Business ByDesign tab in Excel, select Save Data To and attempt to upload the file.
- The system performs validation and the upload fails with an invalid value error related to a valuation status field.
Cause
The error occurs because the valuation status field in the Excel template is maintained with a value that is not supported by the system during validation.
Resolution
- In the New Services Excel template, maintain the valuation status field with the only supported value “1”.
- Ensure that the template data is maintained consistently without duplicate or conflicting entries.
- Save the corrected file and reattempt the service upload.
Keywords
valuation status, error, invalid value, 1-in preparation, services upload, Excel template, SAP Business ByDesign, product data work center, new services, upload failure, corrected file, data validation , KBA , SRD-MD-PRD-PRD , Product , Problem
Product
SAP Business ByDesign all versions
SAP Knowledge Base Article - Public