I_UserOpenOpActyAssignment

Open operation activities assigned to an user | view: IMPEUSROPNOA | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
UserID null
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
Column Name Description
Column Name Description
OpActyNtwkSegmentType OA Segment Type (Setup, Produce, or Teardown) Show values
OpActyConfIsSFIBased Operation Activity Network with Material Confirmation Show values
OpActyConfirmationIsAllowed Confirmation Allowed Show values
OpActyConfNotAllowedReason Confirmation not Allowed - Reason Show values
OpActyNtwkElementType OAN Element Type Show values
DateIsActualDate Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
ManufacturingOrder Order number AUFNR
OrderInternalID Routing number of operations in the order AUFPL
OrderOperationInternalID General counter for order CO_APLZL
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)
OpActyNtwkVersionCounter Object Version Number
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OperationActivity Identifies an Operation Activity MPE_OAN_ELEMENT_ID
OperationActyVersionCounter Number of an Operation Actiivity Version
OperationActivityName Operation Activity Description MPE_OAN_OBJECT_DESCRIPTION
ManufacturingOrderOperation Operation/Activity Number VORNR
MfgOrderOperationText Operation Short Text TEXT40
WorkCenter Work Center ARBPL
WorkCenterTypeCode null
CreatedByUser Created By USNAM
CreationDateTime Date and Time of Creation TZNTSTMPS
MfgOpActyExecutionPriority Execution Priority MPE_OA_EXEC_PRIO
OpLtstSchedldExecStrtDteTme Scheduled Operation Start TZNTSTMPS
Master Data Relations Join Conditions
Internal Object Identifier
  • Internal Object Identifier
  • Client
  • Object Version Number
  • I_USEROPENOPACTYASSIGNMENT.OPERATIONACTIVITYNETWORK == MPE_OAN.ID
  • I_USEROPENOPACTYASSIGNMENT.MANDT == MPE_OAN.MANDT
  • I_USEROPENOPACTYASSIGNMENT.OPACTYNTWKVERSIONCOUNTER == MPE_OAN.VERSION_NO
Plant
  • Plant
  • Client
  • I_USEROPENOPACTYASSIGNMENT.PRODUCTIONPLANT == T001W.WERKS
  • I_USEROPENOPACTYASSIGNMENT.MANDT == T001W.MANDT
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • I_USEROPENOPACTYASSIGNMENT.MANDT == CRID.MANDT
  • I_USEROPENOPACTYASSIGNMENT.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_USEROPENOPACTYASSIGNMENT.WORKCENTERINTERNALID == CRID.OBJID