SAP Knowledge Base Article - Preview

3717109 - MRP Live dump: AMDP_EXECUTION_FAILED during source determination in SELECT_SOURCE_FROM_CDS

Symptom

When running MRP Live (MD01N), the following dump occurs:

Category               ABAP programming error
Runtime Errors         AMDP_EXECUTION_FAILED
Except.                CX_AMDP_EXECUTION_FAILED
ABAP Program           CL_PPS4_MRP_PURCHASING========CP
Application Component  PP-MRP
Short Text
     Error while executing a database procedure
What happened?
     During execution of database procedure
     CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS
     an error occurred.
     SQL code of the database: 339
Error analysis
    The reason for the exception occurring was:
    The reason for the exception is:
    When calling database procedure
    CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS
    an error occurred. The error message begins with (full message under
    "Information about database procedures (AMDP)":
    "invalid number:
     "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20250408074901": line 16 col
     3 (at pos 586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 74 col 7
     (at pos 2808): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PREPARE_SINGLE":
     line 236 "
Database Procedure (AMDP) Information
    Full error message from the database:
    invalid number: "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20250408074901": line 16
    col 3 (at pos 586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 74 col 7 (at pos
    2808): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PREPARE_SINGLE": line 236 col 8 (at pos
    10685): "SAPHANADB"."CL_PPS4_MRP_CALC=>CALC_CHANGES": line 456 col 12 (at pos 18714):
    "SAPHANADB"."CL_PPS4_MRP_SOURCING=>SOS_DET": line 116 col 5 (at pos 5624):
    "SAPHANADB"."CL_PPS4_MRP_SOURCING=>SOS_PREP_EXT_PROC": line 25 col 7 (at pos 1375):
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>PURG_SOS_SELECT": line 14 col 7 (at pos 704):
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 386 col 5 (at pos 17472),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 11 col 5 (at pos 452),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 62 col 5 (at pos 4075),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 120 col 5 (at pos 8157),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 149 col 5 (at pos 9682),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 194 col 5 (at pos 11779),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 243 col 5 (at pos 13371),
    "SAPHANADB"."CL_PPS4_MRP_PURCHASING=>SELECT_SOURCE_FROM_CDS": line 294 col 5 (at pos 14951):
     [6930] attribute value is not a number;exception 70006930: attribute value is not a
    number;[here]int("COL$11$") = 7, COL$11$ = ''[string],docid#
>>>>>     lt_source = SELECT * FROM :lt_eord_order
  388       UNION ALL SELECT * FROM :lt_eord_mat_unknown
  389       UNION ALL SELECT * FROM :lt_eord_ir_ematn
  390       UNION ALL SELECT * FROM :lt_eord_ir
  391       UNION ALL SELECT * FROM :lt_cds_oa
  392       UNION ALL SELECT * FROM :lt_cds_ir;


Read more...

Environment

  • SAP S/4HANA, on-premise Release Independent
  • SAP S/4HANA Cloud Private Edition Release Independent 

Product

SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions

Keywords

mrp live, md01n, amdp_execution_failed, cx_amdp_execution_failed, invalid number, source list, eord, eortp, source determination, select_source_from_cds, mrp dump, hana amdp error, CL_PPS4_MRP_PURCHASING, mrp live termination, sourcing error, mrp live runtime error, cds sourcing, mrp planning error, EORD‑EORTP, SQL code of the database: 339, lt_eord_order,  , KBA , PP-MRP , Material Requirements Planning , 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.