I_RoutingOperation

Routing Operation Details | view: IRTGOPR | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: ESH_SR_LTXT, PLKO, PLPO, PLFL, PLAS, T430, TC21, TC20, TC20T, PLKO_TEXT, PLPO_TEXT, T006, T006A, CRHD
Column Name Description
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BOOInternalVersionCounter Internal counter
BillOfOperationsSequence Sequence
BOOSqncInternalVersionCounter Internal counter
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
Column Name Description
Column Name Description
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit1):
StandardWorkQuantity1 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit2):
StandardWorkQuantity2 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit3):
StandardWorkQuantity3 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit4):
StandardWorkQuantity4 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit5):
StandardWorkQuantity5 Standard Value
📏 Unit of Measurement of Standard Value (StandardWorkQuantityUnit6):
StandardWorkQuantity6 Standard Value
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
OperationIsMilestone Indicator: Operation is a Milestone Show values
ConfirmationIsRequired Indicator: Confirmation is Required Show values
ConfirmationIsNotPossible Indicator: Confirmation is not Possible Show values
OperationIsScheduled Indicator: Scheduling Show values
CapacityRequirementsAreDtmnd Indicator: Determine capacity requirements Show values
Column Name Description Domain name
Operation Operation/Activity Number VORNR
WorkCenterInternalID Object ID NUM08
WorkCenter Work Center ARBPL
OperationText Operation Short Text TEXT40
OperationControlProfile Control key STEUS
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
StandardWorkFormulaParam1 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName1 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam2 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName2 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam3 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName3 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam4 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName4 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam5 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName5 Standard Work Formula Parameter Name TEXT20
StandardWorkFormulaParam6 Standard Work Formula Parameter PARAMID
StandardWorkFormulaParamName6 Standard Work Formula Parameter Name TEXT20
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • I_ROUTINGOPERATION.MANDT == TCA01.MANDT
  • I_ROUTINGOPERATION.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Change Number
  • Client
  • Change Number
  • I_ROUTINGOPERATION.MANDT == AENR.MANDT
  • I_ROUTINGOPERATION.CHANGENUMBER == AENR.AENNR
Activity Type
  • Activity Type
  • Client
  • ?
  • ?
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • Client
  • ?
  • ?
  • Activity Type
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
Activity Type
  • Client
  • ?
  • Activity Type
  • ?
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • Activity Type
  • Client
  • ?
  • ?
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • Client
  • ?
  • Activity Type
  • ?
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
Activity Type
  • Activity Type
  • Client
  • ?
  • ?
  • I_ROUTINGOPERATION.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_ROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_ROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGOPERATION.[column in domain "DATBI"] == CSLA.DATBI
Factory Calendar I_ROUTINGOPERATION.FACTORYCALENDAR == TFACD.IDENT
Setup group key
  • Client
  • Plant
  • Setup group category
  • Setup group key
  • I_ROUTINGOPERATION.MANDT == T425.MANDT
  • I_ROUTINGOPERATION.PLANT == T425.WERKS
  • I_ROUTINGOPERATION.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_ROUTINGOPERATION.OPERATIONSETUPGROUP == T425.RFSCH
Setup group category
  • Client
  • Plant
  • Setup group category
  • I_ROUTINGOPERATION.MANDT == T426.MANDT
  • I_ROUTINGOPERATION.PLANT == T426.WERKS
  • I_ROUTINGOPERATION.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
Setup Type Key
  • Client
  • Plant
  • Setup Type Key
  • I_ROUTINGOPERATION.MANDT == T428.MANDT
  • I_ROUTINGOPERATION.PLANT == T428.WERKS
  • I_ROUTINGOPERATION.OPERATIONSETUPTYPE == T428.RASCH
Standard Text Key
  • Standard Text Key
  • Client
  • I_ROUTINGOPERATION.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • I_ROUTINGOPERATION.MANDT == T435.MANDT
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.OPERATIONUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_ROUTINGOPERATION.MANDT == T001W.MANDT
  • I_ROUTINGOPERATION.PLANT == T001W.WERKS
Standard Value Key
  • Client
  • Standard Value Key
  • I_ROUTINGOPERATION.MANDT == TC21.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGOPERATION.MANDT == T006.MANDT
  • I_ROUTINGOPERATION.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • ISO code for unit of measurement
  • I_ROUTINGOPERATION.MANDT == T006I.CLIENT
  • I_ROUTINGOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE