P_Bomchanges

DDL: P_BOMCHANGES SQL: PBOMCHANGES Type: view COMPOSITE
23 Fields 2 Data Sources

P_Bomchanges is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_BomHeaderChanges, I_BomItemChanges) and exposes 23 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, EngineeringChangeDocument, BillOfMaterialVersion.

Data Sources (2)

SourceAliasJoin Type
I_BomHeaderChanges HeaderChanges from
I_BomItemChanges ItemChanges union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBOMCHANGES view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.lifecycle.contract.type #NONE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial I_BomHeaderChanges BillOfMaterial BOM
KEY BillOfMaterialCategory I_BomHeaderChanges BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant I_BomHeaderChanges BillOfMaterialVariant AlternativeBOM
KEY EngineeringChangeDocument I_BomHeaderChanges EngineeringChangeDocument Change Number
KEY BillOfMaterialVersion I_BomHeaderChanges BillOfMaterialVersion BOM Version
KEY Material I_BomHeaderChanges Material Vehicle Model
KEY Plant I_BomHeaderChanges Plant Valuation Area
KEY BillOfMaterialVariantUsage I_BomHeaderChanges BillOfMaterialVariantUsage Usage
ChangeNumberStatus I_BomHeaderChanges ChangeNumberStatus Status
ChangeNumberValidFromDate I_BomHeaderChanges ChangeNumberValidFromDate
ChangeNumberCreatedByUser I_BomHeaderChanges ChangeNumberCreatedByUser
BillOfMaterial BOM
KEY BillOfMaterialCategory I_BomItemChanges BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant I_BomItemChanges BillOfMaterialVariant AlternativeBOM
KEY EngineeringChangeDocument I_BomItemChanges EngineeringChangeDocument Change Number
KEY BillOfMaterialVersion I_BomItemChanges BillOfMaterialVersion BOM Version
KEY Material I_BomItemChanges Material Vehicle Model
KEY Plant I_BomItemChanges Plant Valuation Area
KEY BillOfMaterialVariantUsage I_BomItemChanges BillOfMaterialVariantUsage Usage
ChangeNumberStatus I_BomItemChanges ChangeNumberStatus Status
ChangeNumberValidFromDate I_BomItemChanges ChangeNumberValidFromDate
ChangeNumberCreatedByUser I_BomItemChanges ChangeNumberCreatedByUser
ChangeNumberCreationDate I_BomItemChanges 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 P_Bomchanges.
-- 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: PBOMCHANGES

CREATE VIEW P_Bomchanges AS
SELECT
  HeaderChanges.BillOfMaterial AS BillOfMaterial,
  HeaderChanges.BillOfMaterialCategory AS BillOfMaterialCategory,
  HeaderChanges.BillOfMaterialVariant AS BillOfMaterialVariant,
  HeaderChanges.EngineeringChangeDocument AS EngineeringChangeDocument,
  HeaderChanges.BillOfMaterialVersion AS BillOfMaterialVersion,
  HeaderChanges.Material AS Material,
  HeaderChanges.Plant AS Plant,
  HeaderChanges.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  HeaderChanges.ChangeNumberStatus AS ChangeNumberStatus,
  HeaderChanges.ChangeNumberValidFromDate AS ChangeNumberValidFromDate,
  HeaderChanges.ChangeNumberCreatedByUser AS ChangeNumberCreatedByUser,
  ItemChanges.ChangeNumberCreationDate AS ChangeNumberCreationDate
FROM I_BomHeaderChanges AS HeaderChanges
-- UNION ALL with additional select branch(es): I_BomItemChanges
;

Learn More