[sarahhall10]

Is there a report or table that shows me the last approved PO for a material? I do not want a list of all POs for specific materials, strictly the last approved PO.

[Edward T]

Hi,

I’m not sure if there is a standard report for your requirement. You can develop a custom report for this, but it not a simple task and performance wise willbe not really good, as we need to read the change log table.

First you need to get all PO number from table EKKO with status released (EKKO-FRGRL = BLANK)
Then based on PO numbers you got, use table CDHDR + CDPOS to get the change log data.
use
CDHDR-OBJECTCLAS = ‘EINKBELEG’
CDHDR-OBJECTID = PO Number
and need to sort by latest date and time

Then use the same condition for CDPOS table and restrict by
CDPOS-TABNAME = ‘EKKO’
CDPOS-FNAME = ‘FRGRL’
CDPOS-VALUE_OLD = ‘X’
CDPOS-VALUE_NEW = BLANK

then after get the first match exit the process.

Regards,
Edward

[Author]

Posts