Symptom
You want to update the field "Draft" for all Appointments in the system, changing the field "Draft" from "false" to "true" via Data Workbench.
But there is getting an error message while trying to import the changes: "Update not allowed for properties: Draft; check the metadata for AppointmentCollection"
Environment
SAP Cloud for Customer
Reproducing the Issue
- Navigate to Work Center Data Workbench
- Hit Export
- Export all Appointments
- Go to Monitor
- Download the csv
- In the csv in column Draft change all values from false to true
- Go back to the system to import
- Choose Update for Appointments
- Upload the csv
- Import the csv
- Go to monitor to see the import status
Cause
The field draft is not updateable via the data workbench, that is why this error is being triggered.
You can check the availability to be updated by:
- Accessing metadata https://my000000.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/$metadata
- And noticing that, for entity "Appointment", Draft is "updatable=false": <Property Name="Draft" Type="Edm.Boolean" Nullable="true" sap:creatable="true" sap:updatable="false" sap:filterable="true"/>
Resolution
You can access our Influence Portal and suggest an improvement in this scenario if you believe it could best serve your business purposes: https://influence.sap.com/sap/ino/#/campaign/1868
Keywords
Update; updatable; field; draft; appointments; data workbench; boolean; true; false; change; error; message; import; allowed; properties; metadata; appointment; collection. , KBA , LOD-CRM-INT-DWB , Data Workbench , Product Enhancement
SAP Knowledge Base Article - Public