topic Re: Purchase Order in Application Development and Automation Discussions

Purchase Order

Former Member — Wed, 08 Feb 2012 01:52:00 GMT

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

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

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

Former Member — Wed, 08 Feb 2012 04:07:55 GMT

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 — Wed, 08 Feb 2012 05:28:07 GMT

This message was moderated.

kesavadas_thekkillath — Wed, 08 Feb 2012 05:35:10 GMT

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]