Hello,
I have to create a report indicating at which code the PO/OA is help up for approval. Also co-relate the same when was the release status was created / changed and currently which dates the release codes were applied.
e.g. PO was created at Oct 01, 2009 and subsequently approved, The PO was changed on Nov 01, 2009 with three (N1, N2 and N3) as Release Codes.
N1 has approved on Nov 01, 2009
N2 has approved on Dec 01, 2009
and is still pending with N3
The report should pick-up Release status change date as Nov 01, 2009 and Dec 01, 2009 as date with N3 code.
Which tables stores relevant release dates / status. I can not use CDPOS / CDHDR.
Thanks,