Last PO

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #23062 Reply
    sarahhall10
    Participant

    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.

    #23076 Reply
    Edward T
    Participant

    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

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: Reply #23076 in Last PO
Your information:



Your email address will not be published. Required fields are marked *

Page last updated by sarahhall10 on