P_ProdnRoutingMatlAssgmtDEX

DDL: P_PRODNROUTINGMATLASSGMTDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

Production Routing Material Assignment

P_ProdnRoutingMatlAssgmtDEX is a Basic CDS View that provides data about "Production Routing Material Assignment" in SAP S/4HANA. It reads from 1 data source (mapl) and exposes 26 fields with key fields Product, Plant, BillOfOperationsType, ProductionRoutingGroup, ProductionRouting. It has 6 associations to related views. Part of development package VDM_PP_MD_RTG.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
mapl mapl from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_BillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperations.BillOfOperationsGroup and $projection.ProductionRouting = _BillOfOperations.BillOfOperationsVariant
[1..1] I_BOOMaterialAssignment _BOOMaterialAssignment $projection.Plant = _BOOMaterialAssignment.Plant and $projection.Product = _BOOMaterialAssignment.Material and $projection.BillOfOperationsType = _BOOMaterialAssignment.BillOfOperationsType and $projection.ProductionRoutingGroup = _BOOMaterialAssignment.BillOfOperationsGroup and $projection.ProductionRouting = _BOOMaterialAssignment.BillOfOperationsVariant and $projection.ProductionRoutingMatlAssgmt = _BOOMaterialAssignment.BOOToMaterialInternalID
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (7)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ProductionRtgMatlAssgmtIntVers view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY Product mapl matnr
KEY Plant mapl werks
KEY BillOfOperationsType mapl plnty
KEY ProductionRoutingGroup mapl plnnr
KEY ProductionRouting mapl plnal
KEY ProductionRoutingMatlAssgmt mapl zkriz
KEY ProductionRtgMatlAssgmtIntVers mapl zaehl
datuvasValidityStartDate
ValidityEndDate mapl valid_to
aennrasChangeNumber
CreationDate mapl andat
CreatedByUser
LastChangeDate mapl aedat
LastChangedByUser
IsDeleted mapl loekz
IsImplicitlyDeleted mapl loekz_inherited
Supplier mapl lifnr
Customer mapl kunr
SalesOrder mapl vbeln
SalesOrderItem mapl posnr
Associations_Product
_Plant _Plant
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BOOMaterialAssignment _BOOMaterialAssignment 
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'ProductionRtgMatlAssgmtIntVers'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER }
@VDM.viewType: #BASIC

define view entity P_ProdnRoutingMatlAssgmtDEX

  as select from mapl

  association [1..1] to I_BillOfOperationsType    as _BillOfOperationsType  on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [1..1] to I_BillOfOperationsGroup   as _BillOfOperationsGroup on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                            and $projection.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup
  association [1..1] to I_BillOfOperations        as _BillOfOperations      on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                            and $projection.ProductionRoutingGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                            and $projection.ProductionRouting = _BillOfOperations.BillOfOperationsVariant
  association [1..1] to I_BOOMaterialAssignment   as _BOOMaterialAssignment on  $projection.Plant                   = _BOOMaterialAssignment.Plant
                                                                            and $projection.Product                = _BOOMaterialAssignment.Material
                                                                            and $projection.BillOfOperationsType    = _BOOMaterialAssignment.BillOfOperationsType
                                                                            and $projection.ProductionRoutingGroup   = _BOOMaterialAssignment.BillOfOperationsGroup
                                                                            and $projection.ProductionRouting = _BOOMaterialAssignment.BillOfOperationsVariant
                                                                            and $projection.ProductionRoutingMatlAssgmt = _BOOMaterialAssignment.BOOToMaterialInternalID
  association [1..1] to I_Plant                   as _Plant                 on  $projection.Plant = _Plant.Plant

  association [1..1] to I_Product                 as _Product               on  $projection.Product = _Product.Product

{
      @ObjectModel.foreignKey.association: '_Product'
  key mapl.matnr                                                  as Product,
      @ObjectModel.foreignKey.association: '_Plant'
  key mapl.werks                                                  as Plant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key mapl.plnty                                                  as BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key mapl.plnnr                                                  as ProductionRoutingGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key mapl.plnal                                                  as ProductionRouting,
      @ObjectModel.foreignKey.association: '_BOOMaterialAssignment'
  key mapl.zkriz                                                  as ProductionRoutingMatlAssgmt,
  key mapl.zaehl                                                  as ProductionRtgMatlAssgmtIntVers,

      -- Validity
      @Semantics.businessDate.from: true 
      mapl.datuv                                                  as ValidityStartDate,
      @Semantics.businessDate.to: true 
      mapl.valid_to                                               as ValidityEndDate,

      -- Admin
    
      mapl.aennr                                                  as ChangeNumber,
      @Semantics.systemDate.createdAt: true
      mapl.andat                                                  as CreationDate,
      @Semantics.user.createdBy: true
      cast(mapl.annam as vdm_createdbyuserid preserving type)     as CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      mapl.aedat                                                  as LastChangeDate,
      @Semantics.user.lastChangedBy: true
      cast(mapl.aenam as vdm_lastchangedbyuserid preserving type) as LastChangedByUser,

      mapl.loekz                                                  as IsDeleted,
      mapl.loekz_inherited                                        as IsImplicitlyDeleted,

      
      mapl.lifnr                                                  as Supplier,
    
      mapl.kunr                                                   as Customer,
     
      mapl.vbeln                                                  as SalesOrder,
     
      mapl.posnr                                                  as SalesOrderItem,

      -- Associations
      _Product,
      _Plant,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BOOMaterialAssignment
} where mapl.plnty = 'N'

Learn More