Skip to Content
avatar image
Former Member

PO approver name & PO approval date in an report

Hi,

I am aware that there is no standard SAP report which gives the information of PO approver name and PO approval date. If there is any please let me know.

However we want to develop such report which gives this information and we are bulding logic based on the CDPOS & CDHDR table. Please let me know if there is any other approach to avoid the CDPOS & CDHDR tables in order to avoid any performance issues.

Thanks.

MP

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 22, 2010 at 04:49 AM

    Hi,

    Only CDHDR and CDPOS will help you. There are no other tables. Yoy may use transaction code RSSCD100 also.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2010 at 07:04 AM

    Hi,

    I asked our ABAP to develop a report such as this, and we retrieve the data such as PO Number, Document Category, etc. first then used a Function Module (ME_CHANGEDOC_SELECT) to get the Approver and updated Release Date ->this is actually the Change Logs per PO Number. In the E_OUTTAB of the Function Module, the FNAME Field should be equal to FRGKE (which means Release Indicator) and the F_NEW should be equal to an X mark then get the username and date. Note that there's a sorting to get the most updated detail.

    If there are more than one approver who released the PO, like for example there are 3, we set 3 columns each equivalent to 1-X, 2-XX, 3-XXX marks.

    Add comment
    10|10000 characters needed characters exceeded