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.