I_ProductionRoutingHeaderTP

DDL: I_PRODUCTIONROUTINGHEADERTP SQL: IRTGHDRTP Type: view_entity TRANSACTIONAL

Transaction View for Production Routing Header

I_ProductionRoutingHeaderTP is a Transactional CDS View that provides data about "Transaction View for Production Routing Header" in SAP S/4HANA. It reads from 2 data sources (I_RoutingHeader, I_ProductionRouting) and exposes 29 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingInternalVers. It has 4 associations to related views.

2 data source(s) 29 fields

Data Sources (2)

SourceAliasJoin Type
I_RoutingHeader plko from
I_ProductionRouting plkz inner

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ProdnRoutingMatlAssgmtTP _MatlAssgmt $projection.ProductionRoutingGroup = _MatlAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _MatlAssgmt.ProductionRouting and $projection.ValidityEndDate >= _MatlAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _MatlAssgmt.ValidityEndDate
[1..*] I_ProdnRtgSequenceTP _Sequence $projection.ProductionRoutingGroup = _Sequence.ProductionRoutingGroup and $projection.ProductionRouting = _Sequence.ProductionRouting and $projection.ValidityEndDate >= _Sequence.ValidityStartDate and $projection.ValidityStartDate <= _Sequence.ValidityEndDate
[0..1] I_ProdnRtgMatlCount _MatlCount $projection.ProductionRoutingGroup = _MatlCount.ProductionRoutingGroup and $projection.ProductionRouting = _MatlCount.ProductionRouting
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transaction View for Production Routing Header view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProductionRoutingInternalVers view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup I_RoutingHeader BillOfOperationsGroup
KEY ProductionRouting I_RoutingHeader BillOfOperationsVariant
KEY ProductionRoutingInternalVers I_RoutingHeader BOOInternalVersionCounter
IsMarkedForDeletion I_ProductionRouting IsMarkedForDeletion
BillOfOperationsDesc I_RoutingHeader BillOfOperationsDesc
Plant I_RoutingHeader Plant
BillOfOperationsUsage I_RoutingHeader BillOfOperationsUsage
BillOfOperationsStatus I_RoutingHeader BillOfOperationsStatus
ResponsiblePlannerGroup I_RoutingHeader ResponsiblePlannerGroup
MinimumLotSizeQuantity I_RoutingHeader MinimumLotSizeQuantity
MaximumLotSizeQuantity I_RoutingHeader MaximumLotSizeQuantity
BillOfOperationsUnit I_RoutingHeader BillOfOperationsUnit
CreationDate I_RoutingHeader CreationDate
CreatedByUser I_RoutingHeader CreatedByUser
LastChangeDate I_RoutingHeader LastChangeDate
LastChangedByUser I_RoutingHeader LastChangedByUser
ValidityStartDate I_RoutingHeader ValidityStartDate
ValidityEndDate I_RoutingHeader ValidityEndDate
ChangeNumber I_RoutingHeader ChangeNumber
ChangedDateTime _ProdnRtgTP ChangedDateTime
PlainLongText I_RoutingHeader PlainLongText
PlantName _Plant PlantName
_MatlAssgmt _MatlAssgmt
_ProdnRtgTP _ProdnRtgTP
_Sequence _Sequence
_UsageText _UsageText
_StatusText _StatusText
_MatlCount _MatlCount
_Plant _Plant 
//@AbapCatalog.sqlViewName: 'IRTGHDRTP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Transaction View for Production Routing Header'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.representativeKey: 'ProductionRoutingInternalVers'
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity I_ProductionRoutingHeaderTP
  as select from I_RoutingHeader     as plko
    inner join   I_ProductionRouting as plkz on  plko.BillOfOperationsType    = plkz.BillOfOperationsType
                                             and plko.BillOfOperationsGroup   = plkz.BillOfOperationsGroup
                                             and plko.BillOfOperationsVariant = plkz.BillOfOperationsVariant

  association [0..*] to I_ProdnRoutingMatlAssgmtTP        as _MatlAssgmt on  $projection.ProductionRoutingGroup =  _MatlAssgmt.ProductionRoutingGroup
                                                                         and $projection.ProductionRouting      =  _MatlAssgmt.ProductionRouting
                                                                         and $projection.ValidityEndDate        >= _MatlAssgmt.ValidityStartDate
                                                                         and $projection.ValidityStartDate      <= _MatlAssgmt.ValidityEndDate
  association [1..*] to I_ProdnRtgSequenceTP              as _Sequence   on  $projection.ProductionRoutingGroup =  _Sequence.ProductionRoutingGroup
                                                                         and $projection.ProductionRouting      =  _Sequence.ProductionRouting
                                                                         and $projection.ValidityEndDate        >= _Sequence.ValidityStartDate
                                                                         and $projection.ValidityStartDate      <= _Sequence.ValidityEndDate
  association        to parent I_ProdnRtgNonHistoricHdrTP as _ProdnRtgTP on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                         and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting

  association        to I_BillOfOperationsStatusText      as _StatusText on  $projection.BillOfOperationsStatus = _StatusText.BillOfOperationsStatus
                                                                         and _StatusText.Language               = $session.system_language
  association        to I_BillOfOperationsUsageText       as _UsageText  on  $projection.BillOfOperationsUsage = _UsageText.BillOfOperationsUsage
                                                                         and _UsageText.Language               = $session.system_language

  //Association for Product Count

  association [0..1] to I_ProdnRtgMatlCount               as _MatlCount  on  $projection.ProductionRoutingGroup = _MatlCount.ProductionRoutingGroup
                                                                         and $projection.ProductionRouting      = _MatlCount.ProductionRouting

  association [1..1] to I_Plant                           as _Plant      on  $projection.Plant = _Plant.Plant

{
  key plko.BillOfOperationsGroup     as ProductionRoutingGroup,
  key plko.BillOfOperationsVariant   as ProductionRouting,
  key plko.BOOInternalVersionCounter as ProductionRoutingInternalVers,
      plkz.IsMarkedForDeletion       as IsMarkedForDeletion, // DELKZ

      @Semantics.text: true
      plko.BillOfOperationsDesc,
      plko.Plant,
      plko.BillOfOperationsUsage,
      plko.BillOfOperationsStatus,
      plko.ResponsiblePlannerGroup,
      //BillOfOperationsProfile,

      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      plko.MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      plko.MaximumLotSizeQuantity,
      //      @Semantics.unitOfMeasure: true

      plko.BillOfOperationsUnit,
      plko.CreationDate,
      plko.CreatedByUser,
      plko.LastChangeDate,
      plko.LastChangedByUser,
      @Semantics.businessDate.from: true
      plko.ValidityStartDate,
      @Semantics.businessDate.to: true
      plko.ValidityEndDate,
      plko.ChangeNumber,
      //ChangedDateTime,

      _ProdnRtgTP.ChangedDateTime,
      @Semantics.text: true
      plko.PlainLongText,
      _Plant.PlantName,

      /* Associations */
      _MatlAssgmt,
      _ProdnRtgTP,
      _Sequence,
      _UsageText,
      _StatusText,
      _MatlCount,
      _Plant
}
where
      plko.IsDeleted           <> 'X'
  and plko.IsImplicitlyDeleted <> 'X'

Learn More