P_ProjMatBOMAssembly

DDL: P_PROJMATBOMASSEMBLY SQL: PMATBOMASSEMBLY Type: view BASIC

P_ProjMatBOMAssembly is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (I_SalesOrderBOMLink, I_Mast, I_Prst) and exposes 13 fields. It has 1 association to related views.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_SalesOrderBOMLink _kdst union_all
I_Mast _Mast from
I_Prst _prst union_all

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Assembly = _MaterialText.Material

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PMATBOMASSEMBLY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterial BillOfMaterial
BillOfMaterialVariant BillOfMaterialVariant
Assembly Material
MaterialBillOfMaterialCategory
BillOfMaterial BillOfMaterial
BillOfMaterialVariant BillOfMaterialVariant
Assembly Material
MaterialBillOfMaterialCategory
BillOfMaterial BillOfMaterial
BillOfMaterialVariant BillOfMaterialVariant
Assembly Material
AssemblyName 
@AbapCatalog.sqlViewName: 'PMATBOMASSEMBLY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
define view P_ProjMatBOMAssembly
  as select from I_Mast as _Mast
  /*
    inner join   resb on  _Mast.BillOfMaterialCategory = resb.stlty
                      and _Mast.BillOfMaterial         = resb.stlnr
                      and _Mast.BillOfMaterialVariant  = resb.stlal
                      */
  association [0..*] to I_MaterialText as _MaterialText on $projection.Assembly = _MaterialText.Material
{
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  Material                                                        as Assembly,
  _MaterialText[Language = $session.system_language].MaterialName as AssemblyName
}
union all select from I_SalesOrderBOMLink as _kdst
/*
  inner join          rsadd on  _kdst.BillOfMaterial         = rsadd.bstln
                            and _kdst.BillOfMaterialCategory = rsadd.bstlt
                            */
association [0..*] to I_MaterialText as _MaterialText on $projection.Assembly = _MaterialText.Material
{
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  Material                                                        as Assembly,
  _MaterialText[Language = $session.system_language].MaterialName as AssemblyName
}

union all select from I_Prst as _prst
/*
  inner join          rsadd on _prst.BillOfMaterial = rsadd.bstln
  */
association [0..*] to I_MaterialText as _MaterialText on $projection.Assembly = _MaterialText.Material
{
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  Material                                                        as Assembly,
  _MaterialText[Language = $session.system_language].MaterialName as AssemblyName
}

Learn More