Work Order "In Work" in APS
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.
Comments
1 comment
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.