MRP reschedule in date

[former_member700523]

Hi Experts,

We have a report already developed on MRP Rescheduling Messages for various MRP elements. This report uses following FMs

BAPI_MATERIAL_STOCK_REQ_LIST (MD04) and

BAPI_MATERIAL_MRP_LIST (MD05)

Please refer the below screen -

Here there is MRP rescheduling message "Reschedule Out" to data 01/23/2013 (MM/DD/YYYY). We are getting this date in the report output using above given FMs. That is not the issue.

The issue is there is another date beside this date in the POP UP window which is 01/18/2013, which is equal to the above date minus GR processing time (3 workdays). Gr processing time is expressed in the workdays.

My requirement is that to get this date into the report.

The problem is that as per my knowledge this date is not available in above said FMs. We can not straight away reduce the GR time from the base reschedule date 01/23/2013 which is available in FMs as the GR time is in working days.

So how I can get this date into the report output ?

1) Is there any FM / table available for this ?

2) In ABAP will there there be any date functions available which consider the Calendar for date additions / subtractions ?

3) If not, will it be possible to write any ABAP function explicitly for this ?

I am looking for the simple possible way. Any advise would be welcome.

In this regards, I would also like to know how the Factory calendar is stored in system ? like which DB tables ?

Regards,

MHP

[Former Member · Accepted solution]

Hi,

I checked and SAP calculates this date on the run. Simply the processing time is subtracted, however function module DATE_CONVERT_TO_FACTORYDATE is used for the dates both before and after subtraction.

Regards.

[former_member700523 · Accepted solution]

Hi,

Thanks for all the replies.

In FM "MD_STOCK_REQUIREMENTS_LIST_API", I had checked and not found the date for which I am looking for. It is having the Reschedule date but not the date for which I am looking for as explained in my thread. Any screen shot would be welcome...

FM "DATE_CONVERT_TO_FACTORYDATE", can I get some more information on this? How this FM is used ? When I tested this FM in SE37 (unit test) it is just returning some number which I guess that should be a date from factory calendar. But how can I use this FM to get the date for which I am looking for...

Regards,

MHP

[Former Member · Accepted solution]

Hi,

Have a look at form subtract_webaz in include LM61RF7C. Basically GR processing time (WEBAZ) is subtracted from the resheduling date (UMDAT). In addition to this, rescheduling date is subjected to the FM before subtraction, and the result of the subtraction is subjected to the FM  in order to obtain a workday. The FM is called with the input parameters, date, factory calendar ID and '+' as the CORRECT_OPTION.

Regards.

[former_member700523 · Accepted solution]

Hi,

Thank you for all the replies.

Points given & closing the post.

Regards,

MHP

[Former Member]

Dear Manish,

you can use FM "MD_STOCK_REQUIREMENTS_LIST_API". From this u can use table "MDEZX".

Please check.

[former_member700523]

Hi,

Any suggestion on above ?

I had found 1 FM "FKK_ADD_WORKINGDAY". Can this be used ?

Regards,

MHP