Symptom
Your requirement is to import Sales Quote Item Notes for existing Sales Quote Items. You see SalesQuoteExternalKey and SalesQuoteItemExternalKey fields in the upload file.
Is it possible to add Quote ID and the Item ID to the template to import Sales Quote Item Notes via Data Workbench?
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench workcenter
- Go to Import view
- Select the radio button for Individual Object
- Go to Insert tab
- Go to Standard Object tab
- Search for the Data Workbench object Sales Quote Item Notes
- Select Download
- QuoteID and QuoteItemID fields are not available in the upload file.
Cause
QuoteID and QuoteItemID are not yet create-enabled in the OData Sales Quote entity SalesQuoteItemTextCollection.
Resolution
For the Sales Quote or the Sale Quote Item which are not imported from Data Workbench, you cannot import Sales Quote Item Notes via Data Workbench. Creation of Item Notes for existing Sales Quotes which are not imported from the Data Workbench and thus do not have the Data Workbench External Keys are not yet supported.
Note:
OData framework cannot automatically determine ParentNodeID based on a combination of Internal IDs at different levels. Hence, wherever ParentNodeID can be determined using InternalID usually an alternate key on Root node can only be used for importing sub node data. In all other cases, External Keys need to be used.
Keywords
Sales Quote, SalesQuoteItem, QuoteID, QuoteItemID, Quote ID, Item ID, Sales Quote Item Notes , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem