SAP Knowledge Base Article - Preview

3717101 - MRP Live dump: AMDP_EXECUTION_FAILED in method EXT_PROC_SCHED_BACK_FRGDT

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

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 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.