SAP Knowledge Base Article - Public

3665155 - Item Type ZABC Fails with "Duplicate Key Entry" Error Message

Symptom

The "ZABC" item type, which refers to a generic custom Item Type ID, is not working correctly and ends up with an error message "duplicate key entry" when used in a Sales Quote.

Environment

SAP Cloud for Customer

Reproducing the Issue

Maintain the Code List Mapping for the Item Processing Type Code as shown below:

  1. Go to Business Configuration Work Center.
  2. Click on the Overview.
  3. Search for *Code List Mapping*.
  4. Open the Code List Mapping for Integration with External Applications and Solutions Activity.
  5. Select the Maintain Code List Mapping option.
  6. Filter for "BusinessTransactionDocumentItemProcessingTypeCode" Local Data Type Name.
  7. Map the Item Processing Type Code (ZABC) to the respective Internal Code.

Use the same Internal Code configured under Maintain Item Type for the respective Sales Document Activity.    

Cause

The item type ZABC is maintained on the Sales Order. Consequently, it's not possible to maintain it in the Sales Quote.

Resolution

An item type should be assigned to only one Sales document in C4C to avoid system inconsistencies. While the S4 system allows the same item type to be used in different Sales documents, C4C requires a single item type to be linked to one Sales document type. Therefore, you must choose whether to assign the ZABC to only one Sales Document to ensure proper functionality.

Keywords

Sales Quote, Sales Order, C4C, Cloud for Customer, Duplicate Key Entry, Item Type, Item Type Code, Sales Document , KBA , LOD-CRM-INT-ERP , Integration of C4C with ERP , How To

Product

SAP Cloud for Customer core applications all versions