3525091 - Field not present in Data Workbench Import Template

There is a field which you want to update via the Data Workbench, However when you download the Template

from the Import view the field is not present there.

SAP Cloud for Customer

1. Open Data Workbench and go to Import view
2. Select the required Object example: Account
3. Click either radio buttons under Download Template for .xlsx or csv templates
4. See in the excel file downloaded the field Parent Account is not present for example

If a field is not Updateable or Creatable via the Data Workbench then it will not be present in the template for Imports.

To check if a field is Creatable and Updatable you can follow these steps: Example for this is the Parent Account field

1. Go to Administration and open OData Service Explorer
2. Select the service "c4codataapi"
3. Click the button Test
4. In the OData Console select the CorporateAccountCollection
5. Under Entity Details find the field Parent Account 
6. See under the column Creatable and Updateable the value: false

It is expected then that this field is not present in the import template for the Data Workbench.

Updateable, Creatable, Data Workbench, Template, Import, Available , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem