tables for MD04 and MMBE

[Former Member]

Hi all,

I want to extract data from MD04 and MMBE t-code based on Material number and Plant.

I try with fm 'MD_STOCK_REQUIREMENTS_LIST_API', iam getting values but not correct for example Ordernumber(RESB-AUFNR) and also Field RSEB-ABLAD.

Iam looking a table for the structure MDEZ.I check with RESB table but some fields like MDEZ-DELB0,MDEZ-EXTRA could not find in the table.

Thanks in advance,

Vicky

[RichHeilman]

You can look at the inventory(MMBE) in table MARD and MSKA.

Regards,

Rich Heilman

[RichHeilman]

I believe that you can use MDKP and MDTB for looking at the MRP elements.

It would probably be better to use the API.

Regards,

Rich Heilman

[Former Member]

I didnt find any entries in the MDKP and MDTB tables for the MRP Elements.

But when i enter Material number and plant im getting the all the like PO item,reservation numbers,Purchase Requistions in the T-code

Thanks,

Vicky

[ferry_lianto]

Hi Vicky,

You may take a look at table <b>T457T</b> for MRP element data information and FM <b>MD_MRP_LIST_API</b>.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

I got the information from T457T table but in that table based on MRP Element im getting the other fields information.

But how to find which MRP Element is assigned to the material number and plant.

Because im gettting material number and Plant from the external system based on that input i have to extract the information from MD04 t-code

[Former Member]

Hi Vicky,

For MMBE data..Use table MARD for stocks..

MARD-LABST-->Unrestricted

MARD-EINME-->Restricted

MARD-SPEME-->Blocked

MARD-INSME-->Quality

RESB-BDMNG-->Reserved

FM 'MB_ADD_RESERVATION_QUANTITIES' -->For reserver qty..

FM 'MB_SELECT_SD_SCHEDULED_STOCK'--> Scheduled for Delivery Stock