Last PO

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #23062
    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
    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)
  • You must be logged in to reply to this topic.
Page last updated by sarahhall10 on