MD04 Table entries

[former_member184595]

Hi ,

We had maintained some demand and we can see the demand in MD04. Just want to know what is the table in which we can see the entries of demand,receipts of different MRP elements that are visible in MD04 screen. In which table we can see the entries of MD04 screen.

Thanks in advance

[Former Member]

As other have said, if you want online data use the FM MD_STOCK_REQUIREMENTS_LIST_API

If you want to read static tables, you can read the ones storing data that you see in transaction MD05 (MRP results):

-MDKP

-MDTB

regards

Mauro Chiulli

[sundaresan_velayudam]

There is no direct table to see all the data in MD04

use FM # MD_STOCK_REQUIREMENTS_LIST_API

system will store all the data into internal table MDPSX ,MDEZX & MDSUX while running FM, from here you can extract the data

[former_member184595]

Hi Sunderasan,

Thanks for the reply.

In fact, we need to prepare a demand report for the 25 weeks from the given date and we need to compare the Demand report with the MD04 screen. So, the demand in week 1,should be equal to sum of all the requirements in week1, similarly for the remaining 24 weeks. Just want to know from which tables the demand in MD04 is coming from.. Please give some inputs for calculating the Demand and Shortage Report.

Thanks in advance

[sundaresan_velayudam]

In MD_STOCK_REQUIREMENTS_LIST_API

pass the material no and plant

In the ouput

filter out the PP- independent requirement , AR- dependent requiremnt, VC- sale order data based on DAT00 date(period)

and sum up the MNG01( receipt/ requirement) based on period

[Former Member]

Hi,

It would not be wise to try to retrieve data from tables. Instead use above function modules or use BAPI_MATERIAL_STOCK_REQ_LIST.

This BAPI is simple to use and any ABAPer can help you to use this.

From table MRP_IND_LINES of this Bapi you can get the required details.

Regards,

Krishna Mohan