SAP Knowledge Base Article - Public

2755721 - Error: "External Key XXX Does not Exist for Account Visiting Hours" is Thrown When Trying to Insert Through Data Workbench.

Symptom

You are trying to insert Account Visiting Hours Weekly Recurrences using Data Workbench, but you get an error "External Key XXX Does not Exist for Account Visiting Hours".

(XXX represents the actual External Key value.)

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import view.
  3. Click on Individual Objects checkbox.
  4. Select Insert mode.
  5. Choose object: Account Visiting Hours Weekly Recurrence and select it.
  6. Click Next.
  7. Upload your csv file for this object with the data to insert.
  8. Continue until final step and press Finish.
  9. Check the Monitor view and find that your task has failed with the above mentioned error.

Cause

Your attempt to create 3rd Level Data with 2nd Level External Key and 1st Level Internal ID is not supported at this time.

The system is designed to have External Keys as mandatory when performing multi-level imports, meaning that all External Keys need to be filled (for example the 'CorporateAccountExternalKey' field).

Account Data levels:

Level 1: Accounts
Level 2: Account Visiting Hours
Level 3: Account Visiting Hours Weekly Recurrence
Level 4: Account Visiting Times

Resolution

Fill out associated External Keys at all levels.

Keywords

Data Workbench, OData, External Keys , KBA , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer 1805 ; SAP Cloud for Customer add-ins 1802 ; SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902 ; SAP Hybris Cloud for Customer 1702 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer add-ins 1705 ; SAP Hybris Cloud for Customer add-ins 1711