Which Table/Function module stores the linking data of eket & vbbe tables ?

[Former Member]

Hello SAP gurus,

We are developing a Z report based on sales order ATP check where we required details regarding incoming future PO (Job work) qty along with the dates which pop-ups during ATP check in sales order. Currently i am getting the details separately for PO (Job work) from EKET table for future dates (EINDT) & for qty (MENGE) and for Sales order details from VBBE table. But i want the overall linking details between EKET and VBBE along with the Job work purchase order no. and the confirmed qty in sales order material from those Job work PO's. So is there any method where we can get all details at one point.

Thanks & Regards

Deven

[Former Member]

Deven,

Here are a couple of paths to check out that may give you the link you need:

• EKET > VBKD on EKET-EBELN = VBKD-BSTKD_E
• EKET > EBAN on EBELN > EBKN on BANFN and BNFPO > VBAK on VBELN

I hope this helps.

Glenn

[Former Member]

Thanks for the reply Glenn. But we don't have the linking of Job work PO based on purchase requisition for this process. There is a FM called "MD_STOCK_REQUIREMENTS_LIST_API" which shows the job work PO's and sales orders qty and the confirmed qty (CO06) but the actual linking between (EBELN & VBELN ) Job work PO's and sales orders with qty, it doesn't serve our purpose.