C_BillOfMaterialChanges

DDL: C_BILLOFMATERIALCHANGES Type: view_entity CONSUMPTION Package: CS_RAP
14 Fields 1 Data Sources 1 Associations 4 OData Services

Bill Of Material Changes

C_BillOfMaterialChanges is a Consumption CDS View that provides data about "Bill Of Material Changes" in SAP S/4HANA. It reads from 1 data source (I_BomChanges) and exposes 14 fields with key fields Material, Plant, BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant. It has 1 association to related views. It is exposed through 4 OData services (ASQL_F1813A, UI_BILLOFFMATERIAL_1, UI_BILLOFMATERIAL_MAINTAIN, ...). Part of development package CS_RAP.

Data Sources (1)

SourceAliasJoin Type
I_BomChanges I_BomChanges from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_BillOfMaterialChangeHistory _BOMChangeHistory $projection.BillOfMaterial = _BOMChangeHistory.BillOfMaterial and $projection.BillOfMaterialCategory = _BOMChangeHistory.BillOfMaterialCategory and $projection.BillOfMaterialVariant = _BOMChangeHistory.BillOfMaterialVariant and $projection.EngineeringChangeDocument = _BOMChangeHistory.EngineeringChangeDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Bill Of Material Changes view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (4)

ServiceBindingVersionContractRelease
ASQL_F1813A ASQL_F1813A C2 NOT_RELEASED
UI_BILLOFFMATERIAL_1 UI_BILLOFMATERIAL_V4 V4 C1 NOT_RELEASED
UI_BILLOFMATERIAL_MAINTAIN UI_BILLOFMATERIAL_MAINTAIN V4 C1 NOT_TO_BE_RELEASED_STABLE
UI_ORDERBILLOFFMATERIAL UI_ORDERBILLOFMATERIAL_V4 V4 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
ChangeNumberStatus ChangeNumberStatus Status
ChangeNumberStatusText ChangeNumberStatusText
ChangeNumberCreationDate ChangeNumberCreationDate
ChangeNumberCreatedByUser ChangeNumberCreatedByUser
ValidityStartDate ValidityStartDate Validity Start Date
_BOMChangeHistory _BOMChangeHistory

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 C_BillOfMaterialChanges.
-- 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.

CREATE VIEW C_BillOfMaterialChanges AS
SELECT
  Material,
  Plant,
  cast( BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVariantUsage,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  ChangeNumberStatus,
  ChangeNumberStatusText,
  ChangeNumberCreationDate,
  ChangeNumberCreatedByUser,
  ValidityStartDate
FROM I_BomChanges
LEFT OUTER JOIN C_BillOfMaterialChangeHistory AS _BOMChangeHistory ON BillOfMaterial = _BOMChangeHistory.BillOfMaterial AND BillOfMaterialCategory = _BOMChangeHistory.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMChangeHistory.BillOfMaterialVariant AND EngineeringChangeDocument = _BOMChangeHistory.EngineeringChangeDocument  -- association [0..*]
;

Learn More