SAP Knowledge Base Article - Public

2947433 - Unable to Update Data Using Data Workbench as External Key Does not Exit

Symptom

You have a requirement to update the data using Data Workbench, however you are unable to do so due to External key not existing for the required records.

This generally happens for the sub node/ child object. If the parent object was not created via DWB then you won’t find the External key. Hence while updating the child/sub object it becomes very tedious to update if the External key does not exist for the Parent Object.

 

Environment

SAP Cloud For Customer

Resolution

You may follow the below steps to import External key by Scoping the ID Mapping for Data Workbench.

Step 1:

  1. Go to Business Configuration
  2. Select Implementation Projects
  3. Select Edit Project Scope
  4. Navigate to Scoping Question Phase
  5. Select and expand scoping element Built-in Services and Support
  6. Select Business Configuration
  7. Select Data Workbench
  8. On the right side select the question ->Do you want to enable ID mapping?

After saving the above Scoping Question, ID mapping option will get enabled in Data Workbench.

 Step 2:

  1. Go to Data Workbench
  2. Select ID mapping operation
  3. Select required Business Object
  4. Download the template
  5. Enter ID & External Key and save the template
  6. Import the template using ID Mapping operation

  Now you have the external key for the required data which you may use while update/import of Sub nodes/child objects.

Note: Currently this functionality if available only for the limited Objects which are listed under ID mapping operation.

Keywords

ID Mapping, External Key missing, Unable to update , Data workbench , KBA , how to update external keys , external key for existing records , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer core applications all versions