Open PO

[Former Member]

Hi,

How to fetch the po which has done outbound delivery but not GR. Currently the movement types 101,102,122 and 161 in PO history and does the extraction. If the PO has a Outbound delivery then it will not be included in the extract and once a Goods receipt happens for the Outbound delivery then it will be included in the extraction.

SELECT a_{ebeln a}lifnr a_{loekz b}ebelp b~loekz

b_{aedat b}matnr b_{werks b}elikz c~budat

FROM ekko AS a JOIN ekpo AS b

ON a_{ebeln = b}ebeln

JOIN ekbe AS c

ON ( b_{ebeln = c}ebeln

AND b_{ebelp = c}ebelp )

INTO TABLE t_prod

WHERE b~werks IN s_werks

AND c~vgabe = c_1

AND c~bwart IN r_bwart.

this is the current code for fetching PO. what change can i make to get po which has done outbound delivery but not GR.

[Former Member]

Hi,

How to fetch the po which has done outbound delivery but not GR. Currently the movement types 101,102,122 and 161 in PO history and does the extraction. If the PO has a Outbound delivery then it will not be included in the extract and once a Goods receipt happens for the Outbound delivery then it will be included in the extraction.

SELECT a_{ebeln a}lifnr a_{loekz b}ebelp b~loekz

b_{aedat b}matnr b_{werks b}elikz c~budat

FROM ekko AS a JOIN ekpo AS b

ON a_{ebeln = b}ebeln

JOIN ekbe AS c

ON ( b_{ebeln = c}ebeln

AND b_{ebelp = c}ebelp )

INTO TABLE t_prod

WHERE b~werks IN s_werks

AND c~vgabe = c_1

AND c~bwart IN r_bwart.

this is the current code for fetching PO. what change can i make to get po which has done outbound delivery but not GR.

[former_member125661]

Checkout EKPO-WEPOS - Goods Receipt indicator