MD04 table name for stock statistics

[dalong_lu]

hi, all

i'm wondering how can i find out the table name for MD04- stock statistics - Fixed receipts, the structure's name MDSTA-SUM02.

I tried use ST05 to trace the update table name, i created a Production order, this "fixed receipts" field is updated. but i counldn't find out the right updated table for this particular field.

does anyone know how to find it or if anyone knows the right table name for it! thanks

[Former Member]

Qgjddcel,

I have never debugged this portion of the MD04 program, but I would assume that this total, like most totals in MD04, is CALCULATED when you hit 'enter'. I would be very surprised to learn if there were a table where this data is being stored.

Rgds,

DB49

[dalong_lu]

in MDKP Header Data for MRP Document it contains field name SUM02 but it states No longer used/do not use!! this field is actually the sum of several orders, which including

Purchase orders

Schedule lines

Consignment orders

Consignment schedule lines

Production orders

Receipt reservations

this total must stored somewhere in the table, any idea where it is?

[Former Member]

Qgjddcel,

MDKP doesn't hold any current data (relevant for MD04), It holds data from the most recent MRP run. The results of the MRP run, including this data item, can be printed out using transaction MDLD.

If it is important to you to have this bit of data, perhaps you should have one of your ABAPers create a program that calculates it, using the same/similar code that SAP uses.

Rgds,

DB49.

[dalong_lu]

DB49

thanks for the input, maybe i will take your suggestion to get help from abaper.

cheers

[Former Member]

Depending what you're trying to do, you can do a test run on MD_STOCK_REQUIREMENTS_LIST_API. The only information you need to enter is the plant and material. You'll want the results in E_MDSTA. That will only be reasonable if you're trying to find the value for a single plant and material, though (or a handful). If you need this information for all materials at all plants and need it frequently, which would seem more likely, your ABAPers can use this function in their report. Again, the only info they'll need to pass to it are the plant and material. Hope that works out for you.

[dalong_lu]

thx Corey

i 'll get help from ABAPer, thx for the input!