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
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.
SAP Knowledge Base Article - Preview