Open PO, Open SA, Open OA contracts and Consignment

[former_member602116]

Hi All,

I have a requirement to display

Buyer
Porg
PO#
POItem #
Material
ItemCategory

for Open POs ( PO Qty > GR Qty and Delivery Complete = Blank)

Open SAs ( SA Qty> GR Qty and SA End Date > today)

Open OA contracts ( Contract End Date > today) .

My question is how do I retrieve the value for GR quantity and SA quantity? I only know that PO quantity is

EKPO-MENGE.

[lingaiahvanam · Accepted solution]

Hi,

Please refer to the following tables and get the required information, if you would like to generate a custom report based on your requirement provide the table and fields information to the technical team to write the custom program.

EKKO - Purchasing Document Header

EKPO - Purchasing Document Item

EKBE - History per Purchasing Document

EKET - Scheduling Agreement Schedule Lines

EKEK - Header Data for Scheduling Agreement Releases

Best Regards,

Lingaiah

[former_member602116 · Accepted solution]

Hi,

I used EKKO, EKPO AND EKBE tables. Thank you.

[former_member87817]

Hi,

Look out in these tables:

Akshat