I_OrderOperationDateTime

Order Operation Date and Time as Timestamp | view: IORDOPTSTMPS | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFVC, AFVU, AFVV, ADCP, ADRC, T001W
Column Name Description
OrderInternalID Routing number of operations in the order
OrderOperationInternalID General counter for order
Column Name Description
💲 Currency Key (Currency):
OpExternalProcessingPrice Price
NetworkActivityCost Costs in the activity
FreeDefinedAmount1 User-defined field for values (length 10,3)
FreeDefinedAmount2 User-defined field for values (length 10,3)
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
WorkCenterStandardWorkQty2 Standard Value
WorkCenterStandardWorkQty3 Standard Value
WorkCenterStandardWorkQty4 Standard Value
WorkCenterStandardWorkQty5 Standard Value
WorkCenterStandardWorkQty6 Standard Value
ForecastWorkQuantity1 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 Measurement of Standard Value (WorkCenterStandardWorkQtyUnit2):
ForecastWorkQuantity2 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit3):
ForecastWorkQuantity3 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit4):
ForecastWorkQuantity4 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit5):
ForecastWorkQuantity5 Forecast Value for Updating of Standard Value
📏 Unit of Measurement of Standard Value (WorkCenterStandardWorkQtyUnit6):
ForecastWorkQuantity6 Forecast Value for Updating of Standard Value
📏 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
PlannedBreakDuration Break Time
ConfirmedBreakDuration Confirmed Break Time
OverlapMinimumDuration Minimum Overlap Time
MaximumWaitDuration Maximum Wait Time
MinimumWaitDuration Minimum Wait Time
StandardMoveDuration Standard Move Time
StandardQueueDuration Standard Queue Time
MinimumQueueDuration Minimum Queue Time
MinimumMoveDuration Minimum Move Time
OperationStandardDuration Normal duration of the activity
MinimumDuration Minimum activity duration
ActualForecastDuration Forecasted duration of activity from confirmation
ForecastedStandardDuration Normal duration (from forecast) of activity
ForecastedMinimumDuration Minimum duration (from forecast) for activity
StartDateOffsetDuration Offset to sub-operation start
EndDateOffsetDuration Offset to sub-operation finish
FreeDefinedQuantity1 User field for quantity (length 10.3)
FreeDefinedQuantity2 User field for quantity (length 10.3)
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)
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)
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
FreeDefinedDate1 User field for date
FreeDefinedDate2 User field for date
Column Name Description
BillOfMaterialCategory BOM category Show values
OperationIsToBeDeleted Deletion Flag Show values
OperationOverlappingIsRequired Required Overlapping Show values
OperationOverlappingIsPossible Optional Overlapping Show values
OperationsIsAlwaysOverlapping Flow Manufacturing Show values
OperationSplitIsRequired Splitting Required Show values
PurgInfoRecdDataIsFixed Data of Purchasing Info Record Is Fixed Show values
PurchasingInfoRecordCategory Purchasing info record category Show values
OperationCalculationControl Key for calculation Show values
NtwkAccountAssignmentCode Indicator for the account assignment of a network(hdr/act.) Show values
ActyIsTakenAcctForProjSmmry Ind.: Respect Activity for Project Summarization Show values
ControllingObjectClass Controlling Object Class Show values
NoFurtherBusinessProcQtyIsExpd No Remaining Quantity Expected for Business Process Show values
NoFurtherOpWorkQuantity1IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherOpWorkQuantity2IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherOpWorkQuantity3IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherOpWorkQuantity4IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherOpWorkQuantity5IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherOpWorkQuantity6IsExpd Indicator: No Remaining Activity Expected Show values
NoFurtherWorkQuantityIsExpd Indicator: No Remaining Work Expected Show values
MfgOrderOperationIsPhase Indicator: Phase Show values
OpSchedldReductionLevel Reduction Level Which Reduces Operation Lead Time Show values
MaterialPlanningRelevance Effective for Materials Planning 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
FreeDefinedIndicator1 User-defined field: Indicator for reports Show values
FreeDefinedIndicator2 User-defined field: Indicator for reports Show values
Column Name Description Domain name
Sequence Sequence PLNFOLGE
Operation Operation/Activity Number VORNR
BillOfOperationsSequence Sequence PLNFOLGE
BillOfOperationsGroup Key for Task List Group PLNNR
BillOfOperationsVariant Group Counter ALTNR
BOOOperationInternalID Number of the Task List Node KNTNR
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterialInternalID Bill of Material STNUM
BillOfMaterialItemNodeNumber BOM item node number KNTNR
BOMItemNodeCount Internal counter CIM_COUNT
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
WorkCenterTypeCode null
PlantName Plant Name TEXT30
CapacityRequirement ID of the Capacity Requirements Record BEDID
CapacityRequirementItem Internal counter CIM_COUNT
ActualNumberOfSplits Actual number of splits DEC3
NumberOfCapacities Number of capacities required INT1
NetworkActivityPriority Priority PRIORITAET
OperationWorkPercent Work percentage INT1
OperationConfirmation Completion confirmation number for the operation CO_RUECK
NumberOfOperationConfirmations Confirmation counter CIM_COUNT
NumberOfOperationExecutions Execution Factor AFAKT
OperationText Operation Short Text TEXT40
NumberOfTimeTickets Number of Time Tickets LOHNANZ
EmployeeWageType Wage type LOART
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
Personnel Personnel number PERNR
NumberOfEmployees Number of employees ANZMA
OperationScrapPercent Scrap factor AUSCHUFAK
MaximumNumberOfSplits Maximum Number of Splits SPLITTANZ
OverheadCode Overhead key CHAR6
OperationPurgInfoRecdSearchTxt Sort Term for Non-Stock Info Records CHAR10
ExtProcgOperationHasSubcontrg Indicator: External Processing Operation with Subcontracting CHAR1
PurchaseRequisition Purchase Requisition Number BANFN
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
CostingVariant Costing Variant KLVAR
CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
CostingSheet Costing Sheet KALSM
BusinessProcess Business Process CO_PRZNR
OrderIntBillOfOpItemOfPhase General counter for order CO_APLZL
DependencyObjectNumber Number of Object with Assigned Dependencies KNOBJ
LineHierarchyInternalID Object ID NUM08
InspectionSubSystem Subsystem Identifier for QM Subsystem Interface QEIFSUBSYS
ServicePackage Package number PACKNO
ProductConfiguration Configuration (internal object number) CUOBJ
ProgressAnlysAggregationWeight Aggregation weight for POC (PS progress) DEC8
OperationRequisitionerName Name of requisitioner/requester AFNAM
OperationTrackingNumber Requirement Tracking Number CHAR10
ExchangeRate Exchange Rate KURSP
BillingPlan Billing plan number / invoicing plan number FPLNR
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
OpErlstSchedldExecStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpErlstSchedldProcgStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpErlstSchedldTrdwnStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpErlstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpLtstSchedldExecStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpLtstSchedldProcgStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpLtstSchedldTrdwnStrtDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpLtstSchedldExecEndDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualExecutionStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualSetupEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualProcessingStartDteTme UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualProcessingEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualTeardownStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
OpActualExecutionEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ForecastProcessingDuration Processing time (forecast) CX_ZEIT
FreeDefinedAttribute01 User field with 20 characters USRCHAR20
FreeDefinedAttribute02 User field with 20 characters USRCHAR20
FreeDefinedAttribute03 User Field with 10 Characters USRCHAR10
FreeDefinedAttribute04 User Field with 10 Characters USRCHAR10
SetupOpActyNtwkInstance Operation Activity Network: Instance ID
ProduceOpActyNtwkInstance Operation Activity Network: Instance ID
TeardownOpActyNtwkInstance Operation Activity Network: Instance ID
Master Data Relations Join Conditions
Unit of the forecasted duration from the confirmation
  • Unit of the forecasted duration from the confirmation
  • Client
  • I_ORDEROPERATIONDATETIME.ACTUALFORECASTDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Assembly
  • Assembly
  • Client
  • I_ORDEROPERATIONDATETIME.ASSEMBLY == MARA.MATNR
  • I_ORDEROPERATIONDATETIME.MANDT == MARA.MANDT
Task List Type
  • Task List Type
  • Client
  • I_ORDEROPERATIONDATETIME.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_ORDEROPERATIONDATETIME.MANDT == TCA01.MANDT
Unit for a Break Time
  • Client
  • Unit for a Break Time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.BREAKDURATIONUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • I_ORDEROPERATIONDATETIME.BUSINESSAREA == TGSB.GSBER
  • I_ORDEROPERATIONDATETIME.MANDT == TGSB.MANDT
Change Number
  • Change Number
  • Client
  • I_ORDEROPERATIONDATETIME.CHANGENUMBER == AENR.AENNR
  • I_ORDEROPERATIONDATETIME.MANDT == AENR.MANDT
Company Code
  • Client
  • Company Code
  • I_ORDEROPERATIONDATETIME.MANDT == T001.MANDT
  • I_ORDEROPERATIONDATETIME.COMPANYCODE == T001.BUKRS
Object currency for network activity
  • Object currency for network activity
  • Client
  • I_ORDEROPERATIONDATETIME.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • I_ORDEROPERATIONDATETIME.MANDT == TCURC.MANDT
Activity Type
  • Activity Type
  • ?
  • Client
  • ?
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • Activity Type
  • ?
  • Client
  • ?
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • ?
  • Client
  • ?
  • Activity Type
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
Activity Type
  • ?
  • Activity Type
  • Client
  • ?
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • ?
  • Client
  • ?
  • Activity Type
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
Activity Type
  • ?
  • Client
  • ?
  • Activity Type
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
Activity Type
  • ?
  • Client
  • Activity Type
  • ?
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSLA.MANDT
  • I_ORDEROPERATIONDATETIME.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSLA.DATBI
Cost Element
  • ?
  • Client
  • Cost Element
  • I_ORDEROPERATIONDATETIME.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_ORDEROPERATIONDATETIME.MANDT == CSKA.MANDT
  • I_ORDEROPERATIONDATETIME.COSTELEMENT == CSKA.KSTAR
Currency Key
  • Client
  • Currency Key
  • I_ORDEROPERATIONDATETIME.MANDT == TCURC.MANDT
  • I_ORDEROPERATIONDATETIME.CURRENCY == TCURC.WAERS
Suitability
  • Client
  • Suitability
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T423.MANDT
  • I_ORDEROPERATIONDATETIME.EMPLOYEESUITABILITY == T423.QUALF
  • I_ORDEROPERATIONDATETIME.PLANT == T423.WERKS
Wage Group
  • Client
  • Wage Group
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T421.MANDT
  • I_ORDEROPERATIONDATETIME.EMPLOYEEWAGEGROUP == T421.LOGRP
  • I_ORDEROPERATIONDATETIME.PLANT == T421.WERKS
Unit for Offset to Finish
  • Unit for Offset to Finish
  • Client
  • I_ORDEROPERATIONDATETIME.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Reference Date for Finish of Sub-Operation I_ORDEROPERATIONDATETIME.ENDDATEOFFSETREFERENCECODE == TCA54.BZOFF
Factory Calendar I_ORDEROPERATIONDATETIME.FACTORYCALENDAR == TFACD.IDENT
Unit for forecast normal duration
  • Client
  • Unit for forecast normal duration
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.FCSTDSTANDARDDURATIONUNIT == T006.MSEHI
Unit for forecast minimum duration
  • Client
  • Unit for forecast minimum duration
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.FORECASTEDMINIMUMDURATIONUNIT == T006.MSEHI
Key word ID for user-defined fields
  • Key word ID for user-defined fields
  • Client
  • I_ORDEROPERATIONDATETIME.FREEDEFINEDTABLEFIELDSEMANTIC == TCN00.SLWID
  • I_ORDEROPERATIONDATETIME.MANDT == TCN00.MANDT
Functional Area
  • Functional Area
  • Client
  • I_ORDEROPERATIONDATETIME.FUNCTIONALAREA == TFKB.FKBER
  • I_ORDEROPERATIONDATETIME.MANDT == TFKB.MANDT
Inspection Type
  • Client
  • Inspection Type
  • I_ORDEROPERATIONDATETIME.MANDT == TQ30.MANDT
  • I_ORDEROPERATIONDATETIME.INSPECTIONLOTTYPE == TQ30.ART
Language Key I_ORDEROPERATIONDATETIME.LANGUAGE == T002.SPRAS
Reduction Strategy per Operation
  • Client
  • Reduction Strategy per Operation
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T499Q.MANDT
  • I_ORDEROPERATIONDATETIME.LEADTIMEREDUCTIONSTRATEGY == T499Q.RSTRA
  • I_ORDEROPERATIONDATETIME.PLANT == T499Q.WERKS
Material Group
  • Client
  • Material Group
  • I_ORDEROPERATIONDATETIME.MANDT == T023.MANDT
  • I_ORDEROPERATIONDATETIME.MATERIALGROUP == T023.MATKL
Unit for the Maximum Wait Time
  • Client
  • Unit for the Maximum Wait Time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.MAXIMUMWAITDURATIONUNIT == T006.MSEHI
Unit for the minimum duration
  • Client
  • Unit for the minimum duration
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.MINIMUMDURATIONUNIT == T006.MSEHI
Unit for the minimum move time
  • Client
  • Unit for the minimum move time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.MINIMUMMOVEDURATIONUNIT == T006.MSEHI
Unit for the Minimum Queue Time
  • Client
  • Unit for the Minimum Queue Time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.MINIMUMQUEUEDURATIONUNIT == T006.MSEHI
Unit for the Required Wait Time
  • Unit for the Required Wait Time
  • Client
  • I_ORDEROPERATIONDATETIME.MINIMUMWAITDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Control key
  • ?
  • Client
  • Control key
  • I_ORDEROPERATIONDATETIME.[column in domain "PLNAW"] == T430.PLNAW
  • I_ORDEROPERATIONDATETIME.MANDT == T430.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONCONTROLPROFILE == T430.STEUS
Selection indicator for costing line items
  • Selection indicator for costing line items
  • Client
  • I_ORDEROPERATIONDATETIME.OPERATIONCOSTINGRELEVANCYTYPE == TCK08.SELKZ
  • I_ORDEROPERATIONDATETIME.MANDT == TCK08.MANDT
Priority
  • Client
  • Priority
  • I_ORDEROPERATIONDATETIME.MANDT == TCN07.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONIMPORTANCE == TCN07.NPRIO
Setup group key
  • Client
  • Setup group category
  • Setup group key
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T425.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_ORDEROPERATIONDATETIME.OPERATIONSETUPGROUP == T425.RFSCH
  • I_ORDEROPERATIONDATETIME.PLANT == T425.WERKS
Setup group category
  • Client
  • Setup group category
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T426.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • I_ORDEROPERATIONDATETIME.PLANT == T426.WERKS
Setup Type Key
  • Client
  • Setup Type Key
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T428.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONSETUPTYPE == T428.RASCH
  • I_ORDEROPERATIONDATETIME.PLANT == T428.WERKS
Normal duration/unit
  • Normal duration/unit
  • Client
  • I_ORDEROPERATIONDATETIME.OPERATIONSTANDARDDURATIONUNIT == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
System Condition
  • System Condition
  • Client
  • I_ORDEROPERATIONDATETIME.OPERATIONSYSTEMCONDITION == T357M.ANLZU
  • I_ORDEROPERATIONDATETIME.MANDT == T357M.MANDT
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.OPERATIONUNIT == T006.MSEHI
Unit for work
  • Client
  • Unit for work
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.OPWORKQUANTITYUNIT == T006.MSEHI
Unit for the Minimum Overlap Time
  • Client
  • Unit for the Minimum Overlap Time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.OVERLAPMINIMUMDURATIONUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == T001W.MANDT
  • I_ORDEROPERATIONDATETIME.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CEPC.DATBI
  • I_ORDEROPERATIONDATETIME.MANDT == CEPC.MANDT
  • I_ORDEROPERATIONDATETIME.PROFITCENTER == CEPC.PRCTR
Purchasing Group for External Processing Activity
  • Client
  • Purchasing Group for External Processing Activity
  • I_ORDEROPERATIONDATETIME.MANDT == T024.MANDT
  • I_ORDEROPERATIONDATETIME.PURCHASINGGROUP == T024.EKGRP
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_ORDEROPERATIONDATETIME.PURCHASINGINFORECORD == EINA.INFNR
  • I_ORDEROPERATIONDATETIME.MANDT == EINA.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • I_ORDEROPERATIONDATETIME.MANDT == T024E.MANDT
  • I_ORDEROPERATIONDATETIME.PURCHASINGORGANIZATION == T024E.EKORG
Reference point for BOM transfer
  • Client
  • Reference point for BOM transfer
  • I_ORDEROPERATIONDATETIME.MANDT == TCNRFP.MANDT
  • I_ORDEROPERATIONDATETIME.REFERENCEPOINT == TCNRFP.RFPNT
Requesting Cost Center
  • ?
  • Client
  • Requesting Cost Center
  • ?
  • I_ORDEROPERATIONDATETIME.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_ORDEROPERATIONDATETIME.MANDT == CSKS.MANDT
  • I_ORDEROPERATIONDATETIME.REQUESTINGCOSTCENTER == CSKS.KOSTL
  • I_ORDEROPERATIONDATETIME.[column in domain "DATBI"] == CSKS.DATBI
Unit for the standard move time
  • Client
  • Unit for the standard move time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.STANDARDMOVEDURATIONUNIT == T006.MSEHI
Unit for the Standard Queue Time
  • Client
  • Unit for the Standard Queue Time
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.STANDARDQUEUEDURATIONUNIT == T006.MSEHI
Standard text key
  • Client
  • Standard text key
  • I_ORDEROPERATIONDATETIME.MANDT == T435.MANDT
  • I_ORDEROPERATIONDATETIME.STANDARDTEXTINTERNALID == T435.VLSCH
Unit for Offset to Start
  • Client
  • Unit for Offset to Start
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
Reference Date for Start of Sub-Operation I_ORDEROPERATIONDATETIME.STARTDATEOFFSETREFERENCECODE == TCA54.BZOFF
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_ORDEROPERATIONDATETIME.MANDT == LFA1.MANDT
  • I_ORDEROPERATIONDATETIME.SUPPLIER == LFA1.LIFNR
Tax Jurisdiction
  • Tax Jurisdiction
  • Client
  • Costing Sheet
  • I_ORDEROPERATIONDATETIME.TAXJURISDICTION == TTXJ.TXJCD
  • I_ORDEROPERATIONDATETIME.MANDT == TTXJ.MANDT
  • I_ORDEROPERATIONDATETIME.COSTINGSHEET == TTXJ.KALSM
Usage
  • Usage
  • Client
  • I_ORDEROPERATIONDATETIME.USAGECODE == T433.MLSTN
  • I_ORDEROPERATIONDATETIME.MANDT == T433.MANDT
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • I_ORDEROPERATIONDATETIME.WORKCENTERINTERNALID == CRID.OBJID
  • I_ORDEROPERATIONDATETIME.MANDT == CRID.MANDT
  • I_ORDEROPERATIONDATETIME.[column in domain "CR_OBJTY"] == CRID.OBJTY
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT1 == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT2 == T006.MSEHI
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT3 == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT4 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT5 == T006.MSEHI
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ORDEROPERATIONDATETIME.WORKCENTERSTANDARDWORKQTYUNIT6 == T006.MSEHI
  • I_ORDEROPERATIONDATETIME.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Control Recipe Destination
  • Client
  • Control Recipe Destination
  • Plant
  • I_ORDEROPERATIONDATETIME.MANDT == TC52.MANDT
  • I_ORDEROPERATIONDATETIME.CONTROLRECIPEDESTINATION == TC52.PHSEQ
  • I_ORDEROPERATIONDATETIME.PLANT == TC52.WERKS