R_ProductionRoutingHeaderTP_2

DDL: R_PRODUCTIONROUTINGHEADERTP_2 Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_RTG

Production Routing Header

R_ProductionRoutingHeaderTP_2 is a Transactional CDS View that provides data about "Production Routing Header" in SAP S/4HANA. It reads from 2 data sources (I_RoutingHeader, I_ProductionRouting) and exposes 35 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingInternalVers. It has 7 associations to related views. Part of development package VDM_PP_MD_RTG.

2 data source(s) 35 fields

Data Sources (2)

SourceAliasJoin Type
I_RoutingHeader plko from
I_ProductionRouting plkz inner

Associations (7)

CardinalityTargetAliasCondition
[0..*] R_ProdnRoutingMatlAssgmtTP_2 _MatlAssgmt $projection.ProductionRoutingGroup = _MatlAssgmt.ProductionRoutingGroup and $projection.ProductionRouting = _MatlAssgmt.ProductionRouting and $projection.ValidityEndDate >= _MatlAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _MatlAssgmt.ValidityEndDate
[1..*] R_ProdnRoutingSequenceTP_2 _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
[0..1] I_WorkCenter _WorkCenter $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
[0..1] I_WorkCenterType _WorkCenterType $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
[1..1] E_ProductionRoutingHeader _Extension $projection.ProductionRoutingGroup = _Extension.ProductionRoutingGroup and $projection.ProductionRouting = _Extension.ProductionRouting and $projection.ProductionRoutingInternalVers = _Extension.ProductionRoutingInternalVers and _Extension.BillOfOperationsType = 'N'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label 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 (35)

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
WorkCenterTypeCode I_RoutingHeader WorkCenterTypeCode
WorkCenterInternalID I_RoutingHeader WorkCenterInternalID
PlanningWorkCenter
ReplacedBillOfOperations I_RoutingHeader ReplacedBillOfOperations
_MatlAssgmt _MatlAssgmt
_ProdnRtgTP _ProdnRtgTP
_Sequence _Sequence
_UsageText _UsageText
_StatusText _StatusText
_MatlCount _MatlCount
_Plant _Plant
_WorkCenter _WorkCenter
_WorkCenterType _WorkCenterType 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: '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 R_ProductionRoutingHeaderTP_2
  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 R_ProdnRoutingMatlAssgmtTP_2   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 R_ProdnRoutingSequenceTP_2     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 R_ProductionRoutingTP_2 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
  association [0..1] to I_WorkCenter                   as _WorkCenter     on  $projection.WorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode
                                                                          and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
  association [0..1] to I_WorkCenterType               as _WorkCenterType on  $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode

  // Extensibility

  association [1..1] to E_ProductionRoutingHeader      as _Extension      on  $projection.ProductionRoutingGroup        = _Extension.ProductionRoutingGroup
                                                                          and $projection.ProductionRouting             = _Extension.ProductionRouting
                                                                          and $projection.ProductionRoutingInternalVers = _Extension.ProductionRoutingInternalVers
                                                                          and _Extension.BillOfOperationsType           = 'N'



{
  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,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      plko.MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
      plko.MaximumLotSizeQuantity,
      plko.BillOfOperationsUnit,
      plko.CreationDate,
      plko.CreatedByUser,
      plko.LastChangeDate,
      plko.LastChangedByUser,
      @Semantics.businessDate.from: true
      plko.ValidityStartDate,
      @Semantics.businessDate.to: true
      plko.ValidityEndDate,
      plko.ChangeNumber,
      _ProdnRtgTP.ChangedDateTime,
      @Semantics.text: true
      plko.PlainLongText,
      _Plant.PlantName,
      plko.WorkCenterTypeCode,
      plko.WorkCenterInternalID,
      plko._WorkCenter.WorkCenter    as PlanningWorkCenter,
      plko.ReplacedBillOfOperations,

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

Learn More