I_ChangeRecordMaterialBOM

DDL: I_CHANGERECORDMATERIALBOM SQL: ICHGRECMATBOM Type: view COMPOSITE
6 Fields 1 Data Sources

Change Record Material BOM

I_ChangeRecordMaterialBOM is a Composite CDS View that provides data about "Change Record Material BOM" in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 6 fields with key fields Material, Plant, BillOfMaterialVariantUsage, BillOfMaterialVariant, BillOfMaterialVersion.

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM MaterialBOM from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECMATBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Record Material BOM view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Material I_MaterialBOM Material Vehicle Model
KEY Plant I_MaterialBOM Plant Valuation Area
KEY BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
HeaderValidityStartDate

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_ChangeRecordMaterialBOM.
-- 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: ICHGRECMATBOM

CREATE VIEW I_ChangeRecordMaterialBOM AS
SELECT
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion,
  max(MaterialBOM.HeaderValidityStartDate) AS HeaderValidityStartDate
FROM I_MaterialBOM AS MaterialBOM
;

Learn More