Symptom
During execution of transactions MD01N you receive the following dump:
Category ABAP programming error
Runtime Errors AMDP_EXECUTION_FAILED
Except. CX_AMDP_EXECUTION_FAILED
ABAP Program CL_PPS4_MRP_RUN===============CP
Application Component PP-MRP
In the Database Procedure (AMDP) Information, you may receive the following message:
Full error message from the database:
inserted value too large for column:
"SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20240925091038": line 16 col 3 (at pos
586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 66 col 7 (at pos 2524):
"SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PREPARE_SINGLE": line 314 col 8 (at pos 15209):
cannot convert "FRGDT is initial for planned receipt on 2025-01-08" to the type NVARCHAR(1)
for column MOREINFO
Or
Full error message from the database:
invalid DATE, TIME or TIMESTAMP value:
"SAPQS1"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20181126234039": line 16 col 3 (at pos 586), "SAPQS1"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 66 col 7 (at pos 2521):"SAPQS1"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PREPARE_SINGLE": line 231 col 8 (at pos 10352):"SAPQS1"."CL_PPS4_MRP_CALC=>CALC_CHANGES": line 630 col 12 (at pos 25397):"SAPQS1"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_HANDLE": line 65 col 7 (at pos 2783):"SAPQS1"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED": line 74 col 7 (at pos 3487):
.......
error in column FRGDT, row 16: invalid calculated date value at "add_days" function
Read more...
Environment
- SAP ERP Logistics (PP)
- SAP S/4 HANA, on premise
- SAP S/4HANA Cloud Private Edition Release Independent
Product
Keywords
MD01N;invalid DATE, TIME or TIMESTAMP value; inserted value too large for column; AMDP_EXECUTION_FAILED , 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