SAP Knowledge Base Article - Public

3287028 - ParentObjectID Is Not Provided For Sales Quote Involved Parties

Symptom

Error "ParentObjectID is not provided for Sales Quote Involved Parties" when performing insert via Data Workbench.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench Work center.
  2. Go to Import View.
  3. Select Individual Object and Insert method.
  4. Select Standard object and then Sales Quote Item Involved Parties
  5. Upload the file.
  6. Click on next until import button.
  7. Click on import.

Cause

The Data Workbench uses the parent external key (Sales_Quote_Item_External_Key) and the root external keys (Sales_Quote_External_Key) to insert records. There isn't Sales_Quote_Item_External_Key available. May be because Sales_Quote_Item was created in the system without using Data Workbench. Because of that, it is not possible to create the Item Parties using Insert or Upsert methods.

Resolution

Use the update scenario to create the Sales Quote Item Involved Parties.

  1. Go to Data Workbench Work center.
  2. Open the Export view.
  3. Export Sales Quote Item Involved Parties  (1 record is  fine, as we need only the headers).
  4. Delete the record and keep only the header row. Note that this file will have ParentObjectID and HeaderObjectID.
  5. Now, except the ObjectID column, fill all the needed columns. 
  6. The parent objectID and headerObjectID needs to be filled as we need to create the 3rd level child to the appropriate 2nd level and 1st level. The parent objectID is the object ID of the Sales_Quote_Item node, and the headerObjectID is the object ID of the Sales_Quote. 
  7. Use the Data Workbench Update method and upload the file. 

Keywords

  ParentObjectID, Data Workbench, Sales Quote Involved Parties, Insert , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-LE-CQP , Customer Quote Processing , How To

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications 2211