Check if Work Order was re-opened and when

Adrian P

• June 08, 2021 19:57

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

Vote

1

• 

  Martin Heigl

  • June 09, 2021 03:15

  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

Please sign in to leave a comment.