Release date of PO
In which table I can find the date on which the PO was released.
I could not find the release date of PO in EKKO.
I need to develop a report in which PO are to be included as per the release date not the document date(PO creation date).
Pankaj Singh replied
Release Date is not available directly in any Table.
But, you can get this using following tables;
- CDHDR - Change document header
- CDPOS - Change document items
Go to table CDHDR, here pass PO No in field "CDHDR-OBJECTID" and Transaction as ME29N in field "CDHDR-TCODE" and get the Document Number from field "CDHDR-CHANGENR" and date of changes happened "CDHDR-UDATE" (Take this as Release Date)
Then go to table CDPOS and pass the Field value "CHANGENR" and get the change details. And here get the New Value (CDPOS-VALUE_NEW) for Release