I_BomHeaderChanges

DDL: I_BOMHEADERCHANGES SQL: IBOMHDRCHANGES Type: view BASIC
34 Fields 5 Data Sources

BOM Header Changes

I_BomHeaderChanges is a Basic CDS View that provides data about "BOM Header Changes" in SAP S/4HANA. It reads from 5 data sources (I_ChangeMaster, I_ChangeMaster, I_ChangeMaster, I_SalesOrderBOMLink, I_MaterialBOMLink) and exposes 34 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, EngineeringChangeDocument, BillOfMaterialVersion.

Data Sources (5)

SourceAliasJoin Type
I_ChangeMaster aenr inner
I_ChangeMaster aenr inner
I_ChangeMaster aenr inner
I_SalesOrderBOMLink kdst inner
I_MaterialBOMLink mast inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBOMHDRCHANGES view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label BOM Header Changes view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial HeaderChanges stlnr BOM
KEY BillOfMaterialCategory HeaderChanges stlty BOM category
KEY BillOfMaterialVariant HeaderChanges stlal Alternative
KEY EngineeringChangeDocument HeaderChanges aennr Change Number
KEY BillOfMaterialVersion HeaderChanges bom_versn BOM Version
KEY Material I_MaterialBOMLink Material Product
KEY Plant I_MaterialBOMLink Plant Plant ID
KEY BillOfMaterialVariantUsage I_MaterialBOMLink BillOfMaterialVariantUsage Usage
ChangeNumberStatus I_ChangeMaster ChangeNumberStatus Status
ChangeNumberValidFromDate I_ChangeMaster ChangeNumberValidFromDate Valid-from date
ChangeNumberCreatedByUser I_ChangeMaster ChangeNumberCreatedByUser
stlnrasBillOfMaterial
KEY BillOfMaterialCategory HeaderChanges stlty BOM category
KEY BillOfMaterialVariant HeaderChanges stlal Alternative
KEY EngineeringChangeDocument HeaderChanges aennr Change Number
KEY BillOfMaterialVersion HeaderChanges bom_versn BOM Version
KEY Material I_SalesOrderBOMLink Material Product
KEY Plant I_SalesOrderBOMLink Plant Plant ID
KEY BillOfMaterialVariantUsage I_SalesOrderBOMLink BillOfMaterialVariantUsage Usage
ChangeNumberStatus I_ChangeMaster ChangeNumberStatus Status
ChangeNumberValidFromDate I_ChangeMaster ChangeNumberValidFromDate Valid-from date
ChangeNumberCreatedByUser I_ChangeMaster ChangeNumberCreatedByUser
billofmaterialasBillOfMaterial
KEY BillOfMaterialCategory HeaderDraftChanges billofmaterialcategory BOM category
KEY BillOfMaterialVariant HeaderDraftChanges billofmaterialvariantforedit Alternative
KEY EngineeringChangeDocument HeaderDraftChanges engineeringchangedocforedit Change Number
KEY BillOfMaterialVersion HeaderDraftChanges billofmaterialversionforedit BOM Version
KEY Material HeaderDraftChanges materialforedit Product
KEY Plant HeaderDraftChanges plantforedit Plant ID
KEY BillOfMaterialVariantUsage HeaderDraftChanges billofmaterialvariantusage Usage
ChangeNumberStatus I_ChangeMaster ChangeNumberStatus Status
ChangeNumberValidFromDate I_ChangeMaster ChangeNumberValidFromDate Valid-from date
ChangeNumberCreatedByUser I_ChangeMaster ChangeNumberCreatedByUser
ChangeNumberCreationDate I_ChangeMaster ChangeNumberCreationDate

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_BomHeaderChanges.
-- 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: IBOMHDRCHANGES

CREATE VIEW I_BomHeaderChanges AS
SELECT
  HeaderChanges.stlnr AS BillOfMaterial,
  HeaderChanges.stlty AS BillOfMaterialCategory,
  HeaderChanges.stlal AS BillOfMaterialVariant,
  HeaderChanges.aennr AS EngineeringChangeDocument,
  HeaderChanges.bom_versn AS BillOfMaterialVersion,
  mast.Material AS Material,
  mast.Plant AS Plant,
  mast.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  aenr.ChangeNumberStatus AS ChangeNumberStatus,
  aenr.ChangeNumberValidFromDate AS ChangeNumberValidFromDate,
  aenr.ChangeNumberCreatedByUser AS ChangeNumberCreatedByUser,
  aenr.ChangeNumberCreationDate AS stlnrasBillOfMaterial,
  aenr.ChangeNumberCreationDate AS billofmaterialasBillOfMaterial,
  aenr.ChangeNumberCreationDate AS ChangeNumberCreationDate
INNER JOIN I_ChangeMaster AS aenr ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialBOMLink AS mast ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesOrderBOMLink AS kdst ON /* join condition not captured in parsed metadata */
;

Learn More