SAP Knowledge Base Article - Public

2803693 - Importing Product Category not Possible, Because Parent External key not Found


You are trying to import a file into Product Categories using Data Workbench and get the following error in the result file:

"Record not created; parent external key not found."


SAP Cloud for Customer

Reproducing the Issue

  1. Go to the Data Workbench work center.
  2. Select the Import tab.
  3. Select the Individual Object radio button.
  4. Find the Product Categories.
  5. Click Download to download the template.
  6. Fill the downloaded file with values.
  7. Click next.
  8. Browse and Upload the file.
  9. Simulate the import.
  10. Go to the Monitor tab.
  11. Open the result file and check the error messages.


Pure product categories cannot be created by OData, hence the Data Workbench will also only allow subnodes to be added.


The field HIERARCHY_ID has to contain your existing product category, for example ABC (where ABC represents the product category).

If you now create sub-entities, you have to maintain the fields like below, for example:

  • As Hierarchy_ID KLM (where KLM represents a Hierarchy ID).
  • As Product_Category_ID the new ID (please ensure not to use leading spaces here!).
  • As Parent_Product_Category_ID an existing category (for example, XYZ (where XYZ may also be the root ID)).


reine Produktkategorien angelegt, Unterentitäten anlegen, Produkt Hirarchie , KBA , LOD-LE-PRD , Product + Product Category , Problem


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