SAP Knowledge Base Article - Preview

2847127 - DBSQL_DUPLICATE_KEY_ERROR dump occurs when running report /SAPAPO/CREATE_LOCATION

Symptom

  • When executing report /SAPAPO/CREATE_LOCATION, a short dump DBSQL_DUPLICATE_KEY_ERROR may occur in the following scenarios:
    1. Creating locations for a Business Partner:
      • The dump is triggered only when locations are created for both the standard address and delivery address simultaneously (option “Create for Std & Delivery Adrs”).
    2. Creating locations with addresses that contain zone information.
  • The dump typically appears as follows:

    Category               ABAP programming error
    Runtime Errors         DBSQL_DUPLICATE_KEY_ERROR
    Except.                CX_SY_OPEN_SQL_DB
    ABAP Program           /SAPAPO/SAPLLOC_WRITE
    Application Component  SCM-BAS-MD-LO


Read more...

Environment

  • SAP Transportation Management Embedded in S/4HANA 1709+

Product

SAP S/4HANA 1709 ; SAP S/4HANA 1809 ; SAP S/4HANA 1909 ; SAP S/4HANA 2020 ; SAP S/4HANA 2021 ; SAP S/4HANA 2022 ; SAP S/4HANA 2023

Keywords

DBSQL_DUPLICATE_KEY_ERROR, CX_SY_OPEN_SQL_DB, /SAPAPO/SAPLLOC_WRITE, /SAPAPO/CREATE_LOCATION, Location, Business Partner, Transportation Zone. , KBA , TM-MD-TN-LOC , Location , SCM-BAS-MD-LO , Location , 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.