SAP Knowledge Base Article - Public

3556082 - Unable to import condition records in Manage Price Sales app - S/4HANA Cloud

Symptom

Customer is uploading condition records with different basic pricing rate for the same product using excel in "Manage Prices – Sales ", but got the following error: Can't import two or more overlapped condition records with the same key.

Environment

SAP S/4HANA Cloud Public edition 

Cause

This error can occur when the same condition key and validity period is used in one excel. We don't recommend importing two or more condition records with the same condition key (that is, a combination of condition type, condition table, access, and condition fields) in one spreadsheet. This is because, for the spreadsheet, the system cannot identify the creation sequence of these entries and thus cannot decide how the validity periods should be split if they overlap. Therefore we suggest that, for such entries, you import one validity period at a time.

Resolution

To avoid this error, upload only one condition record for the same condition key and validity period in one excel. Don't try to upload multiple records with the same key and validity periods. You can also have a look at the following FAQ note about the  2953452 - FAQ: Excel Download and Upload in Manage Prices - Sales 

See Also

FAQ for Manage Prices - Sales

Keywords

condition records, VK11, manage price sales, condition table, pricing , KBA , SD-MD-CM-2CL , Conditions and Condition Maintainance (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions