I_MaterialBOMHeaderSearch

DDL: I_MATERIALBOMHEADERSEARCH SQL: IMBOMHDRSRCH Type: view BASIC

BOM header view for CDS based search model.

I_MaterialBOMHeaderSearch is a Basic CDS View that provides data about "BOM header view for CDS based search model." in SAP S/4HANA. It reads from 2 data sources (I_MaterialBOMHeaderCurrentDate, I_MaterialBOMLink) and exposes 16 fields with key fields BillOfMaterialVariant, BillOfMaterial, Plant, Material, BillOfMaterialVariantUsage. It has 5 associations to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialBOMHeaderCurrentDate bom_header inner
I_MaterialBOMLink mast from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_MaterialBOMValidItemsSearch _BOMItems $projection.BillOfMaterial = _BOMItems.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMItems.BillOfMaterialVariant
[0..1] I_MaterialText _MaterialText ( $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language )
[0..1] I_PlantStdVH _PlantVH ( $projection.Plant = _PlantVH.Plant )
[0..1] I_BillOfMaterialUsage _BillOfMaterialVariantUsage $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language ----Extension
[0..*] E_BillOfMaterialTP _BillOfMaterialExtension $projection.BillOfMaterial = _BillOfMaterialExtension.BillOfMaterial and $projection.BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BillOfMaterialExtension.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _BillOfMaterialExtension.BillOfMaterialVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMBOMHDRSRCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label BOM header view for CDS based search model. view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialVariant I_MaterialBOMLink BillOfMaterialVariant
KEY BillOfMaterial I_MaterialBOMLink BillOfMaterial
KEY Plant I_MaterialBOMLink Plant
KEY Material I_MaterialBOMLink Material
KEY BillOfMaterialVariantUsage I_MaterialBOMLink BillOfMaterialVariantUsage
BillOfMaterialCategory I_MaterialBOMHeaderCurrentDate BillOfMaterialCategory
BillOfMaterialVersion I_MaterialBOMHeaderCurrentDate BillOfMaterialVersion
EngineeringChangeDocument I_MaterialBOMHeaderCurrentDate EngineeringChangeDocument
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
MaterialName _MaterialText MaterialName
PlantName _PlantVH PlantName
LastChangedByUser I_MaterialBOMLink LastChangedByUser
CreatedByUser I_MaterialBOMLink CreatedByUser
_BOMItems _BOMItems
_PlantVH _PlantVH
_MaterialText_BillOfMaterialExtension 
@AbapCatalog.sqlViewName: 'IMBOMHDRSRCH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'BOM header view for CDS based search model.'
define view I_MaterialBOMHeaderSearch
  as select from I_MaterialBOMLink              as mast
    inner join   I_MaterialBOMHeaderCurrentDate as bom_header on  mast.BillOfMaterial        = bom_header.BillOfMaterial
                                                              and mast.BillOfMaterialVariant = bom_header.BillOfMaterialVariant
  association [0..*] to I_MaterialBOMValidItemsSearch as _BOMItems                   on  $projection.BillOfMaterial        = _BOMItems.BillOfMaterial
                                                                                     and $projection.BillOfMaterialVariant = _BOMItems.BillOfMaterialVariant



  association [0..1] to I_MaterialText                as _MaterialText               on  (
                    $projection.Material       = _MaterialText.Material
                    and _MaterialText.Language = $session.system_language
                  )
  association [0..1] to I_PlantStdVH                  as _PlantVH                    on  (
                         $projection.Plant = _PlantVH.Plant

                       )
  association [0..1] to I_BillOfMaterialUsage         as _BillOfMaterialVariantUsage on  $projection.BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage
                                                                                     and _BillOfMaterialVariantUsage.Language   = $session.system_language

  ----Extension Association
  association [0..*] to E_BillOfMaterialTP            as _BillOfMaterialExtension    on  $projection.BillOfMaterial         = _BillOfMaterialExtension.BillOfMaterial
                                                                                     and $projection.BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory
                                                                                     and $projection.BillOfMaterialVariant  = _BillOfMaterialExtension.BillOfMaterialVariant
                                                                                     and $projection.BillOfMaterialVersion  = _BillOfMaterialExtension.BillOfMaterialVersion

{
  key  mast.BillOfMaterialVariant,
  key  mast.BillOfMaterial,
       @ObjectModel.text.association: '_PlantVH'
  key  mast.Plant,
       @ObjectModel.text.association: '_MaterialText'
  key  mast.Material,
  key  mast.BillOfMaterialVariantUsage,
       bom_header.BillOfMaterialCategory,
       bom_header.BillOfMaterialVersion,
       bom_header.EngineeringChangeDocument,
       _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc,
       _MaterialText.MaterialName,
       _PlantVH.PlantName,
       mast.LastChangedByUser,
       mast.CreatedByUser,
       _BOMItems,
       _PlantVH,
       _MaterialText
       --       _BillOfMaterialExtension
}

Learn More