R_ProdnRoutingMatlAssgmtTP_2

DDL: R_PRODNROUTINGMATLASSGMTTP_2 Type: view_entity TRANSACTIONAL

Production Routing Material Assignment

R_ProdnRoutingMatlAssgmtTP_2 is a Transactional CDS View that provides data about "Production Routing Material Assignment" in SAP S/4HANA. It reads from 1 data source (I_RoutingMaterialAssignment) and exposes 17 fields with key fields Product, Plant, ProductionRoutingGroup, ProductionRouting, ProductionRoutingMatlAssgmt. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_RoutingMaterialAssignment I_RoutingMaterialAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..*] R_ProductionRoutingHeaderTP_2 _Header $projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup and $projection.ProductionRouting = _Header.ProductionRouting and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate
[1..1] I_MaterialText _MaterialText $projection.Product = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (9)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ProductionRoutingMatlAssgmt view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Routing Material Assignment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Product Material Product
KEY Plant Plant
KEY ProductionRoutingGroup BillOfOperationsGroup
KEY ProductionRouting BillOfOperationsVariant
KEY ProductionRoutingMatlAssgmt BOOToMaterialInternalID
KEY ProductionRtgMatlAssgmtIntVers BOOMatlInternalVersionCounter
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ValidityStartDate
ValidityEndDate
ChangeNumber ChangeNumber
ChangedDateTime _ProdnRtgTP ChangedDateTime
ProductName _MaterialText MaterialName
_ProdnRtgTP _ProdnRtgTP
_Header _Header 
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
@ObjectModel.representativeKey: 'ProductionRoutingMatlAssgmt'
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Production Routing Material Assignment'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER}
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view entity R_ProdnRoutingMatlAssgmtTP_2
  as select from I_RoutingMaterialAssignment
  association [1..*] to R_ProductionRoutingHeaderTP_2  as _Header       on  $projection.ProductionRoutingGroup =  _Header.ProductionRoutingGroup
                                                                        and $projection.ProductionRouting      =  _Header.ProductionRouting
                                                                        and $projection.ValidityEndDate        >= _Header.ValidityStartDate
                                                                        and $projection.ValidityStartDate      <= _Header.ValidityEndDate
  association        to parent R_ProductionRoutingTP_2 as _ProdnRtgTP   on  $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
                                                                        and $projection.ProductionRouting      = _ProdnRtgTP.ProductionRouting

  association [1..1] to I_MaterialText                 as _MaterialText on  $projection.Product    = _MaterialText.Material
                                                                        and _MaterialText.Language = $session.system_language

{
      //I_ProductionRoutingMaterialAssgmt

      @Consumption.valueHelpDefinition: [{entity:{ name: 'C_MassMaintCapProductVH', element: 'Product'} }]
      @EndUserText.label: 'Product'
  key Material                                              as Product,
  key Plant,
  key BillOfOperationsGroup                                 as ProductionRoutingGroup,
  key BillOfOperationsVariant                               as ProductionRouting,
  key BOOToMaterialInternalID                               as ProductionRoutingMatlAssgmt,
  key BOOMatlInternalVersionCounter                         as ProductionRtgMatlAssgmtIntVers,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      @Semantics.businessDate.from: true
      cast(ValidityStartDate  as pph_begda preserving type) as ValidityStartDate,
      //      ValidityStartDate,

      @Semantics.businessDate.to: true
      cast(ValidityEndDate  as pph_endda preserving type)   as ValidityEndDate,
      //      ValidityEndDate,

      ChangeNumber,
      _ProdnRtgTP.ChangedDateTime,
      _MaterialText.MaterialName                            as ProductName,

      /* Associations */
      //I_ProductionRoutingMaterialAssgmt

      _ProdnRtgTP,
      _Header
}
where
      IsDeleted           <> 'X'
  and IsImplicitlyDeleted <> 'X'

Learn More