Symptom
When importing condition record via spreadsheet, the import failed.
After downloading the Prices in Sales-Failed file and check the message, the error message below occurs:
"Property "Condition Currency" is required for condition record **"
But in fact, the "Condition Currency" has already been maintained in the imported file.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Enter the app "Manage Prices-Sales" and prepare the spreadsheet to be uploaded.
- Click the "Import" button and upload the spreadsheet.
- The message of import failure pops up and download the Prices in Sales-Failed file.
- Check the message column of Prices in Sales-Failed file.
- The message "Property "Condition Currency" is required for condition record **" appears and the values of the "Conditional Currency" column have been cleared.
Cause
In standard template, there's a hidden line, which is highlighted as yellow. The system uses this hidden line to match the related fields.
A possible reason is the corresponding position to "Condition Currency" in the hidden line was overwritten, it should be "ConditionRateValueUnit".
Resolution
There're 2 workarounds can be considered:
- Download a new template and ensure that the value in the hidden line is not overwritten.
- Correct the corresponding position in the hidden line.
After that, to import the condition records again.
Keywords
Condition Currency, Condition Record, ConditionRateValueUnit, Document Currency, Import, Manage Prices-Sales, SAP S/4HANA Cloud Public Edition , KBA , SD-MD-CM-2CL , Conditions and Condition Maintainance (Public Cloud) , Problem