I_ProjectBillOfMaterialChange

DDL: I_PROJECTBILLOFMATERIALCHANGE Type: view_entity COMPOSITE Package: CS_RAP
14 Fields 2 Associations

Project Bill of Material Changes

I_ProjectBillOfMaterialChange is a Composite CDS View that provides data about "Project Bill of Material Changes" in SAP S/4HANA. It has 2 associations to related views. Part of development package CS_RAP.

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChangeMasterStatusText _StatusText $projection.ChangeNumberStatus = _StatusText.ChangeNumberStatus and _StatusText.Language = $session.system_language
[0..*] I_BOMChangeHistory _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 #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

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 _StatusText ChangeNumberStatusText
ValidityStartDate ChangeNumberValidFromDate
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 I_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 I_ProjectBillOfMaterialChange AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  EngineeringChangeDocument,
  BillOfMaterialVersion,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  ChangeNumberStatus,
  _StatusText.ChangeNumberStatusText AS ChangeNumberStatusText,
  ChangeNumberValidFromDate AS ValidityStartDate,
  ChangeNumberCreatedByUser,
  ChangeNumberCreationDate
LEFT OUTER JOIN I_ChangeMasterStatusText AS _StatusText ON ChangeNumberStatus = _StatusText.ChangeNumberStatus AND _StatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BOMChangeHistory AS _BOMChangeHistory ON BillOfMaterial = _BOMChangeHistory.BillOfMaterial AND BillOfMaterialCategory = _BOMChangeHistory.BillOfMaterialCategory AND BillOfMaterialVariant = _BOMChangeHistory.BillOfMaterialVariant AND EngineeringChangeDocument = _BOMChangeHistory.EngineeringChangeDocument  -- association [0..*]
;

Learn More