P_BOMItemChanges

DDL: P_BOMITEMCHANGES SQL: PBOMITEMCHANGES Type: view BASIC
34 Fields 8 Data Sources

P_BOMItemChanges is a Basic CDS View in SAP S/4HANA. It reads from 8 data sources and exposes 34 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, EngineeringChangeDocument, BillOfMaterialVersion.

Data Sources (8)

SourceAliasJoin Type
I_ChangeMaster aenr inner
I_ChangeMaster aenr inner
I_ChangeMaster aenr inner
stko_draft_v2 HeaderDraftChanges inner
stpo ItemChanges inner
stpo ItemChanges inner
I_SalesOrderBOMLink kdst inner
I_MaterialBOMLink mast inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PBOMITEMCHANGES view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial stpo stlnr BOM
KEY BillOfMaterialCategory stpo stlty BOM category
KEY BillOfMaterialVariant ItemHistory stlal Alternative
KEY EngineeringChangeDocument ItemHistory aennr Change Number
KEY BillOfMaterialVersion ItemHistory 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 stpo stlty BOM category
KEY BillOfMaterialVariant ItemHistory stlal Alternative
KEY EngineeringChangeDocument ItemHistory aennr Change Number
KEY BillOfMaterialVersion ItemHistory 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 ItemDraftChanges billofmaterialcategory BOM category
KEY BillOfMaterialVariant ItemDraftChanges billofmaterialvariantforedit Alternative
KEY EngineeringChangeDocument ItemDraftChanges engineeringchangedocument Change Number
KEY BillOfMaterialVersion ItemDraftChanges billofmaterialversionforedit BOM Version
KEY Material stko_draft_v2 materialforedit Product
KEY Plant stko_draft_v2 plantforedit Plant ID
KEY BillOfMaterialVariantUsage stko_draft_v2 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 P_BOMItemChanges.
-- 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: PBOMITEMCHANGES

CREATE VIEW P_BOMItemChanges AS
SELECT
  ItemChanges.stlnr AS BillOfMaterial,
  ItemChanges.stlty AS BillOfMaterialCategory,
  ItemHistory.stlal AS BillOfMaterialVariant,
  ItemHistory.aennr AS EngineeringChangeDocument,
  ItemHistory.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_MaterialBOMLink AS mast ON /* join condition not captured in parsed metadata */
INNER JOIN stpo AS ItemChanges ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeMaster AS aenr ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesOrderBOMLink AS kdst ON /* join condition not captured in parsed metadata */
INNER JOIN stko_draft_v2 AS HeaderDraftChanges ON /* join condition not captured in parsed metadata */
;

Learn More