Which tables does I_ProdnRtgOperationTP use?

I_ProdnRtgOperationTP reads from 1 data source(s): I_ProductionRoutingOperation.

I_ProdnRtgOperationTP

Q: How many fields does I_ProdnRtgOperationTP have?

I_ProdnRtgOperationTP has 133 fields. Key fields: ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, ProductionRoutingOpIntVersion.

DDL: I_PRODNRTGOPERATIONTP SQL: IPRODNRTGOPTP Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_RTG

Transaction View for Production Routing Operation

I_ProdnRtgOperationTP is a Transactional CDS View that provides data about "Transaction View for Production Routing Operation" in SAP S/4HANA. It reads from 1 data source (I_ProductionRoutingOperation) and exposes 133 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, ProductionRoutingOpIntVersion. It has 9 associations to related views. Part of development package VDM_PP_MD_RTG.

Data Sources (1)

Source	Alias	Join Type
I_ProductionRoutingOperation	I_ProductionRoutingOperation	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..*]	I_ProductionRoutingSubOpTP	_SubOp	`$projection.ProductionRoutingGroup = _SubOp.ProductionRoutingGroup and $projection.ProductionRouting = _SubOp.ProductionRouting and $projection.ProductionRoutingOpIntID = _SubOp.SuperiorOperationInternalID and $projection.ProductionRoutingSequence = _SubOp.ProductionRoutingSequence and $projection.ValidityEndDate >= _SubOp.ValidityStartDate and $projection.ValidityStartDate <= _SubOp.ValidityEndDate`
[0..*]	I_ProdnRoutingOpCompAllocTP	_OpCompAlloc	`$projection.ProductionRoutingGroup = _OpCompAlloc.ProductionRoutingGroup and $projection.ProductionRouting = _OpCompAlloc.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpCompAlloc.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpCompAlloc.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpCompAlloc.ValidityStartDate and $projection.ValidityStartDate <= _OpCompAlloc.ValidityEndDate`
[1..*]	I_ProductionRoutingHeaderTP	_Header	`$projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup and $projection.ProductionRouting = _Header.ProductionRouting and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate`
[0..1]	I_TaskListOperationLongText	_LongText	`$projection.ProductionRoutingGroup = _LongText.TaskListGroup and $projection.ProductionRoutingOpIntID = _LongText.BOOOperationInternalID and $projection.ProductionRoutingOpIntVersion = _LongText.BOOInternalVersionCounter and $projection.LongTextLanguageCode is not null and _LongText.TaskListType = 'N'`
[0..*]	R_ProdnRtgOpMiscPRTAssgmtTP	_OpMiscPRTAssgmt	`$projection.ProductionRoutingGroup = _OpMiscPRTAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _OpMiscPRTAssgmt.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpMiscPRTAssgmt.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpMiscPRTAssgmt.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpMiscPRTAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _OpMiscPRTAssgmt.ValidityEndDate`
[0..*]	R_ProdnRtgOpDocPRTAssgmtTP	_OpDocPRTAssgmt	`$projection.ProductionRoutingGroup = _OpDocPRTAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _OpDocPRTAssgmt.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpDocPRTAssgmt.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpDocPRTAssgmt.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpDocPRTAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _OpDocPRTAssgmt.ValidityEndDate`
[0..*]	R_ProdnRtgOpMatlPRTAssgmtTP	_OpMatlPRTAssgmt	`$projection.ProductionRoutingGroup = _OpMatlPRTAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _OpMatlPRTAssgmt.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpMatlPRTAssgmt.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpMatlPRTAssgmt.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpMatlPRTAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _OpMatlPRTAssgmt.ValidityEndDate`
[0..*]	R_ProdnRtgOpEquipPRTAssgmtTP	_OpEquipPRTAssgmt	`$projection.ProductionRoutingGroup = _OpEquipPRTAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _OpEquipPRTAssgmt.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpEquipPRTAssgmt.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpEquipPRTAssgmt.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpEquipPRTAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _OpEquipPRTAssgmt.ValidityEndDate -- Inspection Characteristics`
[0..*]	R_ProdnRtgInspCharcsAssgmtTP	_OpInspCharcsAssgmt	`$projection.ProductionRoutingGroup = _OpInspCharcsAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _OpInspCharcsAssgmt.ProductionRouting and $projection.ProductionRoutingOpIntID = _OpInspCharcsAssgmt.ProductionRoutingOpIntID and $projection.ProductionRoutingSequence = _OpInspCharcsAssgmt.ProductionRoutingSequence and $projection.ValidityEndDate >= _OpInspCharcsAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _OpInspCharcsAssgmt.ValidityEndDate`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Transaction View for Production Routing Operation	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.representativeKey	ProductionRoutingOpIntVersion	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (133)

Key	Field	Source Table	Source Field
KEY	ProductionRoutingGroup		BillOfOperationsGroup
KEY	ProductionRouting		BillOfOperationsVariant
KEY	ProductionRoutingSequence		BillOfOperationsSequence
KEY	ProductionRoutingOpIntID		BOOOperationInternalID
KEY	ProductionRoutingOpIntVersion		BOOOpInternalVersionCounter
	Operation
	CreationDate		CreationDate
	CreatedByUser		CreatedByUser
	LastChangeDate		LastChangeDate
	LastChangedByUser		LastChangedByUser
	ChangeNumber		ChangeNumber
	ValidityStartDate		ValidityStartDate
	ValidityEndDate		ValidityEndDate
	IsDeleted		IsDeleted
	IsImplicitlyDeleted		IsImplicitlyDeleted
	OperationText		OperationText
	LongTextLanguageCode		LongTextLanguageCode
	Plant		Plant
	OperationControlProfile		OperationControlProfile
	OperationStandardTextCode		OperationStandardTextCode
	WorkCenterTypeCode		WorkCenterTypeCode
	WorkCenterInternalID		WorkCenterInternalID
	CapacityCategoryCode		CapacityCategoryCode
	CostElement		CostElement
	OperationCostingRelevancyType		OperationCostingRelevancyType
	NumberOfTimeTickets		NumberOfTimeTickets
	NumberOfConfirmationSlips		NumberOfConfirmationSlips
	EmployeeWageGroup		EmployeeWageGroup
	EmployeeWageType		EmployeeWageType
	EmployeeSuitability		EmployeeSuitability
	NumberOfEmployees		NumberOfEmployees
	BillOfOperationsRefType		BillOfOperationsRefType
	BillOfOperationsRefGroup		BillOfOperationsRefGroup
	BillOfOperationsRefVariant		BillOfOperationsRefVariant
	LineSegmentTakt		LineSegmentTakt
	OperationStdWorkQtyGrpgCat		OperationStdWorkQtyGrpgCat
	OrderHasNoSubOperations		OrderHasNoSubOperations
	OperationSetupType		OperationSetupType
	OperationSetupGroupCategory		OperationSetupGroupCategory
	OperationSetupGroup		OperationSetupGroup
	BOOOperationIsPhase		BOOOperationIsPhase
	BOOPhaseSuperiorOpInternalID		BOOPhaseSuperiorOpInternalID
	ControlRecipeDestination		ControlRecipeDestination
	OpIsExtlyProcdWithSubcontrg
	PurchasingInfoRecord		PurchasingInfoRecord
	PurchasingOrganization		PurchasingOrganization
	PurchaseContract		PurchaseContract
	PurchaseContractItem		PurchaseContractItem
	PurchasingInfoRecdAddlGrpgName		PurchasingInfoRecdAddlGrpgName
	MaterialGroup		MaterialGroup
	PurchasingGroup		PurchasingGroup
	Supplier		Supplier
	PlannedDeliveryDuration		PlannedDeliveryDuration
	NumberOfOperationPriceUnits		NumberOfOperationPriceUnits
	OpExternalProcessingCurrency		OpExternalProcessingCurrency
	OpExternalProcessingPrice		OpExternalProcessingPrice
	InspectionLotType		InspectionLotType
	InspResultRecordingView		InspResultRecordingView
	InspSbstCompletionConfirmation		InspSbstCompletionConfirmation
	InspSbstHasNoTimeOrQuantity		InspSbstHasNoTimeOrQuantity
	OperationReferenceQuantity		OperationReferenceQuantity
	OperationUnit		OperationUnit
	OperationScrapPercent		OperationScrapPercent
	OpQtyToBaseQtyNmrtr		OpQtyToBaseQtyNmrtr
	OpQtyToBaseQtyDnmntr		OpQtyToBaseQtyDnmntr
	StandardWorkQuantity1		StandardWorkQuantity1
	StandardWorkQuantityUnit1		StandardWorkQuantityUnit1
	CostCtrActivityType1		CostCtrActivityType1
	PerfEfficiencyRatioCode1		PerfEfficiencyRatioCode1
	StandardWorkQuantity2		StandardWorkQuantity2
	StandardWorkQuantityUnit2		StandardWorkQuantityUnit2
	CostCtrActivityType2		CostCtrActivityType2
	PerfEfficiencyRatioCode2		PerfEfficiencyRatioCode2
	StandardWorkQuantity3		StandardWorkQuantity3
	StandardWorkQuantityUnit3		StandardWorkQuantityUnit3
	CostCtrActivityType3		CostCtrActivityType3
	PerfEfficiencyRatioCode3		PerfEfficiencyRatioCode3
	StandardWorkQuantity4		StandardWorkQuantity4
	StandardWorkQuantityUnit4		StandardWorkQuantityUnit4
	CostCtrActivityType4		CostCtrActivityType4
	PerfEfficiencyRatioCode4		PerfEfficiencyRatioCode4
	StandardWorkQuantity5		StandardWorkQuantity5
	StandardWorkQuantityUnit5		StandardWorkQuantityUnit5
	CostCtrActivityType5		CostCtrActivityType5
	PerfEfficiencyRatioCode5		PerfEfficiencyRatioCode5
	StandardWorkQuantity6		StandardWorkQuantity6
	StandardWorkQuantityUnit6		StandardWorkQuantityUnit6
	CostCtrActivityType6		CostCtrActivityType6
	PerfEfficiencyRatioCode6		PerfEfficiencyRatioCode6
	BusinessProcess		BusinessProcess
	LeadTimeReductionStrategy		LeadTimeReductionStrategy
	TeardownAndWaitIsParallel		TeardownAndWaitIsParallel
	BillOfOperationsBreakDuration		BillOfOperationsBreakDuration
	BreakDurationUnit		BreakDurationUnit
	MaximumWaitDuration		MaximumWaitDuration
	MaximumWaitDurationUnit		MaximumWaitDurationUnit
	MinimumWaitDuration		MinimumWaitDuration
	MinimumWaitDurationUnit		MinimumWaitDurationUnit
	StandardQueueDuration		StandardQueueDuration
	StandardQueueDurationUnit		StandardQueueDurationUnit
	MinimumQueueDuration		MinimumQueueDuration
	MinimumQueueDurationUnit		MinimumQueueDurationUnit
	StandardMoveDuration		StandardMoveDuration
	StandardMoveDurationUnit		StandardMoveDurationUnit
	MinimumMoveDuration		MinimumMoveDuration
	MinimumMoveDurationUnit		MinimumMoveDurationUnit
	OperationSplitIsRequired		OperationSplitIsRequired
	MaximumNumberOfSplits		MaximumNumberOfSplits
	MinProcessingDurationPerSplit		MinProcessingDurationPerSplit
	MinProcessingDurnPerSplitUnit		MinProcessingDurnPerSplitUnit
	OperationOverlappingIsRequired		OperationOverlappingIsRequired
	OperationOverlappingIsPossible		OperationOverlappingIsPossible
	OperationsIsAlwaysOverlapping		OperationsIsAlwaysOverlapping
	OverlapMinimumDuration		OverlapMinimumDuration
	OverlapMinimumDurationUnit		OverlapMinimumDurationUnit
	OverlapMinimumTransferQty		OverlapMinimumTransferQty
	OverlapMinimumTransferQtyUnit		OverlapMinimumTransferQtyUnit
	FactoryCalendar		FactoryCalendar
	ChangedDateTime	_NonSqncTP	ChangedDateTime
	PlainLongText	_LongText	PlainLongText
	_Supplier		_Supplier
	_SupplierCompanyByPlant		_SupplierCompanyByPlant
	_Header		_Header
	_SubOp		_SubOp
	_OpCompAlloc		_OpCompAlloc
	_NonSqncTP		_NonSqncTP
	_LongText		_LongText
	_ProdnRtgTP		_ProdnRtgTP
	_OpMiscPRTAssgmt		_OpMiscPRTAssgmt
	_OpDocPRTAssgmt		_OpDocPRTAssgmt
	_OpMatlPRTAssgmt		_OpMatlPRTAssgmt
	_OpEquipPRTAssgmt		_OpEquipPRTAssgmt
	_OpInspCharcsAssgmt		_OpInspCharcsAssgmt

//@AbapCatalog.sqlViewName: 'IPRODNRTGOPTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transaction View for Production Routing Operation'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }
//@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'ProductionRoutingOpIntVersion'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity I_ProdnRtgOperationTP
  as select from I_ProductionRoutingOperation
  association [0..*] to I_ProductionRoutingSubOpTP         as _SubOp              on  $projection.ProductionRoutingGroup    =  _SubOp.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _SubOp.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _SubOp.SuperiorOperationInternalID
                                                                                  and $projection.ProductionRoutingSequence =  _SubOp.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _SubOp.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _SubOp.ValidityEndDate
  association [0..*] to I_ProdnRoutingOpCompAllocTP        as _OpCompAlloc        on  $projection.ProductionRoutingGroup    =  _OpCompAlloc.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpCompAlloc.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpCompAlloc.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpCompAlloc.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpCompAlloc.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpCompAlloc.ValidityEndDate
  association [1..*] to I_ProductionRoutingHeaderTP        as _Header             on  $projection.ProductionRoutingGroup =  _Header.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting      =  _Header.ProductionRouting
                                                                                  and $projection.ValidityEndDate        >= _Header.ValidityStartDate
                                                                                  and $projection.ValidityStartDate      <= _Header.ValidityEndDate
  //Plain Long Text

  association [0..1] to I_TaskListOperationLongText        as _LongText           on  $projection.ProductionRoutingGroup        = _LongText.TaskListGroup
                                                                                  and $projection.ProductionRoutingOpIntID      = _LongText.BOOOperationInternalID
                                                                                  and $projection.ProductionRoutingOpIntVersion = _LongText.BOOInternalVersionCounter
                                                                                  and $projection.LongTextLanguageCode          is not null
                                                                                  and _LongText.TaskListType                    = 'N'
  //Misc PRT Assignment

  association [0..*] to R_ProdnRtgOpMiscPRTAssgmtTP        as _OpMiscPRTAssgmt    on  $projection.ProductionRoutingGroup    =  _OpMiscPRTAssgmt.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpMiscPRTAssgmt.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpMiscPRTAssgmt.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpMiscPRTAssgmt.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpMiscPRTAssgmt.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpMiscPRTAssgmt.ValidityEndDate

  //Doc PRT Assignment

  association [0..*] to R_ProdnRtgOpDocPRTAssgmtTP         as _OpDocPRTAssgmt     on  $projection.ProductionRoutingGroup    =  _OpDocPRTAssgmt.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpDocPRTAssgmt.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpDocPRTAssgmt.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpDocPRTAssgmt.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpDocPRTAssgmt.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpDocPRTAssgmt.ValidityEndDate

  //Matl PRT Assignment

  association [0..*] to R_ProdnRtgOpMatlPRTAssgmtTP        as _OpMatlPRTAssgmt    on  $projection.ProductionRoutingGroup    =  _OpMatlPRTAssgmt.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpMatlPRTAssgmt.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpMatlPRTAssgmt.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpMatlPRTAssgmt.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpMatlPRTAssgmt.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpMatlPRTAssgmt.ValidityEndDate

  //Equip PRT Assignment

  association [0..*] to R_ProdnRtgOpEquipPRTAssgmtTP       as _OpEquipPRTAssgmt   on  $projection.ProductionRoutingGroup    =  _OpEquipPRTAssgmt.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpEquipPRTAssgmt.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpEquipPRTAssgmt.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpEquipPRTAssgmt.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpEquipPRTAssgmt.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpEquipPRTAssgmt.ValidityEndDate

  -- Inspection Characteristics
  association [0..*] to R_ProdnRtgInspCharcsAssgmtTP       as _OpInspCharcsAssgmt on  $projection.ProductionRoutingGroup    =  _OpInspCharcsAssgmt.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         =  _OpInspCharcsAssgmt.ProductionRouting
                                                                                  and $projection.ProductionRoutingOpIntID  =  _OpInspCharcsAssgmt.ProductionRoutingOpIntID
                                                                                  and $projection.ProductionRoutingSequence =  _OpInspCharcsAssgmt.ProductionRoutingSequence
                                                                                  and $projection.ValidityEndDate           >= _OpInspCharcsAssgmt.ValidityStartDate
                                                                                  and $projection.ValidityStartDate         <= _OpInspCharcsAssgmt.ValidityEndDate

  association        to I_ProdnRtgNonHistoricHdrTP         as _ProdnRtgTP         on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting

  association        to parent I_ProdnRtgNonHistoricSqncTP as _NonSqncTP          on  $projection.ProductionRoutingGroup    = _NonSqncTP.ProductionRoutingGroup
                                                                                  and $projection.ProductionRouting         = _NonSqncTP.ProductionRouting
                                                                                  and $projection.ProductionRoutingSequence = _NonSqncTP.ProductionRoutingSequence
{
  key BillOfOperationsGroup                           as ProductionRoutingGroup,
  key BillOfOperationsVariant                         as ProductionRouting,
  key BillOfOperationsSequence                        as ProductionRoutingSequence,
  key BOOOperationInternalID                          as ProductionRoutingOpIntID,
  key BOOOpInternalVersionCounter                     as ProductionRoutingOpIntVersion,
      /* Operation Data */

      @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,
      ChangeNumber,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      @Semantics.businessDate.to: true
      ValidityEndDate,
      IsDeleted,
      IsImplicitlyDeleted,
      @Semantics.text: true
      OperationText,
      LongTextLanguageCode,
      Plant,
      OperationControlProfile,
      OperationStandardTextCode,
      WorkCenterTypeCode,
      WorkCenterInternalID,
      CapacityCategoryCode,
      CostElement,
      OperationCostingRelevancyType,
      NumberOfTimeTickets,
      NumberOfConfirmationSlips,
      @Consumption.hidden: true // For Cloud

      EmployeeWageGroup,
      @Consumption.hidden: true // For Cloud

      EmployeeWageType,
      EmployeeSuitability,
      @Consumption.hidden: true // For Cloud

      NumberOfEmployees,
      BillOfOperationsRefType,
      BillOfOperationsRefGroup,
      BillOfOperationsRefVariant,
      LineSegmentTakt,
      OperationStdWorkQtyGrpgCat,
      OrderHasNoSubOperations,
      OperationSetupType,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      BOOOperationIsPhase,
      BOOPhaseSuperiorOpInternalID,
      ControlRecipeDestination,
      cast( OpIsExtlyProcdWithSubcontrg as pph_frdlb) as OpIsExtlyProcdWithSubcontrg,
      PurchasingInfoRecord,
      PurchasingOrganization,
      PurchaseContract,
      PurchaseContractItem,
      PurchasingInfoRecdAddlGrpgName,
      MaterialGroup,
      PurchasingGroup,
      Supplier,
      PlannedDeliveryDuration,
      NumberOfOperationPriceUnits,
      //      @Semantics.currencyCode: true

      OpExternalProcessingCurrency,
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      OpExternalProcessingPrice,
      InspectionLotType,
      InspResultRecordingView,
      InspSbstCompletionConfirmation,
      InspSbstHasNoTimeOrQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity,
      //      @Semantics.unitOfMeasure: true

      OperationUnit,
      OperationScrapPercent,
      OpQtyToBaseQtyNmrtr,
      OpQtyToBaseQtyDnmntr,
      //      StandardWorkFormulaParam1,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      StandardWorkQuantity1,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit1,
      CostCtrActivityType1,
      PerfEfficiencyRatioCode1,
      //      StandardWorkFormulaParam2,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      StandardWorkQuantity2,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit2,
      CostCtrActivityType2,
      PerfEfficiencyRatioCode2,
      //      StandardWorkFormulaParam3,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      StandardWorkQuantity3,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit3,
      CostCtrActivityType3,
      PerfEfficiencyRatioCode3,
      //      StandardWorkFormulaParam4,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      StandardWorkQuantity4,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit4,
      CostCtrActivityType4,
      PerfEfficiencyRatioCode4,
      //      StandardWorkFormulaParam5,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      StandardWorkQuantity5,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit5,
      CostCtrActivityType5,
      PerfEfficiencyRatioCode5,
      //      StandardWorkFormulaParam6,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      StandardWorkQuantity6,
      //      @Semantics.unitOfMeasure: true

      StandardWorkQuantityUnit6,
      CostCtrActivityType6,
      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,
      OverlapMinimumDuration,
      //      @Semantics.unitOfMeasure: true

      OverlapMinimumDurationUnit,
      OverlapMinimumTransferQty,
      //      @Semantics.unitOfMeasure: true

      OverlapMinimumTransferQtyUnit,
      FactoryCalendar,
      _NonSqncTP.ChangedDateTime,
      @Semantics.text: true
      _LongText.PlainLongText,

      /*Associations*/
      @Consumption.hidden: true
      _Supplier,
      @Consumption.hidden: true
      _SupplierCompanyByPlant,
      @Consumption.hidden: true
      _Header,
      _SubOp,
      _OpCompAlloc,
      _NonSqncTP,
      _LongText,
      _ProdnRtgTP,
      _OpMiscPRTAssgmt,
      _OpDocPRTAssgmt,
      _OpMatlPRTAssgmt,
      _OpEquipPRTAssgmt,
      _OpInspCharcsAssgmt
}
where
      IsDeleted           <> 'X'
  and IsImplicitlyDeleted <> 'X'

Depth:

I_ProdnRtgOperationTP view_entity

I_ProductionRoutingOperation view

A_ProductionRoutingOperation view_entity