Tables behind MD04

[Former Member]

Hi SDN Gurus,

I need to create a BI extractor showing schedule mismatch between MRP requirement and Purchasing, identical to what we see in MD04.

However, I cannot figure what tables will provide the data which is behind MD04. I have identified AUSKT, DELBO, UMDAT and DAT00 fields from MDTB but I don't know where to get the purchase order no. from. If I know the relationship and it is more than one table, I can create a view but I need to know the source. How does MD04 bring together MRP and purchasing data?

Will appreciate any help or input.

Thanks.

SM

[Former Member]

HI Shahid,

Technically, MDTB contains data from the MRP run, which would be closer to MD05, not MD04. MD04, on the other hand, displays real-time data. MD04 doesn't look so much at the planning run, but looks at the current situation. Small point, but if you are writing a brand new BI report from scratch, you need to get it right.

If you ONLY want MRP results, then here are the tables which contain most of the data:

MDTB - MRP master table

MDTC - MRP aggregated table items

MDKP - MRP Header Data

MKAL - Production Version Data

MDVM - Planning file data

plus a few master data tables. As you examine these tables, you will notice that MRP encodes some of the data before storing it in the table. Extraction therefore would first require you get an ABABer to decode before extracting. Probably are some BAPIs or Function Modules that will work.

MD04 accesss real time data, and it looks at quite a few tables. It uses data that it gets early on in the program to determine subsequent tables to be accessed. I have never seen a definitive statement that categorically states ALL possible tables that could be accessed by this program.

If you want to know tables behind Purchasing, here are some of the ones that display data in MD04:

Purchase orders

EKKO - Purchase order header

EKPO - Purchase order item

EKET - Scheduling Agreement schedule lines (purchase order schedules)

EKES - Vendor confirmations

Purchase Requisitions

EBAN - Main Purchase Req table

And the requirements side:

VBBE - Sales Requirements

RESB - Reservations

PBID - Planned Independent requirements index

PBED - PIR items

The above lists are not comprehensive! There are more tables. I guess the only way you could know for sure is to go into the SAP MD04 ABAP code.

I have one final suggestion. MD06 is a standard SAP transaction that is designed to look at the MRP results. It will allow you to filter the outputs so that you can see only the exception messages that are of interest to you, and it will also allow you to interactively change any of your orders. Rather than write a program, most people just rely on this program to analyze and manage any MRP problems.

Good Luck!

Regards,

DB49