11-13-2007 1:05 AM
Dear All,
I have to create a report to display the data of open po based on payment term, GR stage (delivery status), delivery date and po issuance date. Can anyone please guide me how should i filter out the blocked po, deleted po and only display out the open po?
Thanks alot!
Best Regards,
PC
11-19-2007 6:14 AM
EKKO table
field FRGKE Release indicator: purchasing document
T16FB(Check table)
to see whether PO is blocked or not.
EKPO
field LOEKZ Deletion indicator in purchasing document
Based on this 2 conditions....write a select query to get the fields as per your requirement
11-20-2007 12:22 AM
Hi,
I had check with the MM user, they didn't use EKKO-FRGKE or table T16FB.
If they want to block PO they will tick the delivery completed indicator, for delete indicator is EKPO-LOEKZ.
So I wrote :
IF NOT EKPO-LOEKZ = 'L'.
IF NOT EKPO-ELIKZ = 'X'. :
:
proceed my specify function.
but it seems like not functioning. I still can get blocked and deleted po from my report.