I_RoutingActivity

Routing Activity (Opr, Sub-opr) Details | view: IRTGACT | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: ESH_SR_LTXT, PLKO, PLPO, PLFL, PLAS, 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
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
📏 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
CreationDate Date Record Created On
LastChangeDate Last Changed On
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator 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
PlainLongText Long Text
SuperiorOperationInternalVers Internal counter CIM_COUNT
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
Master Data Relations Join Conditions
Task List Type
  • Task List Type
  • Client
  • I_ROUTINGACTIVITY.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_ROUTINGACTIVITY.MANDT == TCA01.MANDT
Task List Unit of Measure
  • Task List Unit of Measure
  • Client
  • I_ROUTINGACTIVITY.BILLOFOPERATIONSUNIT == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Change Number
  • Change Number
  • Client
  • I_ROUTINGACTIVITY.CHANGENUMBER == AENR.AENNR
  • I_ROUTINGACTIVITY.MANDT == AENR.MANDT
Activity Type
  • Activity Type
  • Last Changed On
  • ?
  • Client
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Activity Type
  • Last Changed On
  • Activity Type
  • ?
  • Client
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Activity Type
  • Last Changed On
  • Activity Type
  • ?
  • Client
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Activity Type
  • Last Changed On
  • ?
  • Activity Type
  • Client
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Activity Type
  • Last Changed On
  • Activity Type
  • ?
  • Client
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Activity Type
  • Last Changed On
  • ?
  • Activity Type
  • Client
  • I_ROUTINGACTIVITY.LASTCHANGEDATE == CSLA.DATBI
  • I_ROUTINGACTIVITY.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_ROUTINGACTIVITY.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_ROUTINGACTIVITY.MANDT == CSLA.MANDT
Factory Calendar I_ROUTINGACTIVITY.FACTORYCALENDAR == TFACD.IDENT
Language Key I_ROUTINGACTIVITY.LONGTEXTLANGUAGECODE == T002.SPRAS
Setup group key
  • Setup group key
  • Plant
  • Setup group category
  • Client
  • I_ROUTINGACTIVITY.OPERATIONSETUPGROUP == T425.RFSCH
  • I_ROUTINGACTIVITY.PLANT == T425.WERKS
  • I_ROUTINGACTIVITY.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_ROUTINGACTIVITY.MANDT == T425.MANDT
Setup group category
  • Plant
  • Setup group category
  • Client
  • I_ROUTINGACTIVITY.PLANT == T426.WERKS
  • I_ROUTINGACTIVITY.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • I_ROUTINGACTIVITY.MANDT == T426.MANDT
Setup Type Key
  • Setup Type Key
  • Plant
  • Client
  • I_ROUTINGACTIVITY.OPERATIONSETUPTYPE == T428.RASCH
  • I_ROUTINGACTIVITY.PLANT == T428.WERKS
  • I_ROUTINGACTIVITY.MANDT == T428.MANDT
Standard Text Key
  • Standard Text Key
  • Client
  • I_ROUTINGACTIVITY.OPERATIONSTANDARDTEXTCODE == T435.VLSCH
  • I_ROUTINGACTIVITY.MANDT == T435.MANDT
Unit of measure for activity
  • Client
  • Unit of measure for activity
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
  • I_ROUTINGACTIVITY.OPERATIONUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • I_ROUTINGACTIVITY.PLANT == T001W.WERKS
  • I_ROUTINGACTIVITY.MANDT == T001W.MANDT
Standard Value Key
  • Client
  • Standard Value Key
  • I_ROUTINGACTIVITY.MANDT == TC21.MANDT
  • I_ROUTINGACTIVITY.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
Unit of Measurement of Standard Value
  • Unit of Measurement of Standard Value
  • Client
  • I_ROUTINGACTIVITY.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
  • I_ROUTINGACTIVITY.MANDT == T006.MANDT
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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.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_ROUTINGACTIVITY.STDWRKQTYUNIT1ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT4ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT3ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT5ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT2ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.STDWRKQTYUNIT6ISOCODE == T006I.ISOCODE
  • I_ROUTINGACTIVITY.MANDT == T006I.CLIENT