I_MfgOrderOperationDurnCube

Manufacturing Order Operation Duration - Cube | view: IPPMFGORDEROPDC | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: SCAL_TT_DATEAFKOAFPOAFVCJESTAFVCAFVUAFVVAUFKCRHD
Column Name Description
OrderInternalBillOfOperations Order Internal ID
OrderIntBillOfOperationsItem Internal Identifier of an Operation or Activity
Column Name Description
Column Name Description
Column Name Description
OpErlstSchedldExecStrtDte Earliest Scheduled Execution Start Date
OpErlstSchedldExecStrtTme Earliest Scheduled Execution Start Time
OpErlstSchedldProcgStrtDte Earliest Scheduled Processing Start Date
OpErlstSchedldProcgStrtTme Earliest Scheduled Processing Start Time
OpErlstSchedldTrdwnStrtDte Earliest Scheduled Teardown Start Date
OpErlstSchedldTrdwnStrtTme Earliest Scheduled Teardown Start Time
OpErlstSchedldExecEndDte Earliest Scheduled Execution End Date
OpErlstSchedldExecEndTme Earliest Scheduled Execution End Time
OpLtstSchedldExecStrtDte Latest Scheduled Execution Start Date
OpLtstSchedldExecStrtTme Latest Scheduled Execution Start Time
OpLtstSchedldProcgStrtDte Latest Scheduled Processing Start Date
OpLtstSchedldProcgStrtTme Latest Scheduled Processing Start Time
OpLtstSchedldTrdwnStrtDte Latest Scheduled Teardown Start Date
OpLtstSchedldTrdwnStrtTme Latest Scheduled Teardown Start Time
OpLtstSchedldExecEndDte Latest Scheduled Execution End Date
OpLtstSchedldExecEndTme Latest Scheduled Execution End Time
OperationConfirmedStartDate Operation Confirmed Start Date
OperationConfirmedEndDate Operation Confirmed End Date
OpActualExecutionStartDate Confirmed Start Date of Execution
OpActualExecutionStartTime Confirmed Start Time of Execution
OpActualSetupEndDate Confirmed End Date of Setup
OpActualSetupEndTime Confirmed End Time of Setup
OpActualProcessingStartDate Confirmed Start Date of Processing
OpActualProcessingStartTime Confirmed Start Time of Processing
OpActualProcessingEndDate Confirmed End Date of Processing
OpActualProcessingEndTime Confirmed End Time of Processing
OpActualTeardownStartDate Confirmed Start Date of Teardown
OpActualTeardownStartTme Confirmed Start Time of Teardown
OpActualExecutionEndDate Confirmed End Date of Execution
OpActualExecutionEndTime Confirmed End Time of Execution
ActualExecutionEndDate Confirmed End Date of Execution
ActualExecutionEndTime Confirmed End Time of Execution
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
MfgOrderOperationIsPhase Indicator: Phase Show values
ReportingPeriod Reporting Period Show values
Column Name Description Domain name
ManufacturingOrder Manufacturing Order ID AUFNR
ManufacturingOrderSequence Manufacturing Order Sequence PLNFOLGE
ManufacturingOrderOperation Manufacturing Order Operation VORNR
ManufacturingOrderSubOperation Manufacturing Order Suboperation VORNR
MfgOrderOperationText Manufacturing Order Operation Text TEXT40
MfgOrderPhaseSuperiorOperation Operation/Activity Number VORNR
NumberOfCapacities Number of Capacities Required INT1
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
NumberOfOperationConfirmations Number Of Confirmations CIM_COUNT
OperationIsCreated null
OperationIsReleased null
OperationIsPrinted null
OperationIsConfirmed null
OperationIsPartiallyConfirmed null
OperationIsTechlyCompleted null
OperationIsClosed null
OperationIsScheduled null
OperationIsPartiallyDelivered null
OperationIsDelivered null
WorkCenterTypeCode null
WorkCenter Work Center ARBPL
OperationConfirmation Completion confirmation number for the operation CO_RUECK
CapacityRequirement ID of the Capacity Requirements Record BEDID
CapacityRequirementItem Capacity Requirement Item CIM_COUNT
EndDateHour End Date Hour HOUR2
EndDateWeekDay Week Day NUM1
EndDateWeek Calendar Week NUM2
EndDateMonth Calendar Month NUM2
EndDateYear Calendar Year NUM4
EndDateYearMonth Year Month NUM6
PlannedActualStartDateDvtnDurn null
PlannedActualEndDateDvtnDurn null
PlannedCurrentStrtDateDvtnDurn null
PlannedCurrentEndDateDvtnDurn null
ActualWorkdayDurnInSeconds Actual Duration in Seconds DEC20
PlannedWorkdayDurnInSeconds Planned Duration in Seconds DEC20
DeviationWorkdayDurnInSeconds Deviation Duration in Seconds DEC20
ActualDuration Actual Duration DEC20
PlannedDuration Planned Duration DEC20
DeviationDuration Deviation Between Planned and Actual Duration DEC20
StockSegment Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == TCA01.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Company Code
  • Company Code
  • Client
  • I_MFGORDEROPERATIONDURNCUBE.COMPANYCODE == T001.BUKRS
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MFGORDEROPERATIONDURNCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == TKA01.MANDT
Language Key I_MFGORDEROPERATIONDURNCUBE.LANGUAGE == T002.SPRAS
Manufacturing Order Type
  • Client
  • Manufacturing Order Type
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T003O.CLIENT
  • I_MFGORDEROPERATIONDURNCUBE.MANUFACTURINGORDERTYPE == T003O.AUART
Material Number for Order
  • Client
  • Material Number for Order
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == MARA.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T001W.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.MRPPLANT == T001W.WERKS
Operation Control Profile
  • Client
  • ?
  • Operation Control Profile
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T430.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.[column in domain "PLNAW"] == T430.PLNAW
  • I_MFGORDEROPERATIONDURNCUBE.OPERATIONCONTROLPROFILE == T430.STEUS
Priority
  • Client
  • Priority
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == TCN07.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.OPERATIONIMPORTANCE == TCN07.NPRIO
Production Plant
  • Client
  • Production Plant
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T001W.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.PRODUCTIONPLANT == T001W.WERKS
Production Supervisor
  • Production Supervisor
  • Client
  • Production Plant
  • I_MFGORDEROPERATIONDURNCUBE.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == T024F.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.PRODUCTIONPLANT == T024F.WERKS
Work Center Internal ID
  • Client
  • ?
  • Work Center Internal ID
  • I_MFGORDEROPERATIONDURNCUBE.MANDT == CRID.MANDT
  • I_MFGORDEROPERATIONDURNCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_MFGORDEROPERATIONDURNCUBE.WORKCENTERINTERNALID == CRID.OBJID