SAP Knowledge Base Article - Public

3392760 - Opportunity ID Is Not Visible in Import Template of a Custom Individual Object but Is Present in Export Template for Same Custom Individual Object


You are importing a template for a certain Custom Individual Object.

However, after downloading the file, you notice that the Opportunity ID is not visible in import template.

Now, when you go to Export for the same Custom Individual Object, the Opportunity ID is visible there.


SAP Cloud for Customer

Reproducing the Issue

  1. Navigate to Data Workbench Work Center;
  2. Go to Import View;
  3. Select Individual Object > Select an Object – Standard Object > Search for Opportunity object;
  4. From Download Template, Select "Comma Separated Value (.CSV)";
  5. After downloading the .ZIP file, you open the file and search for Opportunity ID field. Unfortunately, you are not able to see the field;
  6. Now navigate to Export View for the same object >> Filed will be there;


If you access the OData service metadata for the tenant:$metadata , you will see that for the  Individual Object you want, the property "ID" -> sap:creatable="false" due to this, "Opportunity ID" is not available in the import templates.


If the '"sap:creatable="false' is set to FALSE, it will not be available in the import template.

As this is a custom entity, you need to check this with your Partner who implemented this.


Import, export, template; , KBA , LOD-CRM-INT-DWB , Data Workbench , How To


SAP Cloud for Customer core applications all versions