I_UnitizedMaterialVersBOM

DDL: I_UNITIZEDMATERIALVERSBOM SQL: IUNTZDMATVERSBOM Type: view COMPOSITE Package: MPE_CM_PE
10 Fields 2 Data Sources

Unitized Versioned Material BOM

I_UnitizedMaterialVersBOM is a Composite CDS View that provides data about "Unitized Versioned Material BOM" in SAP S/4HANA. It reads from 2 data sources (I_MaterialBOM, I_UnitizedMaterial) and exposes 10 fields with key fields BillOfMaterialVariantUsage, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialVersion. Part of development package MPE_CM_PE.

Data Sources (2)

SourceAliasJoin Type
I_MaterialBOM MaterialBOM from
I_UnitizedMaterial UnitizedMaterial inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUNTZDMATVERSBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Unitized Versioned Material BOM view
VDM.viewType #COMPOSITE view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
KEY BillOfMaterial I_MaterialBOM BillOfMaterial BOM
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
Material I_MaterialBOM Material Vehicle Model
MaterialType I_UnitizedMaterial MaterialType Material Type
EffectivityType I_UnitizedMaterial EffectivityType
Plant I_MaterialBOM Plant Valuation Area

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_UnitizedMaterialVersBOM.
-- 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: IUNTZDMATVERSBOM

CREATE VIEW I_UnitizedMaterialVersBOM AS
SELECT
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.Material AS Material,
  UnitizedMaterial.MaterialType AS MaterialType,
  UnitizedMaterial.EffectivityType AS EffectivityType,
  MaterialBOM.Plant AS Plant
FROM I_MaterialBOM AS MaterialBOM
INNER JOIN I_UnitizedMaterial AS UnitizedMaterial ON /* join condition not captured in parsed metadata */
;

Learn More