SAP Knowledge Base Article - Public

2806829 - Error: "Error in format validation. Correct the following: Map either the parent internal ID or external key. Do not map both"

Symptom

When trying to update names and addresses of org units via Data Workbench, the following error appears:

"Error in format validation. Correct the following: Map either the parent internal ID or external key. Do not map both".

Environment

SAP Cloud for Customer

Resolution

When uploading a CSV file via Data Workbench for object Organisational Unit Name and Address, the system is expecting data in the following columns of the template:

  • External Key
  • Organisation Unit External Key
  • Organisational Unit ID

The following fields are required in the CSV file:

  • For Root file: External Key and other mandatory fields needs to be present in the CSV file.
  • For Child file: External Key, Parent External Key / Parent Internal ID and other mandatory fields need to be present in the CSV file.
  • External Key: it's a unique key. It is used only for DWB tool purpose. Example: EKSAMPLE001.
  • Parent External Key: The External Key which was used in the Root file. Example: EKSAMPLE001.
  • Parent Internal ID: If the Root entity was not inserted using DWB, there is no Parent External Key. In this case use Internal ID.


All records in the CSV file must contain either Parent External Key or Parent Internal ID. Records with Parent External Key and records with Parent Internal ID in the same file is not a valid scenario.

See Also

Further information is available in the SAP Help Documentation via the search term 'Data Workbench'.

Keywords

External Key; Organisation Unit External Key; Organisational Unit ID , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions