I_OrderOperationDatesQty

Order Operation Dates | view: IORDOPDATESQTY | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFVV
Column Name Description
OrderInternalID Routing number of operations in the order
OrderOperationInternalID FK General counter for order
Column Name Description
Column Name Description
📏 Unit of Measure for Business Process Quantity (BusinessProcessEntryUnit):
BusinessProcessConfirmedQty Confirmed Quantity/Activity for Business Process
📏 Unit for Remaining Quantity of Business Process (BusinessProcRemainingQtyUnit):
BusinessProcessRemainingQty Remaining Quantity for Business Process
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit1):
WorkCenterStandardWorkQty1 Standard Value
ForecastWorkQuantity1 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit2):
WorkCenterStandardWorkQty2 Standard Value
ForecastWorkQuantity2 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit3):
WorkCenterStandardWorkQty3 Standard Value
ForecastWorkQuantity3 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit4):
WorkCenterStandardWorkQty4 Standard Value
ForecastWorkQuantity4 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit5):
WorkCenterStandardWorkQty5 Standard Value
ForecastWorkQuantity5 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit6):
WorkCenterStandardWorkQty6 Standard Value
ForecastWorkQuantity6 Forecast Value for Updating of Standard Value
📏 Unit for work (OpWorkQuantityUnit):
OpPlannedWorkQuantity Work involved in the activity
ActualWorkQuantity Actual work
ForecastWorkQuantity Forecasted work (actual + remaining)
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit1):
OpConfirmedWorkQuantity1 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit2):
OpConfirmedWorkQuantity2 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit3):
OpConfirmedWorkQuantity3 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit4):
OpConfirmedWorkQuantity4 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit5):
OpConfirmedWorkQuantity5 Already Confirmed Activity
📏 Unit of measure for the activity to be confirmed (OpWorkQuantityUnit6):
OpConfirmedWorkQuantity6 Already Confirmed Activity
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
OpPlannedTotalQuantity Operation Total Quantity
OpPlannedScrapQuantity Operation Planned Scrap Quantity
OpTotalConfirmedYieldQty Total Confirmed Yield
OpTotalConfirmedScrapQty Total Scrap Quantity Confirmed
OperationConfirmedReworkQty Total Confirmed Rework Quantity
OpTotConfdYieldQtyInOrdQtyUnit Confirmed yield in order unit of measure
📏 Unit for a Break Time (BreakDurationUnit):
PlannedBreakDuration Break Time
ConfirmedBreakDuration Confirmed Break Time
📏 Unit for the Minimum Overlap Time (OverlapMinimumDurationUnit):
OverlapMinimumDuration Minimum Overlap Time
📏 Unit for the Maximum Wait Time (MaximumWaitDurationUnit):
MaximumWaitDuration Maximum Wait Time
📏 Unit for the Required Wait Time (MinimumWaitDurationUnit):
MinimumWaitDuration Minimum Wait Time
📏 Unit for the standard move time (StandardMoveDurationUnit):
StandardMoveDuration Standard Move Time
📏 Unit for the Standard Queue Time (StandardQueueDurationUnit):
StandardQueueDuration Standard Queue Time
📏 Unit for the Minimum Queue Time (MinimumQueueDurationUnit):
MinimumQueueDuration Minimum Queue Time
📏 Unit for the minimum move time (MinimumMoveDurationUnit):
MinimumMoveDuration Minimum Move Time
📏 Normal duration/unit (OperationStandardDurationUnit):
OperationStandardDuration Normal duration of the activity
📏 Unit for the minimum duration (MinimumDurationUnit):
MinimumDuration Minimum activity duration
📏 Unit of the forecasted duration from the confirmation (ActualForecastDurationUnit):
ActualForecastDuration Forecasted duration of activity from confirmation
📏 Unit for forecast normal duration (FcstdStandardDurationUnit):
ForecastedStandardDuration Normal duration (from forecast) of activity
📏 Unit for forecast minimum duration (ForecastedMinimumDurationUnit):
ForecastedMinimumDuration Minimum duration (from forecast) for activity
📏 Unit for Offset to Start (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to sub-operation start
EndDateOffsetDuration Offset to sub-operation finish
Column Name Description
OpErlstSchedldExecStrtDte Earliest scheduled start: Execution (date)
OpErlstSchedldExecStrtTme Earliest scheduled start: Execution (time)
OpErlstSchedldProcgStrtDte Earliest scheduled start: Processing (date)
OpErlstSchedldProcgStrtTme Earliest Scheduled Start: Processing (Time)
OpErlstSchedldTrdwnStrtDte Earliest scheduled start: Teardown (date)
OpErlstSchedldTrdwnStrtTme Earliest Scheduled Start: Teardown (Time)
OpErlstSchedldExecEndDte Earliest scheduled finish: Execution (date)
OpErlstSchedldExecEndTme Earliest scheduled finish: Execution (time)
EarliestScheduledWaitStartDate Earliest Scheduled Wait Start Date
EarliestScheduledWaitStartTime Earliest Scheduled Wait Start Time
EarliestScheduledWaitEndDate Earliest Scheduled Wait End Date
EarliestScheduledWaitEndTime Earliest Scheduled Wait End Time
OpLtstSchedldExecStrtDte Latest scheduled start: Execution (date)
OpLtstSchedldExecStrtTme Latest scheduled start: Execution (time)
OpLtstSchedldProcgStrtDte Latest Scheduled Start: Processing (Date)
OpLtstSchedldProcgStrtTme Latest Scheduled Start: Processing (Time)
OpLtstSchedldTrdwnStrtDte Latest Scheduled Start: Teardown (Date)
OpLtstSchedldTrdwnStrtTme Latest Scheduled Start: Teardown (Time)
OpLtstSchedldExecEndDte Latest scheduled finish: Execution (date)
OpLtstSchedldExecEndTme Latest scheduled finish: Execution (time)
LatestScheduledWaitStartDate Latest Scheduled Wait Start Date
LatestScheduledWaitStartTime Latest Scheduled Wait Start Time
LatestScheduledWaitEndDate Latest Scheduled Wait End Date
LatestScheduledWaitEndTime Latest Scheduled Wait End Time
OperationConfirmedStartDate Actual Operation Start Date
OperationConfirmedEndDate Actual Operation End Date
OpActualExecutionStartDate Actual Execution Start Date
OpActualExecutionStartTime Actual Execution Start Time
OpActualSetupEndDate Actual Setup End Date
OpActualSetupEndTime Actual Setup End Time
OpActualProcessingStartDate Actual Processing Start Date
OpActualProcessingStartTime Actual Processing Start Time
OpActualProcessingEndDate Actual Processing End Date
OpActualProcessingEndTime Actual Processing End Time
OpActualTeardownStartDate Actual Teardown Start Date
OpActualTeardownStartTme Actual Teardown Start Time
OpActualExecutionEndDate Actual Execution End Date
OpActualExecutionEndTime Actual Execution End Time
ActualForecastEndDate Forecast finish date of operation from confirmation
ActualForecastEndTime Forecast End Time of Operation from Confirmation
SchedldFcstdEarliestStartDate Earliest scheduled start date (forecast)
SchedldFcstdEarliestStartTime Earliest scheduled start time (forecast)
SchedldFcstdEarliestEndDate Earliest scheduled finish date (forecast)
SchedldFcstdEarliestEndTime Earliest scheduled finish time (forecast)
LatestSchedldFcstdStartDate Latest scheduled start date (forecast)
SchedldFcstdLatestStartTime Latest scheduled start time (forecast)
LatestSchedldFcstdEndDate Latest scheduled finish date (forecast)
SchedldFcstdLatestEndTime Latest scheduled finish time (forecast)
ConstraintDateForBscStartDate Constraint for activity start (Basic)
ConstraintTimeForBscStartTime Constraint for activity start time (Basic)
ForecastedStartDate Forecasted start date for the activity
ForecastedStartTime Forecast start time of the activity
ForecastedEndDate Forecast finish date
ForecastedEndTime Forecast finish time for the activity
OpDispatchedExecStartDate Dispatched start date for operation
OpDispatchedExecStartTime Dispatched start time for operation
OpDispatchedExecEndDate Dispatched finish date
OpDispatchedExecEndTime Dispatched finish time
Column Name Description
NoFurtherBusinessProcQtyIsExpd No Remaining Quantity Expected for Business Process Show values
ActyBscStartDateConstraintType Constraint on the basic start date for the activity Show values
ActyBscEndDateConstraintType Constraint on the finish date of the activity Show values
ActyFcstEndDateConstraintType Forecast date constraint on activity finish Show values
ActyFcstStartDteConstraintType Forecast date constraint on activity start Show values
Column Name Description Domain name
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
ScheduledMoveDuration Move Time used for Scheduling CX_ZEIT
ScheduledQueueDuration Queue Time Used for Scheduling CX_ZEIT
ScheduledWaitDuration Wait Time Used for Scheduling CX_ZEIT
PlannedDeliveryDuration Planned Delivery Time in Days DEC3
OpPlannedSetupDurn Setup Time CX_ZEIT
OpPlannedProcessingDurn Processing Time CX_ZEIT
OpPlannedTeardownDurn Teardown CX_ZEIT
ForecastProcessingDuration Processing time (forecast) CX_ZEIT
BasicDatesFreeFloat Free float PUFFER
TotalFloatForBasicDates Total float PUFFER
TotalFloatForForecastedDates Total float (from forecast) PUFFER
ForecastedDatesFreeFloat Free float (from forecast) PUFFER
Master Data Relations Join Conditions
Unit of the forecasted duration from the confirmation
  • Client
  • Unit of the forecasted duration from the confirmation
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.ACTUALFORECASTDURATIONUNIT == T006.MSEHI
Unit for a Break Time
  • Client
  • Unit for a Break Time
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.BREAKDURATIONUNIT == T006.MSEHI
Unit for Offset to Finish
  • Unit for Offset to Finish
  • Client
  • I_ORDEROPERATIONDATESQTY.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Reference Date for Finish of Sub-Operation I_ORDEROPERATIONDATESQTY.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Unit for forecast normal duration
  • Client
  • Unit for forecast normal duration
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.FCSTDSTANDARDDURATIONUNIT == T006.MSEHI
Unit for forecast minimum duration
  • Client
  • Unit for forecast minimum duration
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.FORECASTEDMINIMUMDURATIONUNIT == T006.MSEHI
Unit for the Maximum Wait Time
  • Unit for the Maximum Wait Time
  • Client
  • I_ORDEROPERATIONDATESQTY.MAXIMUMWAITDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Unit for the minimum duration
  • Unit for the minimum duration
  • Client
  • I_ORDEROPERATIONDATESQTY.MINIMUMDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Unit for the minimum move time
  • Unit for the minimum move time
  • Client
  • I_ORDEROPERATIONDATESQTY.MINIMUMMOVEDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Unit for the Minimum Queue Time
  • Client
  • Unit for the Minimum Queue Time
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.MINIMUMQUEUEDURATIONUNIT == T006.MSEHI
Unit for the Required Wait Time
  • Unit for the Required Wait Time
  • Client
  • I_ORDEROPERATIONDATESQTY.MINIMUMWAITDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Normal duration/unit
  • Client
  • Normal duration/unit
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.OPERATIONSTANDARDDURATIONUNIT == T006.MSEHI
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.OPERATIONUNIT == T006.MSEHI
Unit for work
  • Unit for work
  • Client
  • I_ORDEROPERATIONDATESQTY.OPWORKQUANTITYUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Unit for the Minimum Overlap Time
  • Client
  • Unit for the Minimum Overlap Time
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.OVERLAPMINIMUMDURATIONUNIT == T006.MSEHI
Unit for the standard move time
  • Client
  • Unit for the standard move time
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.STANDARDMOVEDURATIONUNIT == T006.MSEHI
Unit for the Standard Queue Time
  • Unit for the Standard Queue Time
  • Client
  • I_ORDEROPERATIONDATESQTY.STANDARDQUEUEDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
Unit for Offset to Start
  • Client
  • Unit for Offset to Start
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference Date for Start of Sub-Operation I_ORDEROPERATIONDATESQTY.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT1 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT2 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT3 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT4 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT5 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATESQTY.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATESQTY.WORKCENTERSTANDARDWORKQTYUNIT6 == T006.MSEHI