C_ProjectBillOfMaterialChange

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

Project Bill of Material Changes

C_ProjectBillOfMaterialChange is a Consumption CDS View that provides data about "Project Bill of Material Changes" in SAP S/4HANA. It reads from 1 data source (I_ProjectBillOfMaterialChange) and exposes 14 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, EngineeringChangeDocument, BillOfMaterialVersion. It has 1 association to related views. It is exposed through 1 OData service (UI_WBSBILLOFMATERIAL_MAINTAIN). Part of development package CS_RAP.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBillOfMaterialChange I_ProjectBillOfMaterialChange 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 Project 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 (1)

ServiceBindingVersionContractRelease
UI_WBSBILLOFMATERIAL_MAINTAIN UI_WBSBILLOFMATERIAL_MAINTAIN V4 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ChangeNumberStatus ChangeNumberStatus Status
ChangeNumberStatusText ChangeNumberStatusText
ValidityStartDate ValidityStartDate Validity Start Date
ChangeNumberCreatedByUser ChangeNumberCreatedByUser
ChangeNumberCreationDate ChangeNumberCreationDate
_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_ProjectBillOfMaterialChange.
-- 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_ProjectBillOfMaterialChange AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  EngineeringChangeDocument,
  BillOfMaterialVersion,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  ChangeNumberStatus,
  ChangeNumberStatusText,
  ValidityStartDate,
  ChangeNumberCreatedByUser,
  ChangeNumberCreationDate
FROM I_ProjectBillOfMaterialChange
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