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_EXTPROC===========CP
Application Component PP-MRP
Short Text
Error while executing a database procedure
What happened?
During execution of database procedure
CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_BACK_FRGDT
an error occurred.
SQL code of the database: 303
Error analysis
The reason for the exception is:
When calling database procedure
CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_BACK_FRGDT
an error occurred. The error message begins with (full message under
"Information about database procedures (AMDP)":
"invalid DATE, TIME or TIMESTAMP value:
"SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20241216110615": line 16 col
3 (at pos 586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 71 col 6
(at pos 2659): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PRE"
Source Code Extract
1 METHOD ext_proc_sched_back_frgdt
2 BY DATABASE PROCEDURE FOR HDB LANGUAGE SQLSCRIPT
3 OPTIONS READ-ONLY
4 .
5
6 -- -------------------------------------------------------------------------------------
7 -- determine frgdt from lfdat
8 -- * frgdt = lfdat - plifz ( w/o calendar but shifted to next working day)
9 -- - bztek (based on factory calendar)
10 -- -------------------------------------------------------------------------------------
11
12 -- temp = lfdat - plifz ( w/o calendar but shifted to next working day)
13 lt_temp = select
14 mdps.*,
15 case
16 when mdps.plifz is not null then
17 to_dats(add_days ( mdps.lfdat, - mdps.plifz ))
18 else
19 mdps.lfdat
20 end as temp_date
21 from :it_mdps_backw_in as mdps
22 ;
23 -- frgdt = temp - bztek (based on factory calendar)
>>>>> et_frgdt_result = select
25 the_index,
26 to_dats(case
27 when add_workdays(mdps.fabkl, mdps.temp_date, 0, :iv_schema) = mdps.temp_date then a
28 else add_workdays(mdps.fabkl, mdps.temp_date, - mdps.bztek - 1, :iv_schema) -- subtr
29 end) as frgdt
30 from :lt_temp as mdps
31 ;
32
33 ENDMETHOD.
Database Procedure (AMDP) Information
Full error message from the database:
invalid DATE, TIME or TIMESTAMP value:
"SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP#stb2#20241216110615": line 16 col 3 (at pos
586): "SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP": line 71 col 6 (at pos 2659):
"SAPHANADB"."CL_PPS4_MRP_RUN=>MAT_PLANT_MRP_PREPARE_SINGLE": line 261 col 8 (at pos 11491):
"SAPHANADB"."CL_PPS4_MRP_CALC=>CALC_CHANGES": line 959 col 12 (at pos 39459):
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_HANDLE": line 65 col 7 (at pos 2786):
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED": line 75 col 7 (at pos 3511):
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_STD": line 139 col 7 (at pos 5715):
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_BACK_STD": line 34 col 5 (at pos 1644):
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_BACK_FRGDT": line 28 col 5 (at pos 1129),
"SAPHANADB"."CL_PPS4_MRP_EXTPROC=>EXT_PROC_SCHED_BACK_FRGDT": line 17 col 5 (at pos 832):
error in column FRGDT, row 1: invalid calculated date value at "add_days" function
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 date value, invalid time value, invalid timestamp, ext_proc_sched_back_frgdt, extproc, add_days, add_workdays, frgdt, factory calendar, scheduling, mrp dump, mrp runtime error, mrp planning termination, CL_PPS4_MRP_EXTPROC, SQL code of the database: 303, invalid calculated date value at "add_days" function, et_frgdt_result, , 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