SAP SE16 Tables behind MD04 StockRequirements List

[Minick]

Hello everyone,
we want to recreate the logic of the stock/requirements list (md04). To do this, we need the source data/tables (SE16) behind this process.

Can you please help us here and name the tables and their connections/links to each other to get exactly the same output in the end?

Thank you in advance 🙂

[Minick]

Hello,

I have done a lot of research in the last few days and found the following tables with relationships:

Planned Orders: PLAF

Table	Column	FriendlyName	Table Relationship
PLAF	AUFNR	ProductionOrderNr	AUFK
PLAF	KDAUF	Sales_Order_Number	VBUK
PLAF	KDPOS	Sales_Order_Number_Position	VBUK
PLAF	KONNR	Number_of_Principal_Purchase_Agreement	EKKO
PLAF	KTPNR	Number_of_Principal_Purchase_Agreement_Position	EKPO

Purchase Requistions: EBAN

Table	Column	FriendlyName	Table Relationship
EBAN	EBELN	PurchaseRequestNr	EKPO
EBAN	EBELP	PurchaseRequestNr_Position	EKPO
EBAN	KONNR	Number_of_Principal_Purchase_Agreement	EKKO
EBAN	KTPNR	Number_of_Principal_Purchase_Agreement_Position	EKPO

Purchase Orders EKPO, EKKO, EKKN

Table	Column	FriendlyName	Table Relationship
EKPO	BANFN	BANF	EBAN
EKPO	BNFPO	BANF_Position	EBAN
EKPO	KONNR	Number_of_Principal_Purchase_Agreement	EKKO
EKPO	KTPNR	Number_of_Principal_Purchase_Agreement_Position	EKPO
EKPO	UEBPO	Higher_Level_Item_Purchasing_Documents	EKPO

Table	Column	FriendlyName	Table Relationship
EKKO	KONNR	Number_of_Principal_Purchase_Agreement	EKKO
EKKO	LPONR	Last_Item_Number	EKPO
EKKO	AUSNR	Bid_invitation_number	EKKO

Table	Column	FriendlyName	Table Relationship
EKKN	EBELN	PurchaseRequestNr	EKPO
EKKN	EBELP	PurchaseRequestNr_Position	EKPO
EKKN	VBELN	Sales_Order_Number	VBUK
EKKN	VBELP	Sales_Order_Number_Position	VBUK
EKKN	AUFNR	ProductionOrderNr	AUFK

Material: MSEG, STPO

Table	Column	FriendlyName	Table Relationship
MSEG	KDAUF	Sales_Order_Number	VBUK
MSEG	KDPOS	Sales_Order_Number_Position	VBUK
MSEG	RSNUM	Reservation_Number	RESB
MSEG	RSPOS	Reservation_Number_Position	RESB
MSEG	EBELN	PurchaseRequestNr	EKPO
MSEG	EBELP	PurchaseRequestNr_Position	EKPO
MSEG	AUFNR	ProductionOrderNr	AUFK

Table	Column	FriendlyName	Table Relationship
STPO	STLNR	Bill_of_material	CAUFV
STPO	STLTY	BOM_category	CAUFV

Production Orders: CAUFV(AUFK+AFKO)

Table	Column	FriendlyName	Table Relationship
CAUFV	STLNR	Bill_of_material	STPO
CAUFV	STLTY	BOM_category	STPO
CAUFV	KDAUF	Sales_Order_Number	VBUK
CAUFV	KDPOS	Sales_Order_Number_Position	VBUK

Sales Orders: VBBE, VBEP

Table	Column	FriendlyName	Table Relationship
VBBE	VBELE	Business_document_number	VBUK
VBBE	POSNE	Business_item_number	VBUP
VBBE	ETENE	Schedule_line	VBEP

Table	Column	FriendlyName	Table Relationship
VBEP	BNFPO	BANF_Position	EBAN
VBEP	AUFNR	ProductionOrderNr	AUFK
VBEP	PLNUM	PlannedOrderNr	PLAF
VBEP	VBELE	Business_document_number	VBUK
VBEP	POSNE	Business_item_number	VBUP
VBEP	ETENE	Schedule_line	VBEP

Reservations: RESB

Table	Column	FriendlyName	Table Relationship
RESB	AUFNR	ProductionOrderNr	AUFK
RESB	PLNUM	PlannedOrderNr	PLAF
RESB	BANFN	BANF	EBAN
RESB	BNFPO	BANF_Position	EBAN
RESB	KDAUF	Sales_Order_Number	VBUK
RESB	KDPOS	Sales_Order_Number_Position	VBUK
RESB	EBELN	PurchaseRequestNr	EKPO
RESB	EBELP	PurchaseRequestNr_Position	EKPO

Stock Available: MARD

Nevertheless, I don't know exactly which table I should start with and whether all the information I have collected is correct or whether there might be better options?

Many thanks in advance