I_RoutingSubOperation

Routing Sub-Operation Details | view: IRTGSUBOPR | 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
BillOfOperationsSequence Sequence
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
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
SuperiorOperation 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
  • Task List Type
  • Client
  • I_ROUTINGSUBOPERATION.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_ROUTINGSUBOPERATION.MANDT == TCA01.MANDT
Change Number
  • Change Number
  • Client
  • I_ROUTINGSUBOPERATION.CHANGENUMBER == AENR.AENNR
  • I_ROUTINGSUBOPERATION.MANDT == AENR.MANDT
Activity Type
  • ?
  • Activity Type
  • ?
  • Client
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Activity Type
  • ?
  • Activity Type
  • ?
  • Client
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Activity Type
  • Activity Type
  • ?
  • ?
  • Client
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Activity Type
  • Activity Type
  • ?
  • ?
  • Client
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Activity Type
  • Activity Type
  • ?
  • ?
  • Client
  • I_ROUTINGSUBOPERATION.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_ROUTINGSUBOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGSUBOPERATION.[column in domain "DATBI"] == CSLA.DATBI
  • I_ROUTINGSUBOPERATION.MANDT == CSLA.MANDT
Factory Calendar I_ROUTINGSUBOPERATION.FACTORYCALENDAR == TFACD.IDENT
Setup group key
  • Setup group category
  • Setup group key
  • Plant
  • Client
  • I_ROUTINGSUBOPERATION.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_ROUTINGSUBOPERATION.OPERATIONSETUPGROUP == T425.RFSCH
  • I_ROUTINGSUBOPERATION.PLANT == T425.WERKS
  • I_ROUTINGSUBOPERATION.MANDT == T425.MANDT
Setup group category
  • Setup group category
  • Plant
  • Client
  • I_ROUTINGSUBOPERATION.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • I_ROUTINGSUBOPERATION.PLANT == T426.WERKS
  • I_ROUTINGSUBOPERATION.MANDT == T426.MANDT
Setup Type Key
  • Setup Type Key
  • Plant
  • Client
  • I_ROUTINGSUBOPERATION.OPERATIONSETUPTYPE == T428.RASCH
  • I_ROUTINGSUBOPERATION.PLANT == T428.WERKS
  • I_ROUTINGSUBOPERATION.MANDT == T428.MANDT
Standard Text Key
  • Standard Text Key
  • Client
  • I_ROUTINGSUBOPERATION.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • I_ROUTINGSUBOPERATION.MANDT == T435.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_ROUTINGSUBOPERATION.OPERATIONUNIT == T006.MSEHI
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • I_ROUTINGSUBOPERATION.PLANT == T001W.WERKS
  • I_ROUTINGSUBOPERATION.MANDT == T001W.MANDT
Standard Value Key
  • Standard Value Key
  • Client
  • I_ROUTINGSUBOPERATION.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS
  • I_ROUTINGSUBOPERATION.MANDT == TC21.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Client
  • Unit of Measurement of Standard Value
  • I_ROUTINGSUBOPERATION.MANDT == T006.MANDT
  • I_ROUTINGSUBOPERATION.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.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
  • ISO code for unit of measurement
  • Client
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGSUBOPERATION.MANDT == T006I.CLIENT