Symptom
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.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Navigate to Data Workbench Work Center;
- Go to Import View;
- Select Individual Object > Select an Object – Standard Object > Search for Opportunity object;
- From Download Template, Select "Comma Separated Value (.CSV)";
- After downloading the .ZIP file, you open the file and search for Opportunity ID field. Unfortunately, you are not able to see the field;
- Now navigate to Export View for the same object >> Filed will be there;
Cause
If you access the OData service metadata for the tenant: https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/opportunity/$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.
Resolution
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.
Keywords
Import, export, template; , KBA , LOD-CRM-INT-DWB , Data Workbench , How To