SAP Knowledge Base Article - Public

3451157 - Error "Update Not Allowed For Properties" For Updating Field Using Data Workbench


Error "Update not allowed for Properties: MainEmployeeResponsiblePartyName" is witnessed while updating owner field in opportunity using data workbench.


SAP Cloud for Customer 

Reproducing the Issue

Step 1: Execute following steps to export opportunity data for the Data Workbench object: 

  1. Go to Data Workbench work center.
  2. Go to Export tab.
  3. In search field, select the opportunity.
  4. Choose appropriate filters, if required.
  5. Select Next.
  6. Export Data.
  7. Go to the Monitor tab.
  8. Download the exported file.

Step 2: Perform following steps to update of Opporuinity Business Object using exported file in step 1. 

  1. Open the file exported from Step 1.
  2. Modify the data to be updated for the required fields in the file.
  3. Save the file.
  4. Go to Data Workbench work center.
  5. Go to the Import tab.
  6. Select the radio button Individual Objects.
  7. Go to Update tab.
  8. Select the opportunity.
  9. Select Next and Browse for the file.
  10. Select Upload
  11. Choose Next to review the summary of your selection.
  12. Select Import.
  13. Go to Monitor view to check the status of your import.
  14. The records in the file show Processing Error ""Update not allowed for Properties: MainEmployeeResponsiblePartyName".


Error shown in processing records is due to Properties of the Owner field which is updatable=false.

To verify properties for the respective Entity Set, execute the following query in Google Chrome browser.$metadata (where xxxxxx represents the tenant ID)

Once user get the results, find the Entity Type and check the property accordingly. 

Alternatively, execute following steps to view the properties for the respective entity set.

1. Go to Administrator work center.
2. Go to OData Service Explorer view. 
3. Show SAP OData Services.
4. Highlight the Service name: c4codataapi and select the button Test.
5. On the OData Console, for the Service, in the left pane, select the Entity Set.
6. Select the tab Entity Details.


The properties of fields which are marked as updatable=false, will not be allowed to update via Data Workbench.


Data Workbench, updatable=false, Update not allowed for properties, OData, export, import  , KBA , LOD-CRM-ACT , Activities , Problem


SAP Cloud for Customer core applications all versions