I_PRODUCTIONROUTINGOPERATION
Production Routing - Operation Details
I_PRODUCTIONROUTINGOPERATION is a CDS View in S/4HANA. Production Routing - Operation Details. It contains 119 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdnRtgOpCompAllocToOp | view_entity | inner | COMPOSITE | Prodn Rtg Comp Alloc to Operation |
| I_ProdnRtgOperationToSequence | view_entity | from | COMPOSITE | Prodn Rtg Operation to Sequence |
| I_ProdnRtgOperationTP | view_entity | from | TRANSACTIONAL | Transaction View for Production Routing Operation |
| I_ProdnRtgOpInspCharcsToOp | view_entity | inner | COMPOSITE | Prodn Rtg Inspection Charcs to Operation |
| I_ProdnRtgOpPRTAssgmtToOp | view_entity | inner | COMPOSITE | Prodn Rtg PRT Assgmt to Operation |
| I_ProdnRtgSubordOpToOperation | view_entity | inner | COMPOSITE | Prodn Rtg Subperation to Operation |
| R_ProdnRoutingOperationTP_2 | view_entity | from | TRANSACTIONAL | Production Routing Operation |
Fields (119)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | ProductionRoutingGroup | 2 |
| KEY | BillOfOperationsSequence | ProductionRoutingSequence | 2 |
| KEY | BillOfOperationsVariant | ProductionRouting | 2 |
| KEY | BOOOperationInternalID | ProductionRoutingOpIntID | 2 |
| KEY | BOOOpInternalVersionCounter | ProductionRoutingOpIntVersion | 2 |
| _Supplier | _Supplier | 1 | |
| _SupplierCompanyByPlant | _SupplierCompanyByPlant | 1 | |
| BillOfOperationsBreakDuration | BillOfOperationsBreakDuration | 1 | |
| BillOfOperationsRefGroup | BillOfOperationsRefGroup | 1 | |
| BillOfOperationsRefType | BillOfOperationsRefType | 1 | |
| BillOfOperationsRefVariant | BillOfOperationsRefVariant | 1 | |
| BOOOperationIsPhase | BOOOperationIsPhase | 1 | |
| BOOPhaseSuperiorOpInternalID | BOOPhaseSuperiorOpInternalID | 1 | |
| BreakDurationUnit | BreakDurationUnit | 1 | |
| BusinessProcess | BusinessProcess | 1 | |
| CapacityCategoryCode | CapacityCategoryCode | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| ControlRecipeDestination | ControlRecipeDestination | 1 | |
| CostCtrActivityType1 | CostCtrActivityType1 | 1 | |
| CostCtrActivityType2 | CostCtrActivityType2 | 1 | |
| CostCtrActivityType3 | CostCtrActivityType3 | 1 | |
| CostCtrActivityType4 | CostCtrActivityType4 | 1 | |
| CostCtrActivityType5 | CostCtrActivityType5 | 1 | |
| CostCtrActivityType6 | CostCtrActivityType6 | 1 | |
| CostElement | CostElement | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| EmployeeSuitability | EmployeeSuitability | 1 | |
| EmployeeWageGroup | EmployeeWageGroup | 1 | |
| EmployeeWageType | EmployeeWageType | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| InspectionLotType | InspectionLotType | 1 | |
| InspResultRecordingView | InspResultRecordingView | 1 | |
| InspSbstCompletionConfirmation | InspSbstCompletionConfirmation | 1 | |
| InspSbstHasNoTimeOrQuantity | InspSbstHasNoTimeOrQuantity | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsImplicitlyDeleted | IsImplicitlyDeleted | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LeadTimeReductionStrategy | LeadTimeReductionStrategy | 1 | |
| LineSegmentTakt | LineSegmentTakt | 1 | |
| LongTextLanguageCode | LongTextLanguageCode | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaximumNumberOfSplits | MaximumNumberOfSplits | 1 | |
| MaximumWaitDuration | MaximumWaitDuration | 1 | |
| MaximumWaitDurationUnit | MaximumWaitDurationUnit | 1 | |
| MinimumMoveDuration | MinimumMoveDuration | 1 | |
| MinimumMoveDurationUnit | MinimumMoveDurationUnit | 1 | |
| MinimumQueueDuration | MinimumQueueDuration | 1 | |
| MinimumQueueDurationUnit | MinimumQueueDurationUnit | 1 | |
| MinimumWaitDuration | MinimumWaitDuration | 1 | |
| MinimumWaitDurationUnit | MinimumWaitDurationUnit | 1 | |
| MinProcessingDurationPerSplit | MinProcessingDurationPerSplit | 1 | |
| MinProcessingDurnPerSplitUnit | MinProcessingDurnPerSplitUnit | 1 | |
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | 1 | |
| NumberOfEmployees | NumberOfEmployees | 1 | |
| NumberOfOperationPriceUnits | NumberOfOperationPriceUnits | 1 | |
| NumberOfTimeTickets | NumberOfTimeTickets | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| OperationCostingRelevancyType | OperationCostingRelevancyType | 1 | |
| OperationHasNoOverlapping | OperationHasNoOverlapping | 1 | |
| OperationOverlappingIsPossible | OperationOverlappingIsPossible | 1 | |
| OperationOverlappingIsRequired | OperationOverlappingIsRequired | 1 | |
| OperationReferenceQuantity | OperationReferenceQuantity | 1 | |
| OperationScrapPercent | OperationScrapPercent | 1 | |
| OperationSetupGroup | OperationSetupGroup | 1 | |
| OperationSetupGroupCategory | OperationSetupGroupCategory | 1 | |
| OperationSetupType | OperationSetupType | 1 | |
| OperationsIsAlwaysOverlapping | OperationsIsAlwaysOverlapping | 1 | |
| OperationSplitIsRequired | OperationSplitIsRequired | 1 | |
| OperationStandardTextCode | OperationStandardTextCode | 1 | |
| OperationStdWorkQtyGrpgCat | OperationStdWorkQtyGrpgCat | 1 | |
| OperationText | OperationText | 1 | |
| OperationUnit | OperationUnit | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OpQtyToBaseQtyDnmntr | OpQtyToBaseQtyDnmntr | 1 | |
| OpQtyToBaseQtyNmrtr | OpQtyToBaseQtyNmrtr | 1 | |
| OrderHasNoSubOperations | OrderHasNoSubOperations | 1 | |
| OverlapMinimumDuration | OverlapMinimumDuration | 1 | |
| OverlapMinimumDurationUnit | OverlapMinimumDurationUnit | 1 | |
| OverlapMinimumTransferQty | OverlapMinimumTransferQty | 1 | |
| OverlapMinimumTransferQtyUnit | OverlapMinimumTransferQtyUnit | 1 | |
| PerfEfficiencyRatioCode1 | PerfEfficiencyRatioCode1 | 1 | |
| PerfEfficiencyRatioCode2 | PerfEfficiencyRatioCode2 | 1 | |
| PerfEfficiencyRatioCode3 | PerfEfficiencyRatioCode3 | 1 | |
| PerfEfficiencyRatioCode4 | PerfEfficiencyRatioCode4 | 1 | |
| PerfEfficiencyRatioCode5 | PerfEfficiencyRatioCode5 | 1 | |
| PerfEfficiencyRatioCode6 | PerfEfficiencyRatioCode6 | 1 | |
| PlannedDeliveryDuration | PlannedDeliveryDuration | 1 | |
| Plant | Plant | 1 | |
| PurchaseContract | PurchaseContract | 1 | |
| PurchaseContractItem | PurchaseContractItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecdAddlGrpgName | PurchasingInfoRecdAddlGrpgName | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| StandardMoveDuration | StandardMoveDuration | 1 | |
| StandardMoveDurationUnit | StandardMoveDurationUnit | 1 | |
| StandardQueueDuration | StandardQueueDuration | 1 | |
| StandardQueueDurationUnit | StandardQueueDurationUnit | 1 | |
| StandardWorkQuantity1 | StandardWorkQuantity1 | 1 | |
| StandardWorkQuantity2 | StandardWorkQuantity2 | 1 | |
| StandardWorkQuantity3 | StandardWorkQuantity3 | 1 | |
| StandardWorkQuantity4 | StandardWorkQuantity4 | 1 | |
| StandardWorkQuantity5 | StandardWorkQuantity5 | 1 | |
| StandardWorkQuantity6 | StandardWorkQuantity6 | 1 | |
| StandardWorkQuantityUnit1 | StandardWorkQuantityUnit1 | 1 | |
| StandardWorkQuantityUnit2 | StandardWorkQuantityUnit2 | 1 | |
| StandardWorkQuantityUnit3 | StandardWorkQuantityUnit3 | 1 | |
| StandardWorkQuantityUnit4 | StandardWorkQuantityUnit4 | 1 | |
| StandardWorkQuantityUnit5 | StandardWorkQuantityUnit5 | 1 | |
| StandardWorkQuantityUnit6 | StandardWorkQuantityUnit6 | 1 | |
| Supplier | Supplier | 1 | |
| TeardownAndWaitIsParallel | TeardownAndWaitIsParallel | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Production Routing - Operation Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTIONROUTINGOPERATION (
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSSEQUENCE,
BILLOFOPERATIONSVARIANT,
BOOOPERATIONINTERNALID,
BOOOPINTERNALVERSIONCOUNTER,
_SUPPLIER,
_SUPPLIERCOMPANYBYPLANT,
BILLOFOPERATIONSBREAKDURATION,
BILLOFOPERATIONSREFGROUP,
BILLOFOPERATIONSREFTYPE,
BILLOFOPERATIONSREFVARIANT,
BOOOPERATIONISPHASE,
BOOPHASESUPERIOROPINTERNALID,
BREAKDURATIONUNIT,
BUSINESSPROCESS,
CAPACITYCATEGORYCODE,
CHANGENUMBER,
CONTROLRECIPEDESTINATION,
COSTCTRACTIVITYTYPE1,
COSTCTRACTIVITYTYPE2,
COSTCTRACTIVITYTYPE3,
COSTCTRACTIVITYTYPE4,
COSTCTRACTIVITYTYPE5,
COSTCTRACTIVITYTYPE6,
COSTELEMENT,
CREATEDBYUSER,
CREATIONDATE,
EMPLOYEESUITABILITY,
EMPLOYEEWAGEGROUP,
EMPLOYEEWAGETYPE,
FACTORYCALENDAR,
INSPECTIONLOTTYPE,
INSPRESULTRECORDINGVIEW,
INSPSBSTCOMPLETIONCONFIRMATION,
INSPSBSTHASNOTIMEORQUANTITY,
ISDELETED,
ISIMPLICITLYDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LEADTIMEREDUCTIONSTRATEGY,
LINESEGMENTTAKT,
LONGTEXTLANGUAGECODE,
MATERIALGROUP,
MAXIMUMNUMBEROFSPLITS,
MAXIMUMWAITDURATION,
MAXIMUMWAITDURATIONUNIT,
MINIMUMMOVEDURATION,
MINIMUMMOVEDURATIONUNIT,
MINIMUMQUEUEDURATION,
MINIMUMQUEUEDURATIONUNIT,
MINIMUMWAITDURATION,
MINIMUMWAITDURATIONUNIT,
MINPROCESSINGDURATIONPERSPLIT,
MINPROCESSINGDURNPERSPLITUNIT,
NUMBEROFCONFIRMATIONSLIPS,
NUMBEROFEMPLOYEES,
NUMBEROFOPERATIONPRICEUNITS,
NUMBEROFTIMETICKETS,
OPERATIONCONTROLPROFILE,
OPERATIONCOSTINGRELEVANCYTYPE,
OPERATIONHASNOOVERLAPPING,
OPERATIONOVERLAPPINGISPOSSIBLE,
OPERATIONOVERLAPPINGISREQUIRED,
OPERATIONREFERENCEQUANTITY,
OPERATIONSCRAPPERCENT,
OPERATIONSETUPGROUP,
OPERATIONSETUPGROUPCATEGORY,
OPERATIONSETUPTYPE,
OPERATIONSISALWAYSOVERLAPPING,
OPERATIONSPLITISREQUIRED,
OPERATIONSTANDARDTEXTCODE,
OPERATIONSTDWORKQTYGRPGCAT,
OPERATIONTEXT,
OPERATIONUNIT,
OPEXTERNALPROCESSINGCURRENCY,
OPEXTERNALPROCESSINGPRICE,
OPQTYTOBASEQTYDNMNTR,
OPQTYTOBASEQTYNMRTR,
ORDERHASNOSUBOPERATIONS,
OVERLAPMINIMUMDURATION,
OVERLAPMINIMUMDURATIONUNIT,
OVERLAPMINIMUMTRANSFERQTY,
OVERLAPMINIMUMTRANSFERQTYUNIT,
PERFEFFICIENCYRATIOCODE1,
PERFEFFICIENCYRATIOCODE2,
PERFEFFICIENCYRATIOCODE3,
PERFEFFICIENCYRATIOCODE4,
PERFEFFICIENCYRATIOCODE5,
PERFEFFICIENCYRATIOCODE6,
PLANNEDDELIVERYDURATION,
PLANT,
PURCHASECONTRACT,
PURCHASECONTRACTITEM,
PURCHASINGGROUP,
PURCHASINGINFORECDADDLGRPGNAME,
PURCHASINGINFORECORD,
PURCHASINGORGANIZATION,
STANDARDMOVEDURATION,
STANDARDMOVEDURATIONUNIT,
STANDARDQUEUEDURATION,
STANDARDQUEUEDURATIONUNIT,
STANDARDWORKQUANTITY1,
STANDARDWORKQUANTITY2,
STANDARDWORKQUANTITY3,
STANDARDWORKQUANTITY4,
STANDARDWORKQUANTITY5,
STANDARDWORKQUANTITY6,
STANDARDWORKQUANTITYUNIT1,
STANDARDWORKQUANTITYUNIT2,
STANDARDWORKQUANTITYUNIT3,
STANDARDWORKQUANTITYUNIT4,
STANDARDWORKQUANTITYUNIT5,
STANDARDWORKQUANTITYUNIT6,
SUPPLIER,
TEARDOWNANDWAITISPARALLEL,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
WORKCENTERINTERNALID,
WORKCENTERTYPECODE,
PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSVARIANT, BOOOPERATIONINTERNALID, BOOOPINTERNALVERSIONCOUNTER)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA