SAP Knowledge Base Article - Preview

3507099 - Adding new item to an outbound delivery in EWM results in a dump in ERP smq2: DBSQL_DUPLICATE_KEY_ERROR

Symptom

When adding a new item to an outbound delivery in EWM, a message OBDLV_CHANGE is determined and sent to ERP with the new item information. However it ends in a dump in ERP smq2:

FM: BAPI_OUTB_DELIVERY_CHANGE

Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
except.                CX_SY_OPEN_SQL_DB

This happens when the delivery in ERP includes EWM relevant and non EWM relevant items mixed, and the new EWM item gets the ERP reference item number of an existing one in the ERP delivery. 

ERP sends the savereplica message to EWM correctly, in HEADER_DATA_SPL the MAX_ITEM_NUMB filled correctly.


Read more...

Environment

  • SAP S4HANA
  • SAP Extended Warehouse Management

Product

SAP Extended Warehouse Management all versions ; SAP S/4HANA all versions

Keywords

KBA , SCM-EWM-IF-ERP-DLP , Interface ERP Delivery Processing , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.