How to get the rescheduling date in MD04?
I need to create a report for buyers to show them the shortage of material. It will help them to determine how to reschedule the delivery of purchase orders. So, I need show the rescheduling date in MD04 on this report as the suggestion from MRP.
So, would you please help to let me known how and where I can get the rescheduling date (MDEZ-UMDAT) displayed in stock/req list?
Thanks a lot!
I did, in the past, something close of what you want.
As I can remember today :
to go farest with the user interface I built a sap query witj an infoset joining the tables t001/marc/plaf/mdkp/mdtb. I got the resch. date from MDTB-UMDAT.
If you have some difficulty to get information from the table MDTB, check the parameter V_T399D_P-DECOMP for the plant. In standard the code is desactivated and the MRP records are saved in a cluster as a compact mode (table MDTC). If you activate it, the MRP records are saved in a transparent table in a none compacted format (table MDTB).
Check the SAP warning for performance before activating it.
In fact, to speed up the query, I firmed the selection range for MDKP against the 3 following messages (key/number/text) :
U1 10 Reschedule in
U2 15 Reschedule out
U3 20 Cancel process
These messages are normaly defined with an high priority (=10), and they are automatically set on the header (MDKP) when assigned one time on one MRP element at least. Only 6 known messages have an higher priority ( check V458A-ASPRI), that's why I used this shortcut.
If you rather want work directly at the element header than the header one, you should have to read messages for each selected MRP element (in MDTB) with a module function (see in groupe smsg).
That's all I can remenber now without working too hard on it ... sorry.
I hope to be helpfull....