I_MaterialBOMHeaderSearch

DDL: I_MATERIALBOMHEADERSEARCH SQL: IMBOMHDRSRCH Type: view BASIC
16 Fields 2 Data Sources 5 Associations

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.

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 AlternativeBOM
KEY BillOfMaterial I_MaterialBOMLink BillOfMaterial BOM
KEY Plant I_MaterialBOMLink Plant Valuation Area
KEY Material I_MaterialBOMLink Material Vehicle Model
KEY BillOfMaterialVariantUsage I_MaterialBOMLink BillOfMaterialVariantUsage Usage
BillOfMaterialCategory I_MaterialBOMHeaderCurrentDate BillOfMaterialCategory BOM category
BillOfMaterialVersion I_MaterialBOMHeaderCurrentDate BillOfMaterialVersion BOM Version
EngineeringChangeDocument I_MaterialBOMHeaderCurrentDate EngineeringChangeDocument Change Number
BillOfMaterialVariantUsageDesc _BillOfMaterialVariantUsage BillOfMaterialVariantUsageDesc
MaterialName _MaterialText MaterialName Material Description
PlantName _PlantVH PlantName Plant Name
LastChangedByUser I_MaterialBOMLink LastChangedByUser User Name
CreatedByUser I_MaterialBOMLink CreatedByUser User Name
_BOMItems _BOMItems
_PlantVH _PlantVH
_MaterialText_BillOfMaterialExtension

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaterialBOMHeaderSearch.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMBOMHDRSRCH

CREATE VIEW I_MaterialBOMHeaderSearch AS
SELECT
  mast.BillOfMaterialVariant AS BillOfMaterialVariant,
  mast.BillOfMaterial AS BillOfMaterial,
  mast.Plant AS Plant,
  mast.Material AS Material,
  mast.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  bom_header.BillOfMaterialCategory AS BillOfMaterialCategory,
  bom_header.BillOfMaterialVersion AS BillOfMaterialVersion,
  bom_header.EngineeringChangeDocument AS EngineeringChangeDocument,
  _BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc AS BillOfMaterialVariantUsageDesc,
  _MaterialText.MaterialName AS MaterialName,
  _PlantVH.PlantName AS PlantName,
  mast.LastChangedByUser AS LastChangedByUser,
  mast.CreatedByUser AS CreatedByUser
FROM I_MaterialBOMLink AS mast
INNER JOIN I_MaterialBOMHeaderCurrentDate AS bom_header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialBOMValidItemsSearch AS _BOMItems ON BillOfMaterial = _BOMItems.BillOfMaterial AND BillOfMaterialVariant = _BOMItems.BillOfMaterialVariant  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON ( Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language )  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantVH ON ( Plant = _PlantVH.Plant )  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON BillOfMaterialVariantUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialTP AS _BillOfMaterialExtension ON BillOfMaterial = _BillOfMaterialExtension.BillOfMaterial AND BillOfMaterialCategory = _BillOfMaterialExtension.BillOfMaterialCategory AND BillOfMaterialVariant = _BillOfMaterialExtension.BillOfMaterialVariant AND BillOfMaterialVersion = _BillOfMaterialExtension.BillOfMaterialVersion  -- association [0..*]
;

Learn More