Skip to Content
0
Former Member
Nov 07, 2012 at 06:37 PM

retreiving the POs with Tracking numbers

121 Views

Hello All,

My requirement is, i have to retrieve all the POs to the CLOSEDPO report if my PO has shipment tracking number else it should go to OPENPO report.

we are using the field VBKD-BSTKD_E field(Ship-to Party's Purchase Order Number) to update the shipment tracking number.

Inorder to get the POs with tracking number i am joining EKKO with EKKN and VBKD to get the SO(VBELN) from EKKN for a particular PO(EBELN) and inturn retreiving the BSTKD_E for that VBELN.

By doing like this i am missing the POs which dont have a SO.(In our company a PO can exists with out SO, this is like when we get the items from the vendor which will be used for stocking).

Please suggest me how to resolve this scenario.

Thanks,

Uday.