SAP Knowledge Base Article - Public

3616722 - Error Message: "Property "Condition Currency" is required for condition record **" occurs when importing condition record although the condition currency has already been maintained-SAP S/4HANA Cloud Public Edition

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

  1. Enter the app "Manage Prices-Sales" and prepare the spreadsheet to be uploaded.
  2. Click the "Import" button and upload the spreadsheet.
  3. The message of import failure pops up and download the Prices in Sales-Failed file.
  4. Check the message column of Prices in Sales-Failed file.
  5. 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

Product

SAP S/4HANA Cloud Public Edition all versions