Check if Work Order was re-opened and when

Adrian P

Hi,

Please let me know which Table and Field where I can check whether a Work Order was re-opened and when.

Thank you very much.

Best Regards,

Adrian Penano

Comments

1 comment

Date Votes
  • Comment author
    Martin Heigl

    you can check this in the history table.

    select "ERFTSTAMP" from "BEAS_AENDERUNG" where "TYP"='WorkOrder' and "TYP2"='WO' and "KENNUNG1"=6002291 and "KENNUNG2"=30 and "NEUINHALT"='öffnen'

    "KENNUNG1"=work order belnr_id
    "KENNUNG2"=work order position belpos_id

    0

Please sign in to leave a comment.