Purchase Order

[Former Member]

Hi

I wonder how should i achieve the below items for a custom open Purchase Order report

1) Still to be delivered and

2) still to be invoiced qty.

Please advise the logic with the tables and fields involved.

Rgds

MM

Moderator Message: Please use a more meaningful subject in future.

Edited by: Suhas Saha on Feb 8, 2012 11:08 AM

[Former Member]

Hi

I wonder how should i achieve the below items for a custom open Purchase Order report

1) Still to be delivered and

2) still to be invoiced qty.

Please advise the logic with the tables and fields involved.

Rgds

MM

Moderator Message: Please use a more meaningful subject in future.

Edited by: Suhas Saha on Feb 8, 2012 11:08 AM

[Former Member]

Hi,

Depending on your requirement you can use the following tables:-

vbak,vbap,mara,kna1,vbup,vbep,eban,mard,marc,vbpa,vbfa,tvkot.

main tables are

VBAP, VBEP, VBAK, EBAN

Edited by: Nishantbhargava on Feb 8, 2012 9:40 AM

[Former Member]

This message was moderated.

[kesavadas_thekkillath]

1) You can use the view MDUB to get the details for still to be delivered. So still to be delivered = MENGE - WEMNG.

Now for Still to be invoiced the formula is , Still to be invoiced = GR Quantity - Total invoiced quantity

The invoiced Quantity will be available in RSEG and GR quantity will be available in EKBE

2) The details are available through transaction ME2L, Just gothorugh the logic written in it.

3) You can also use the class CL_PO_ITEM_HANDLE_MM and method GET_HISTORY which will give you all the details.

Refer wiki [Purchase Order Data Extraction using ABAP Classes|http://wiki.sdn.sap.com/wiki/display/ABAP/PurchaseOrderDataExtractionusingABAPClasses]