Skip to Content
avatar image
Former Member

Tables behind MD04

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 09, 2008 at 12:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded