Symptom
While importing a template for a certain Custom Individual Object, the Opportunity ID is not visible in import template after downloading the file. But, the Opportunity ID is visible when navigated to Export for the same Custom Individual Object.
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