I_ProductionRoutingSubOp

Prodn Routing - SubOperation Details | view: IPRODNRTGSUBOP | Extraction: Not supported | Component: Virtual Data Model in PP Master Data
Tables used: PLPO, PLAS, TC21, CRHD
Column Name Description
BillOfOperationsType FK Task List Type
BillOfOperationsGroup Key for Task List Group
BillOfOperationsVariant Group Counter
BOOOperationInternalID Number of the Task List Node
BillOfOperationsSequence Sequence
BOOOpInternalVersionCounter Internal counter
Column Name Description
💲 Currency Key (OpExternalProcessingCurrency):
OpExternalProcessingPrice Net Price in Purchasing Info Record
Column Name Description
📏 Unit of measure for activity (OperationUnit):
OperationReferenceQuantity Base Quantity
📏 Standard Work Quantity Unit 1 (StandardWorkQuantityUnit1):
StandardWorkQuantity1 Standard Work Quantity 1
📏 Standard Work Quantity Unit 2 (StandardWorkQuantityUnit2):
StandardWorkQuantity2 Standard Work Quantity 2
📏 Standard Work Quantity Unit 3 (StandardWorkQuantityUnit3):
StandardWorkQuantity3 Standard Work Quantity 3
📏 Standard Work Quantity Unit 4 (StandardWorkQuantityUnit4):
StandardWorkQuantity4 Standard Work Quantity 4
📏 Standard Work Quantity Unit 5 (StandardWorkQuantityUnit5):
StandardWorkQuantity5 Standard Work Quantity 5
📏 Standard Work Quantity Unit 6 (StandardWorkQuantityUnit6):
StandardWorkQuantity6 Standard Work Quantity 6
📏 Unit for Offset to Start (StartDateOffsetDurationUnit):
StartDateOffsetDuration Offset to sub-operation start
📏 Unit for Offset to Finish (EndDateOffsetDurationUnit):
EndDateOffsetDuration Offset to sub-operation finish
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
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
SuperiorOperationInternalID Node Number of the Superior Operation KNTNR
Operation Operation / Phase Number PPH_VORNR
OperationText Operation Short Text TEXT40
WorkCenterInternalID Object ID NUM08
OperationControlProfile Control key STEUS
OperationStandardTextCode Standard Text Key KTSCH
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
NumberOfTimeTickets Number of Time Tickets LOHNANZ
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
EmployeeWageGroup Employee Wage Group LOHNGRP
EmployeeWageType Employee Wage Type LOART
EmployeeSuitability Suitability QUALF
NumberOfEmployees Number of employees ANZMA
BusinessProcess Business Process CO_PRZNR
OpIsExtlyProcdWithSubcontrg Indicator: External Processing Operation with Subcontracting CHAR1
PurchaseContract Purchasing Document Number EBELN
PurchasingInfoRecdAddlGrpgName Sort Term for Non-Stock Info Records CHAR10
PlannedDeliveryDuration Planned Delivery Time in Days DEC3
NumberOfOperationPriceUnits Price unit DEC5
InspectionLotType Inspection Type QPART
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
OperationSetupType Setup Type Key RUEARSCHLU
OperationScrapPercent Scrap factor AUSCHUFAK
Master Data Relations Join Conditions
Task List Type
  • Client
  • Task List Type
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TCA01.MANDT
  • I_PRODUCTIONROUTINGSUBOP.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Capacity Category
  • Client
  • Capacity Category
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC26.MANDT
  • I_PRODUCTIONROUTINGSUBOP.CAPACITYCATEGORYCODE == TC26.KAPAR
Change Number
  • Change Number
  • Client
  • I_PRODUCTIONROUTINGSUBOP.CHANGENUMBER == AENR.AENNR
  • I_PRODUCTIONROUTINGSUBOP.MANDT == AENR.MANDT
Cost Center Activity Type 1
  • Client
  • Last Changed On
  • ?
  • Cost Center Activity Type 1
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
Cost Center Activity Type 2
  • Cost Center Activity Type 2
  • Client
  • Last Changed On
  • ?
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Center Activity Type 3
  • Client
  • Last Changed On
  • ?
  • Cost Center Activity Type 3
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
Cost Center Activity Type 4
  • Cost Center Activity Type 4
  • Client
  • Last Changed On
  • ?
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Center Activity Type 5
  • Client
  • Last Changed On
  • ?
  • Cost Center Activity Type 5
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
Cost Center Activity Type 6
  • Cost Center Activity Type 6
  • Client
  • Last Changed On
  • ?
  • I_PRODUCTIONROUTINGSUBOP.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Element
  • ?
  • Client
  • Cost Element
  • I_PRODUCTIONROUTINGSUBOP.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_PRODUCTIONROUTINGSUBOP.MANDT == CSKA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.COSTELEMENT == CSKA.KSTAR
Unit for Offset to Finish
  • Unit for Offset to Finish
  • Client
  • I_PRODUCTIONROUTINGSUBOP.ENDDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
Factory Calendar I_PRODUCTIONROUTINGSUBOP.FACTORYCALENDAR == TFACD.IDENT
Language Key I_PRODUCTIONROUTINGSUBOP.LONGTEXTLANGUAGECODE == T002.SPRAS
Material Group
  • Client
  • Material Group
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T023.MANDT
  • I_PRODUCTIONROUTINGSUBOP.MATERIALGROUP == T023.MATKL
Operation Costing Relevancy Type
  • Operation Costing Relevancy Type
  • Client
  • I_PRODUCTIONROUTINGSUBOP.OPERATIONCOSTINGRELEVANCYTYPE == TCK08.SELKZ
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TCK08.MANDT
Setup group key
  • Setup group key
  • Client
  • Setup group category
  • Plant
  • I_PRODUCTIONROUTINGSUBOP.OPERATIONSETUPGROUP == T425.RFSCH
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T425.MANDT
  • I_PRODUCTIONROUTINGSUBOP.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_PRODUCTIONROUTINGSUBOP.PLANT == T425.WERKS
Setup group category
  • Client
  • Setup group category
  • Plant
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T426.MANDT
  • I_PRODUCTIONROUTINGSUBOP.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • I_PRODUCTIONROUTINGSUBOP.PLANT == T426.WERKS
Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_PRODUCTIONROUTINGSUBOP.OPERATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PRODUCTIONROUTINGSUBOP.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TCURC.MANDT
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE1 == TC31.ID
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE2 == TC31.ID
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE3 == TC31.ID
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE4 == TC31.ID
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE5 == TC31.ID
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PERFEFFICIENCYRATIOCODE6 == TC31.ID
Plant
  • Client
  • Plant
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T001W.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PLANT == T001W.WERKS
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • I_PRODUCTIONROUTINGSUBOP.PURCHASINGGROUP == T024.EKGRP
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T024.MANDT
Number of purchasing info record
  • Client
  • Number of purchasing info record
  • I_PRODUCTIONROUTINGSUBOP.MANDT == EINA.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PURCHASINGINFORECORD == EINA.INFNR
Purchasing organization
  • Client
  • Purchasing organization
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T024E.MANDT
  • I_PRODUCTIONROUTINGSUBOP.PURCHASINGORGANIZATION == T024E.EKORG
Work Center Formula Parameter 1
  • Work Center Formula Parameter 1
  • Client
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM1 == TC20.PARID
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
Work Center Formula Parameter 2
  • Client
  • Work Center Formula Parameter 2
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM2 == TC20.PARID
Work Center Formula Parameter 3
  • Work Center Formula Parameter 3
  • Client
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM3 == TC20.PARID
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
Work Center Formula Parameter 4
  • Client
  • Work Center Formula Parameter 4
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM4 == TC20.PARID
Work Center Formula Parameter 5
  • Work Center Formula Parameter 5
  • Client
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM5 == TC20.PARID
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
Work Center Formula Parameter 6
  • Client
  • Work Center Formula Parameter 6
  • I_PRODUCTIONROUTINGSUBOP.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKFORMULAPARAM6 == TC20.PARID
Standard Work Quantity Unit 1
  • Client
  • Standard Work Quantity Unit 1
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
Standard Work Quantity Unit 2
  • Client
  • Standard Work Quantity Unit 2
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
Standard Work Quantity Unit 3
  • Client
  • Standard Work Quantity Unit 3
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
Standard Work Quantity Unit 4
  • Client
  • Standard Work Quantity Unit 4
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
Standard Work Quantity Unit 5
  • Client
  • Standard Work Quantity Unit 5
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
Standard Work Quantity Unit 6
  • Client
  • Standard Work Quantity Unit 6
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGSUBOP.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
Unit for Offset to Start
  • Unit for Offset to Start
  • Client
  • I_PRODUCTIONROUTINGSUBOP.STARTDATEOFFSETDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGSUBOP.MANDT == T006.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_PRODUCTIONROUTINGSUBOP.MANDT == LFA1.MANDT
  • I_PRODUCTIONROUTINGSUBOP.SUPPLIER == LFA1.LIFNR