SAP Knowledge Base Article - Public

2788194 - Is it possible to import Sales Quote Item Notes for existing Sales Quote Items?

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

  1. Go to Data Workbench workcenter
  2. Go to Import view
  3. Select the radio button for Individual Object
  4. Go to Insert tab
  5. Go to Standard Object tab
  6. Search for the Data Workbench object Sales Quote Item Notes
  7. Select Download
  8. 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

Product

SAP Cloud for Customer add-ins all versions