C_OperationActivityWorklistTP

Personal Work Queue | view: CMFGOPAWTP | Extraction: Not supported | Component: Shop Floor Execution
Tables used: AFKO, MPE_COMP_OAI, MPE_OA_I_SAS_STS, MPE_OAI_LBR_ACTN, MPE_OAN_INSTANCE, MPE_OAI_ASS_TEAM, MPE_OAI_ASS_USR, MPE_OA_INSTANCE, AFPO, MPE_EXEC_HOLD, RESB, MPE_SFI_STATUS, JEST, AFVC, AFVU, AFVV, ADCP, ADRC, T002, T002T, AUFK, MARA, MAKT, MPE_WI_CONTENT, MPE_WI_VERSION, MPE_OA_WI, MPE_OAN, MPE_OA_T, T001W, CRTX, MPE_SAS_STATUS, MPE_SAS_STATUS_T, USR21, CRHD, HRP7730, HRP1000, MPE_OAN_ELEMENT
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
UserIsLaboredOn Checkbox Show values
OrderIsTechnicallyCompleted Indicator: Order is Technically Completed 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
WorkCenterTypeCode Object types of the CIM resource Show values
OpActyHasMissingComponents Checkbox Show values
OperationActivityHasProdnHold Checkbox Show values
Column Name Description Domain name
ManufacturingOrder Order number AUFNR
ManufacturingOrderText Manufacturing Order Text TEXT40
ManufacturingOrderImportance Order Importance Code CHAR1
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Operation Short Text TEXT40
StatusAndActionSchema Status and Action Schema MPE_OBJECT_NAME_TYPE
StatusAndActionSchemaStatus Operation Activity Status MPE_OBJECT_NAME_TYPE
SASStatusName Operation Activity Status Description MPE_OBJECT_DESCRIPTION_TYPE
SASStatusCategoryName Short Text for Fixed Values DDTEXT
OpActyExpdExecDurnInSeconds Expected Execution Time of an Operation Activity (Seconds)
OpActyExpdExecLaborDurnInSecs Expected Labor Time (s) to Execute an Operation Activity
OpActyNtwkElementExternalID Operation Activity Number MPE_OAN_ELEMENT_NUMBER_EXT
OpActyNtwkVersionCounter Object Version Number
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
OpActyNtwkSegmentTypeText OA Segment Type Name (Setup, Produce, or Teardown) TEXT60
NumberOfActiveShopFloorItems null
MaterialName Material Description TEXT40
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
NrOfOpActyUserAssignments Number of Operators Assigned
UserID Shop Floor User USNAM
UserDescription User Description SUIDTECHDESC
NrOfOpActyTeamAssignments Number of Teams Assigned
RespyMgmtTeamID Team HROBJID
TeamName Name CHAR40
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
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
WorkInstruction Work Instruction ID MPE_WI_ID
WorkInstructionVersionCounter Work Instruction Version No MPE_WI_VERSION_NO
ProductionHold Number of Production Hold MPE_DOC_NMBR
MfgWorkInstructionContent Work Instruction Content MPE_WI_CONT
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
EffectivityParameterDesc Effectivity Parameter Description CHAR256
MfgOpActyExecutionPriority Execution Priority MPE_OA_EXEC_PRIO
Master Data Relations Join Conditions
Material Number for Order
  • Material Number for Order
  • Client
  • C_OPERATIONACTIVITYWORKLISTTP.MATERIAL == MARA.MATNR
  • C_OPERATIONACTIVITYWORKLISTTP.MANDT == MARA.MANDT
Internal Object Identifier
  • Object Version Number
  • Internal Object Identifier
  • Client
  • C_OPERATIONACTIVITYWORKLISTTP.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
  • C_OPERATIONACTIVITYWORKLISTTP.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
  • C_OPERATIONACTIVITYWORKLISTTP.MANDT == MPE_OAN.MANDT
Plant
  • Plant
  • Client
  • C_OPERATIONACTIVITYWORKLISTTP.PRODUCTIONPLANT == T001W.WERKS
  • C_OPERATIONACTIVITYWORKLISTTP.MANDT == T001W.MANDT
Object ID of the resource
  • Object ID of the resource
  • Object types of the CIM resource
  • Client
  • C_OPERATIONACTIVITYWORKLISTTP.WORKCENTERINTERNALID == CRID.OBJID
  • C_OPERATIONACTIVITYWORKLISTTP.WORKCENTERTYPECODE == CRID.OBJTY
  • C_OPERATIONACTIVITYWORKLISTTP.MANDT == CRID.MANDT