I_ProductionRoutingOperation

Production Routing - Operation Details | view: IPRODNRTGOPR | 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
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
BillOfOperationsSequence Sequence
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 of measure for activity (OverlapMinimumTransferQtyUnit):
BillOfOperationsBreakDuration Break Time
MaximumWaitDuration Maximum Wait Time
MinimumWaitDuration Minimum Wait Time
StandardQueueDuration Standard Queue Time
MinimumQueueDuration Minimum Queue Time
StandardMoveDuration Standard Move Time
MinimumMoveDuration Minimum Move Time
MinProcessingDurationPerSplit Minimum Processing Time
OverlapMinimumDuration Minimum Overlap Time
OverlapMinimumTransferQty Minimum Send-Ahead Quantity
Column Name Description
CreationDate Date Record Created On
LastChangeDate Last Changed On
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
Column Name Description
IsDeleted Deletion Indicator Show values
IsImplicitlyDeleted Deletion Indicator Show values
WorkCenterTypeCode Object types of the CIM resource Show values
OperationStdWorkQtyGrpgCat Operation: Standard Work Quantity Grouping Category Show values
OrderHasNoSubOperations Suboperations Do Not Apply to Order Show values
BOOOperationIsPhase Indicator: Phase Show values
InspResultRecordingView Recording View Show values
InspSbstCompletionConfirmation Flow Variants for Inspection Point Completion Show values
InspSbstHasNoTimeOrQuantity Interval Without Reference to Time or Quantity Show values
TeardownAndWaitIsParallel Teardown and Wait Occur in Parallel Show values
OperationSplitIsRequired Splitting Required Show values
OperationOverlappingIsRequired Operation Overlapping is Required Show values
OperationOverlappingIsPossible Operation Overlapping is Allowed Show values
OperationsIsAlwaysOverlapping Flow Manufacturing Show values
Column Name Description Domain name
BillOfOperationsVariant Group Counter ALTNR
OperationExternalID External Operation ID CHAR8
Operation Operation / Phase Number PPH_VORNR
CreatedByUser Created By User XUBNAME
LastChangedByUser Last Changed By User XUBNAME
OperationText Operation Short Text TEXT40
OperationControlProfile Control key STEUS
OperationStandardTextCode Standard Text Key KTSCH
WorkCenterInternalID Object ID NUM08
NumberOfTimeTickets Number of Time Tickets LOHNANZ
NumberOfConfirmationSlips Number of Confirmation Slips NUM03
EmployeeWageGroup Wage Group LOHNGRP
EmployeeWageType Wage type LOART
EmployeeSuitability Suitability QUALF
NumberOfEmployees Number of employees ANZMA
BillOfOperationsRefType Type of the referenced task list PLNTY
BillOfOperationsRefGroup Referenced Bill of Operations Group PLNNR
BillOfOperationsRefVariant Referenced Bill of Operations Variant ALTNR
LineSegmentTakt Takt within a Line Segment LD_TAKT
OperationSetupType Setup Type Key RUEARSCHLU
BOOPhaseSuperiorOpInternalID Number of the Task List Node KNTNR
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
OperationScrapPercent Scrap factor AUSCHUFAK
OpQtyToBaseQtyNmrtr Numerator for Converting Routing and Operation UoM UMBSZ
OpQtyToBaseQtyDnmntr Denominator for Converting Routing and Operation UoM UMBSN
BusinessProcess Business Process CO_PRZNR
MaximumNumberOfSplits Maximum Number of Splits SPLITTANZ
Master Data Relations Join Conditions
Task List Type
  • Task List Type
  • Client
  • I_PRODUCTIONROUTINGOPERATION.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TCA01.MANDT
Unit for a Break Time
  • Client
  • Unit for a Break Time
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.BREAKDURATIONUNIT == T006.MSEHI
Capacity category
  • Client
  • Capacity category
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC26.MANDT
  • I_PRODUCTIONROUTINGOPERATION.CAPACITYCATEGORYCODE == TC26.KAPAR
Change Number
  • Change Number
  • Client
  • I_PRODUCTIONROUTINGOPERATION.CHANGENUMBER == AENR.AENNR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == AENR.MANDT
Cost Center Activity Type 1
  • ?
  • Last Changed On
  • Client
  • Cost Center Activity Type 1
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR
Cost Center Activity Type 2
  • ?
  • Cost Center Activity Type 2
  • Last Changed On
  • Client
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
Cost Center Activity Type 3
  • ?
  • Last Changed On
  • Cost Center Activity Type 3
  • Client
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
Cost Center Activity Type 4
  • ?
  • Last Changed On
  • Cost Center Activity Type 4
  • Client
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
Cost Center Activity Type 5
  • ?
  • Cost Center Activity Type 5
  • Last Changed On
  • Client
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
Cost Center Activity Type 6
  • ?
  • Last Changed On
  • Cost Center Activity Type 6
  • Client
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PRODUCTIONROUTINGOPERATION.LASTCHANGEDATE == CSLA.DATBI
  • I_PRODUCTIONROUTINGOPERATION.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Client
  • Cost Element
  • I_PRODUCTIONROUTINGOPERATION.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_PRODUCTIONROUTINGOPERATION.MANDT == CSKA.MANDT
  • I_PRODUCTIONROUTINGOPERATION.COSTELEMENT == CSKA.KSTAR
Factory Calendar I_PRODUCTIONROUTINGOPERATION.FACTORYCALENDAR == TFACD.IDENT
Reduction Strategy per Operation
  • Reduction Strategy per Operation
  • Client
  • Plant
  • I_PRODUCTIONROUTINGOPERATION.LEADTIMEREDUCTIONSTRATEGY == T499Q.RSTRA
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T499Q.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PLANT == T499Q.WERKS
Language Key I_PRODUCTIONROUTINGOPERATION.LONGTEXTLANGUAGECODE == T002.SPRAS
Material Group
  • Material Group
  • Client
  • I_PRODUCTIONROUTINGOPERATION.MATERIALGROUP == T023.MATKL
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T023.MANDT
Unit for the Maximum Wait Time
  • Unit for the Maximum Wait Time
  • Client
  • I_PRODUCTIONROUTINGOPERATION.MAXIMUMWAITDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Unit for the minimum move time
  • Unit for the minimum move time
  • Client
  • I_PRODUCTIONROUTINGOPERATION.MINIMUMMOVEDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Unit for the Minimum Queue Time
  • Client
  • Unit for the Minimum Queue Time
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.MINIMUMQUEUEDURATIONUNIT == T006.MSEHI
Unit for the Required Wait Time
  • Unit for the Required Wait Time
  • Client
  • I_PRODUCTIONROUTINGOPERATION.MINIMUMWAITDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Unit for the Minimum Processing Time
  • Client
  • Unit for the Minimum Processing Time
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.MINPROCESSINGDURNPERSPLITUNIT == T006.MSEHI
Operation Costing Relevancy Type
  • Operation Costing Relevancy Type
  • Client
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONCOSTINGRELEVANCYTYPE == TCK08.SELKZ
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TCK08.MANDT
Setup group key
  • Setup group key
  • Setup group category
  • Client
  • Plant
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONSETUPGROUP == T425.RFSCH
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONSETUPGROUPCATEGORY == T425.RFGRP
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T425.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PLANT == T425.WERKS
Setup group category
  • Setup group category
  • Client
  • Plant
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONSETUPGROUPCATEGORY == T426.RFGRP
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T426.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PLANT == T426.WERKS
Unit of measure for activity
  • Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_PRODUCTIONROUTINGOPERATION.OVERLAPMINIMUMTRANSFERQTYUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PRODUCTIONROUTINGOPERATION.OPEXTERNALPROCESSINGCURRENCY == TCURC.WAERS
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TCURC.MANDT
Unit for the Minimum Overlap Time
  • Unit for the Minimum Overlap Time
  • Client
  • I_PRODUCTIONROUTINGOPERATION.OVERLAPMINIMUMDURATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Unit of measure for activity
  • Unit of measure for activity
  • Unit of measure for activity
  • Client
  • I_PRODUCTIONROUTINGOPERATION.OVERLAPMINIMUMTRANSFERQTYUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.OPERATIONUNIT == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE1 == TC31.ID
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE2 == TC31.ID
Key for performance efficiency rate
  • Key for performance efficiency rate
  • Client
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE3 == TC31.ID
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE4 == TC31.ID
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE5 == TC31.ID
Key for performance efficiency rate
  • Client
  • Key for performance efficiency rate
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC31.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PERFEFFICIENCYRATIOCODE6 == TC31.ID
Plant
  • Client
  • Plant
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T001W.MANDT
  • I_PRODUCTIONROUTINGOPERATION.PLANT == T001W.WERKS
Purchasing Group for External Processing Activity
  • Purchasing Group for External Processing Activity
  • Client
  • I_PRODUCTIONROUTINGOPERATION.PURCHASINGGROUP == T024.EKGRP
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • I_PRODUCTIONROUTINGOPERATION.PURCHASINGINFORECORD == EINA.INFNR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == EINA.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_PRODUCTIONROUTINGOPERATION.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T024E.MANDT
Unit for the standard move time
  • Client
  • Unit for the standard move time
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDMOVEDURATIONUNIT == T006.MSEHI
Unit for the Standard Queue Time
  • Client
  • Unit for the Standard Queue Time
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDQUEUEDURATIONUNIT == T006.MSEHI
Work Center Formula Parameter 1
  • Work Center Formula Parameter 1
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM1 == TC20.PARID
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
Work Center Formula Parameter 2
  • Client
  • Work Center Formula Parameter 2
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM2 == TC20.PARID
Work Center Formula Parameter 3
  • Work Center Formula Parameter 3
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM3 == TC20.PARID
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
Work Center Formula Parameter 4
  • Client
  • Work Center Formula Parameter 4
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM4 == TC20.PARID
Work Center Formula Parameter 5
  • Client
  • Work Center Formula Parameter 5
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM5 == TC20.PARID
Work Center Formula Parameter 6
  • Client
  • Work Center Formula Parameter 6
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC20.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKFORMULAPARAM6 == TC20.PARID
Standard Work Quantity Unit 1
  • Client
  • Standard Work Quantity Unit 1
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT1 == T006.MSEHI
Standard Work Quantity Unit 2
  • Standard Work Quantity Unit 2
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT2 == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Standard Work Quantity Unit 3
  • Standard Work Quantity Unit 3
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT3 == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Standard Work Quantity Unit 4
  • Standard Work Quantity Unit 4
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT4 == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Standard Work Quantity Unit 5
  • Standard Work Quantity Unit 5
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT5 == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Standard Work Quantity Unit 6
  • Standard Work Quantity Unit 6
  • Client
  • I_PRODUCTIONROUTINGOPERATION.STANDARDWORKQUANTITYUNIT6 == T006.MSEHI
  • I_PRODUCTIONROUTINGOPERATION.MANDT == T006.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_PRODUCTIONROUTINGOPERATION.SUPPLIER == LFA1.LIFNR
  • I_PRODUCTIONROUTINGOPERATION.MANDT == LFA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Control Recipe Destination
  • Client
  • Control Recipe Destination
  • Plant
  • I_PRODUCTIONROUTINGOPERATION.MANDT == TC52.MANDT
  • I_PRODUCTIONROUTINGOPERATION.CONTROLRECIPEDESTINATION == TC52.PHSEQ
  • I_PRODUCTIONROUTINGOPERATION.PLANT == TC52.WERKS