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
Keywords
condition records, VK11, manage price sales, condition table, pricing , KBA , SD-MD-CM-2CL , Conditions and Condition Maintainance (Public Cloud) , Problem