Symptom
Getting error during ICMR file upload. Error is "Specify the value for key field "XY" in row "X".
The error is occurring during file upload where the Document number is blank in some line items.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Set global parameters.
- Open app Flexible Upload of Matching Items.
- Upload a file.
Cause
ICMR release a new function "Update existing items" for ICAFU in 2308 release.
It allows user to modify the items that already exist. The system identifies existing items based on the key fields that were set in the data source. Getting this error message because "XY" is one of key fields in the data source.
Resolution
- In case if do not want to use "Update existing items" function provided by ICAFU, then a dummy number can be assigned to "XY" in the upload file.
- If field "XY" is not used as a business key field of the original transaction line item, then "Key Field" in the "Field Semantics" can be unchecked under Data Source setting.
See Also
Keywords
key field, matching items, flexible upload, ICMR , KBA , FIN-CS-ICR-2CL , S/4HANA Intercompany Matching and Reconciliation (Publ Cld) , Problem