Work Order "In Work" in APS

Adrian P

• June 02, 2021 22:45

Hi,

Please let me know which Table and Field corresponds to "In Work" Work Order. I can only see if a Work Order is In Work in the APS window. I'm creating a report for a customer that wants to exclude In Work Work Order (refer to the attached screenshot).

Thank you very much.

Vote

1

• 

  Martin Heigl

  • June 03, 2021 03:49

  select (... BEAS_FTPOS - FIELDS ...)
  case when (select count(*) from "BEAS_FTSTMP" where "BEAS_FTSTMP"."BELNR_ID" = "BEAS_FTPOS"."BELNR_ID" and "BEAS_FTSTMP"."BELPOS_ID"="BEAS_FTPOS"."BELPOS_ID" ) > 0 then 1 else 0 end as inWork

  from "BEAS_FTPOS"

  or use Beas-View: BEASV_WORKORDER_POS

  http://help.beascloud.com/script/index.html?beasv_workorder_pos.htm

   

Please sign in to leave a comment.