I_OperationActivityWorklistTP

Personal Work Queue | view: IMFGOPAWTP | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
OpActyNtwkInstance FK Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
Column Name Description
Column Name Description
📏 Operation Activity Unit of Measure (ProductionUnit):
OpPlannedYieldQuantity Operation Activity Expected Yield
OpPlannedScrapQuantity Operation Activity Expected Scrap
OperationExecutionAvailableQty Quantity Available for Execution
📏 Duration Unit of Measure (DurationUnit):
OpActyExpdExecutionDuration Expected Execution Time of an Operation Activity
OpActyExpdExecutionLaborDurn Expected Labor Time of an Operation Activity
Column Name Description
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
SASStatusCategory Status Category Show values
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
OpActyConfIsSFIBased Operation Activity Network with Material Confirmation Show values
OpActyIsSeldForRtactvPostg Retroactive Processing Show values
Column Name Description Domain name
UserID Shop Floor User USNAM
OpActyNtwkElementElement Identifies an Operation Activity Network Element MPE_OAN_ELEMENT_ID
OpActyNtwkElementElmntVersCntr Number of the Operation Activity Network Element Version
ManufacturingOrder Order number AUFNR
ManufacturingOrderOperation Operation/Activity Number VORNR
MfgOrderOperationText Operation Short Text TEXT40
WorkCenter Work Center ARBPL
StatusAndActionSchema Status and Action Schema MPE_OBJECT_NAME_TYPE
StatusAndActionSchemaStatus Operation Activity Status MPE_OBJECT_NAME_TYPE
OpActyExpdExecDurnInSeconds Expected Execution Time of an Operation Activity (Seconds)
OpActyExpdExecLaborDurnInSecs Expected Labor Time (s) to Execute an Operation Activity
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OpActyNtwkVersionCounter Object Version Number
NrOfOpActyUserAssignments Number of Operators Assigned
NrOfOpActyTeamAssignments Number of Teams Assigned
RespyMgmtTeamID Team HROBJID
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID General counter for order CO_APLZL
OperationActivity Identifies an Operation Activity MPE_OAN_ELEMENT_ID
OperationActyVersionCounter Number of an Operation Actiivity Version
ProductionHold Number of Production Hold MPE_DOC_NMBR
OpLtstSchedldExecStrtDteTme Date/Time Put on Hold TZNTSTMPS
OpLtstSchedldExecEndDteTme Date/Time Put on Hold TZNTSTMPS
OpActualExecutionStartDateTime Date/Time Put on Hold TZNTSTMPS
OpActualExecutionEndDateTime Date/Time Put on Hold TZNTSTMPS
MfgOpActyExecutionPriority Execution Priority MPE_OA_EXEC_PRIO
Master Data Relations Join Conditions
Internal Object Identifier
  • Object Version Number
  • Client
  • Internal Object Identifier
  • I_OPERATIONACTIVITYWORKLISTTP.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
  • I_OPERATIONACTIVITYWORKLISTTP.MANDT == MPE_OAN.MANDT
  • I_OPERATIONACTIVITYWORKLISTTP.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
Plant
  • Plant
  • Client
  • I_OPERATIONACTIVITYWORKLISTTP.PRODUCTIONPLANT == T001W.WERKS
  • I_OPERATIONACTIVITYWORKLISTTP.MANDT == T001W.MANDT
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • I_OPERATIONACTIVITYWORKLISTTP.WORKCENTERINTERNALID == CRID.OBJID
  • I_OPERATIONACTIVITYWORKLISTTP.WORKCENTERTYPECODE == CRID.OBJTY
  • I_OPERATIONACTIVITYWORKLISTTP.MANDT == CRID.MANDT