I_PRODUCTIONROUTINGOPERATION

CDS View

Production Routing - Operation Details

I_PRODUCTIONROUTINGOPERATION is a CDS View in S/4HANA. Production Routing - Operation Details. It contains 119 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 119 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
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
P_ProdnRoutingOperation view_entity from COMPOSITE Production Routing Operation
R_ProdnRoutingOperationTP_2 view_entity from TRANSACTIONAL Production Routing Operation

Fields (119)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup ProductionRoutingGroup 3
KEY BillOfOperationsSequence ProductionRoutingSequence 3
KEY BillOfOperationsVariant ProductionRouting 3
KEY BOOOperationInternalID ProductionRoutingOpIntID 3
KEY BOOOpInternalVersionCounter ProductionRoutingOpIntVersion 3
_Supplier _Supplier 2
_SupplierCompanyByPlant _SupplierCompanyByPlant 2
BillOfOperationsBreakDuration BillOfOperationsBreakDuration 1
BillOfOperationsRefGroup BillOfOperationsRefGroup 2
BillOfOperationsRefType BillOfOperationsRefType 2
BillOfOperationsRefVariant BillOfOperationsRefVariant 2
BOOOperationIsPhase BOOOperationIsPhase 2
BOOPhaseSuperiorOpInternalID BOOPhaseSuperiorOpInternalID 2
BreakDurationUnit BreakDurationUnit 2
BusinessProcess BusinessProcess 2
CapacityCategoryCode CapacityCategoryCode 2
ChangeNumber ChangeNumber 2
ControlRecipeDestination ControlRecipeDestination 2
CostCtrActivityType1 CostCtrActivityType1 2
CostCtrActivityType2 CostCtrActivityType2 2
CostCtrActivityType3 CostCtrActivityType3 2
CostCtrActivityType4 CostCtrActivityType4 2
CostCtrActivityType5 CostCtrActivityType5 2
CostCtrActivityType6 CostCtrActivityType6 2
CostElement CostElement 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
EmployeeSuitability EmployeeSuitability 2
EmployeeWageGroup EmployeeWageGroup 2
EmployeeWageType EmployeeWageType 2
FactoryCalendar FactoryCalendar 2
InspectionLotType InspectionLotType 2
InspResultRecordingView InspResultRecordingView 2
InspSbstCompletionConfirmation InspSbstCompletionConfirmation 2
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity 2
IsDeleted IsDeleted 2
IsImplicitlyDeleted IsImplicitlyDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LeadTimeReductionStrategy LeadTimeReductionStrategy 2
LineSegmentTakt LineSegmentTakt 2
LongTextLanguageCode LongTextLanguageCode 2
MaterialGroup MaterialGroup 2
MaximumNumberOfSplits MaximumNumberOfSplits 2
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 2
NumberOfConfirmationSlips NumberOfConfirmationSlips 2
NumberOfEmployees NumberOfEmployees 2
NumberOfOperationPriceUnits NumberOfOperationPriceUnits 2
NumberOfTimeTickets NumberOfTimeTickets 2
OperationControlProfile OperationControlProfile 2
OperationCostingRelevancyType OperationCostingRelevancyType 2
OperationHasNoOverlapping OperationHasNoOverlapping 2
OperationOverlappingIsPossible OperationOverlappingIsPossible 2
OperationOverlappingIsRequired OperationOverlappingIsRequired 2
OperationReferenceQuantity OperationReferenceQuantity 2
OperationScrapPercent OperationScrapPercent 2
OperationSetupGroup OperationSetupGroup 2
OperationSetupGroupCategory OperationSetupGroupCategory 2
OperationSetupType OperationSetupType 2
OperationsIsAlwaysOverlapping OperationsIsAlwaysOverlapping 2
OperationSplitIsRequired OperationSplitIsRequired 2
OperationStandardTextCode OperationStandardTextCode 2
OperationStdWorkQtyGrpgCat OperationStdWorkQtyGrpgCat 2
OperationText OperationText 2
OperationUnit OperationUnit 2
OpExternalProcessingCurrency OpExternalProcessingCurrency 2
OpExternalProcessingPrice OpExternalProcessingPrice 2
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr 2
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr 2
OrderHasNoSubOperations OrderHasNoSubOperations 2
OverlapMinimumDuration OverlapMinimumDuration 1
OverlapMinimumDurationUnit OverlapMinimumDurationUnit 1
OverlapMinimumTransferQty OverlapMinimumTransferQty 1
OverlapMinimumTransferQtyUnit OverlapMinimumTransferQtyUnit 1
PerfEfficiencyRatioCode1 PerfEfficiencyRatioCode1 2
PerfEfficiencyRatioCode2 PerfEfficiencyRatioCode2 2
PerfEfficiencyRatioCode3 PerfEfficiencyRatioCode3 2
PerfEfficiencyRatioCode4 PerfEfficiencyRatioCode4 2
PerfEfficiencyRatioCode5 PerfEfficiencyRatioCode5 2
PerfEfficiencyRatioCode6 PerfEfficiencyRatioCode6 2
PlannedDeliveryDuration PlannedDeliveryDuration 2
Plant Plant 2
PurchaseContract PurchaseContract 2
PurchaseContractItem PurchaseContractItem 2
PurchasingGroup PurchasingGroup 2
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName 2
PurchasingInfoRecord PurchasingInfoRecord 2
PurchasingOrganization PurchasingOrganization 2
StandardMoveDuration StandardMoveDuration 1
StandardMoveDurationUnit StandardMoveDurationUnit 1
StandardQueueDuration StandardQueueDuration 1
StandardQueueDurationUnit StandardQueueDurationUnit 1
StandardWorkQuantity1 StandardWorkQuantity1 2
StandardWorkQuantity2 StandardWorkQuantity2 2
StandardWorkQuantity3 StandardWorkQuantity3 2
StandardWorkQuantity4 StandardWorkQuantity4 2
StandardWorkQuantity5 StandardWorkQuantity5 2
StandardWorkQuantity6 StandardWorkQuantity6 2
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 2
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 2
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 2
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 2
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 2
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 2
Supplier Supplier 2
TeardownAndWaitIsParallel TeardownAndWaitIsParallel 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 2 
@AbapCatalog.sqlViewName: 'IPRODNRTGOPR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'BOOOpInternalVersionCounter'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Routing - Operation Details'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #XXL, dataClass: #MASTER }
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
define view I_ProductionRoutingOperation
  as select from I_MfgBOOOperationChangeState   as _Op
  association [1..*] to I_RoutingHeader              as _Header on  $projection.BillOfOperationsType    =  _Header.BillOfOperationsType
                                                                and $projection.BillOfOperationsGroup   =  _Header.BillOfOperationsGroup
                                                                and $projection.BillOfOperationsVariant =  _Header.BillOfOperationsVariant
                                                                and $projection.ValidityStartDate       <= _Header.ValidityEndDate
                                                                and $projection.ValidityEndDate         >= _Header.ValidityStartDate
                                                                and _Header.IsDeleted                   <> 'X'
                                                                and _Header.IsImplicitlyDeleted         <> 'X'
  association [1..*] to I_MfgBOOOperationChangeState as _SupOp  on  $projection.BillOfOperationsType         =  _SupOp.BillOfOperationsType
                                                                and $projection.BillOfOperationsGroup        =  _SupOp.BillOfOperationsGroup
                                                                and $projection.BOOPhaseSuperiorOpInternalID =  _SupOp.BOOOperationInternalID
                                                                and $projection.ValidityStartDate            <= _SupOp.ValidityEndDate
                                                                and $projection.ValidityEndDate              >= _SupOp.ValidityStartDate
                                                                and $projection.BOOOperationIsPhase          =  'X'
                                                                and _SupOp.IsDeleted                         <> 'X'
                                                                and _SupOp.IsImplicitlyDeleted               <> 'X'
{
      //I_MFGBOOOPERATIONCHANGESTATE

      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key _Op.BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key _Op.BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key _Op.BillOfOperationsVariant,
      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key _Op.BOOOperationInternalID,
      @ObjectModel.text.element: 'OperationText'
  key _Op.BOOOpInternalVersionCounter,
      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key _Op.BillOfOperationsSequence,
      @ObjectModel.foreignKey.association: '_BOOSqncOperationAssgmtChgSt'
  key _Op.BOOSqncOpAssgmtIntVersionCntr,
      

      OperationExternalID,
      @ObjectModel.text.element: 'OperationText'
      cast(Operation as pph_vornr preserving type) as Operation,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @ObjectModel.foreignKey.association: '_ChangeMaster'
      ChangeNumber,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      IsDeleted,
      IsImplicitlyDeleted,
      @Semantics.text: true
      OperationText,
      @ObjectModel.foreignKey.association: '_LongTextLanguage'
      LongTextLanguageCode,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_OperationControlProfile'
      OperationControlProfile,
      @ObjectModel.foreignKey.association: '_OperationStandardText'
      OperationStandardTextCode,
      @ObjectModel.foreignKey.association: '_WorkCenterType'
      WorkCenterTypeCode,
      @ObjectModel.foreignKey.association: '_WorkCenter'
      WorkCenterInternalID,
      @ObjectModel.foreignKey.association: '_CapacityCategory'
      CapacityCategoryCode,
      CostElement,
      OperationCostingRelevancyType,
      NumberOfTimeTickets,
      NumberOfConfirmationSlips,
      @ObjectModel.foreignKey.association: '_EmployeeWageGroup'
      EmployeeWageGroup,
      EmployeeWageType,
      @ObjectModel.foreignKey.association: '_EmployeeSuitability'
      EmployeeSuitability,
      NumberOfEmployees,
      BillOfOperationsRefType,
      BillOfOperationsRefGroup,
      BillOfOperationsRefVariant,
      LineSegmentTakt,
      OperationStdWorkQtyGrpgCat,
      OrderHasNoSubOperations,
      @ObjectModel.foreignKey.association: '_OperationSetupType'
      OperationSetupType,
      @ObjectModel.foreignKey.association: '_OperationSetupGroupCategory'
      OperationSetupGroupCategory,
      @ObjectModel.foreignKey.association: '_OperationSetupGroup'
      OperationSetupGroup,
      BOOOperationIsPhase,
      BOOPhaseSuperiorOpInternalID,
      @ObjectModel.foreignKey.association: '_ControlRecipeDestination'
      ControlRecipeDestination,
      OpIsExtlyProcdWithSubcontrg,
      PurchasingInfoRecord,
      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      PurchasingOrganization,
      PurchaseContract,
      PurchaseContractItem,
      PurchasingInfoRecdAddlGrpgName,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      MaterialGroup,
      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      PurchasingGroup,
      @ObjectModel.foreignKey.association: '_Supplier'
      Supplier,
      PlannedDeliveryDuration,
      NumberOfOperationPriceUnits,
      @Semantics.currencyCode: true
      OpExternalProcessingCurrency,
      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      OpExternalProcessingPrice,
      InspectionLotType,
      InspResultRecordingView,
      InspSbstCompletionConfirmation,
      InspSbstHasNoTimeOrQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      @DefaultAggregation: #SUM
      OperationReferenceQuantity,
      @Semantics.unitOfMeasure: true
      OperationUnit,
      OperationScrapPercent,
      OpQtyToBaseQtyNmrtr,
      OpQtyToBaseQtyDnmntr,
      StandardWorkFormulaParam1,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      @DefaultAggregation: #SUM
      StandardWorkQuantity1,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit1,
      CostCtrActivityType1,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio1'
      PerfEfficiencyRatioCode1,
      StandardWorkFormulaParam2,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      @DefaultAggregation: #SUM
      StandardWorkQuantity2,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit2,
      CostCtrActivityType2,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio2'
      PerfEfficiencyRatioCode2,
      StandardWorkFormulaParam3,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      @DefaultAggregation: #SUM
      StandardWorkQuantity3,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit3,
      CostCtrActivityType3,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio3'
      PerfEfficiencyRatioCode3,
      StandardWorkFormulaParam4,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      @DefaultAggregation: #SUM
      StandardWorkQuantity4,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit4,
      CostCtrActivityType4,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio4'
      PerfEfficiencyRatioCode4,
      StandardWorkFormulaParam5,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      @DefaultAggregation: #SUM
      StandardWorkQuantity5,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit5,
      CostCtrActivityType5,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio5'
      PerfEfficiencyRatioCode5,
      StandardWorkFormulaParam6,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      @DefaultAggregation: #SUM
      StandardWorkQuantity6,
      @Semantics.unitOfMeasure: true
      StandardWorkQuantityUnit6,
      CostCtrActivityType6,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio6'
      PerfEfficiencyRatioCode6,
      BusinessProcess,
      LeadTimeReductionStrategy,
      TeardownAndWaitIsParallel,
      BillOfOperationsBreakDuration,
      @Semantics.unitOfMeasure: true
      BreakDurationUnit,
      MaximumWaitDuration,
      @Semantics.unitOfMeasure: true
      MaximumWaitDurationUnit,
      MinimumWaitDuration,
      @Semantics.unitOfMeasure: true
      MinimumWaitDurationUnit,
      StandardQueueDuration,
      @Semantics.unitOfMeasure: true
      StandardQueueDurationUnit,
      MinimumQueueDuration,
      @Semantics.unitOfMeasure: true
      MinimumQueueDurationUnit,
      StandardMoveDuration,
      @Semantics.unitOfMeasure: true
      StandardMoveDurationUnit,
      MinimumMoveDuration,
      @Semantics.unitOfMeasure: true
      MinimumMoveDurationUnit,
      OperationSplitIsRequired,
      MaximumNumberOfSplits,
      MinProcessingDurationPerSplit,
      @Semantics.unitOfMeasure: true
      MinProcessingDurnPerSplitUnit,
      OperationOverlappingIsRequired,
      OperationOverlappingIsPossible,
      OperationsIsAlwaysOverlapping,
      OperationHasNoOverlapping,
      OverlapMinimumDuration,
      @Semantics.unitOfMeasure: true
      OverlapMinimumDurationUnit,
      OverlapMinimumTransferQty,
      @Semantics.unitOfMeasure: true
      OverlapMinimumTransferQtyUnit,
      _Op.FactoryCalendar,
      /* Associations */
      //I_MFGBOOOPERATIONCHANGESTATE

      _Op._BillOfOperations,
      _BillOfOperationsBreakDurnUnit,
      _BillOfOperationsGroup,
      //      _BillOfOperationsOperation,

      _BillOfOperationsSequence,
      _BillOfOperationsType,
      //      @Consumption.hidden: true

      _BOOOperationInternalID,
      _BOOSqncOperationAssgmtChgSt,
      _CapacityCategory,
      _ChangeMaster,
      _ControlRecipeDestination,
      _EmployeeSuitability,
      _EmployeeWageGroup,
      _InspectionLotType,
      _InspResultRecordingView,
      _LeadTimeReductionStrategy,
      _LongTextLanguage,
      _MaterialGroup,
      _MaximumWaitDurationUnit,
      _MinimumMoveDurationUnit,
      _MinimumQueueDurationUnit,
      _MinimumWaitDurationUnit,
      _MinProcessingDurnPerSplitUnit,
      _OperationControlProfile,
      _OperationSetupGroup,
      _OperationSetupGroupCategory,
      _OperationSetupType,
      _OperationStandardText,
      _OperationStdWorkQtyGrpgCat,
      _OperationUnit,
      _OpExternalProcessingCurrency,
      _OverlapMinimumDurationUnit,
      _OverlapMinimumTransferQtyUnit,
      _PerformanceEfficiencyRatio1,
      _PerformanceEfficiencyRatio2,
      _PerformanceEfficiencyRatio3,
      _PerformanceEfficiencyRatio4,
      _PerformanceEfficiencyRatio5,
      _PerformanceEfficiencyRatio6,
      _Plant,
      _PurchaseContract,
      _PurchaseContractItem,
      _PurchasingGroup,
      _PurchasingInfoRecord,
      _PurchasingOrganization,
      _StandardMoveDurationUnit,
      _StandardQueueDurationUnit,
      _StandardWorkFormulaParameter1,
      _StandardWorkFormulaParameter2,
      _StandardWorkFormulaParameter3,
      _StandardWorkFormulaParameter4,
      _StandardWorkFormulaParameter5,
      _StandardWorkFormulaParameter6,
      _StandardWorkQuantityUnit1,
      _StandardWorkQuantityUnit2,
      _StandardWorkQuantityUnit3,
      _StandardWorkQuantityUnit4,
      _StandardWorkQuantityUnit5,
      _StandardWorkQuantityUnit6,
      _Supplier,
      @Consumption.hidden: true
      _Op._SupplierCompanyByPlant,
      _WorkCenter,
      @Consumption.hidden: true
      _WorkCenterType,
      _Header,
      _SupOp
}
where
      _Op.BillOfOperationsType =  'N'
  and _Op.ValidityEndDate      >= _Op.ValidityStartDate
  and _Op.IsDeleted                  <> 'X'
  and _Op.IsImplicitlyDeleted        <> 'X'

Learn More