HOW WE FIND OUT OPEN PURCHASE ORDER AND CLOSED PURCHASE IN THE TABLE?

[Former Member]

HI,

PLZZ HELP ME.

what are fields names for open purchase order and closed purchase order

thanks

[RoySayak]

Before posting pls search SDN..

Best Regards,

Sayak..

[Former Member]

Hi param,

Go to mseg table, pass the purchase order number and purchase order item. if the mseg-menge = ekpo-menge for the corresponding purchase order then consider the purchase order is close, else it is still open. even check if the entries are not there for corresponding purchase order in mseg table then also it is open.

select mblnr zeile matnr menge from mseg into it_mseg where ebeln = it_ekko-ebeln

and ebelp = it_ekpo-ebeln.

if sy-subrc <> 0.

then consider the purchase order is open.

This is the first case.

even u can consider like this

if sy-subrc = 0.

if it_ekpo-menge > it_mseg-menge.

then also the purchase order is open.

Regards,

Santosh Kumar M.

Award points if it is useful.

[Former Member]

Hi,

go through this link

Rewards if usefull.