I_ChangeRecordsAssignedToBOM

DDL: I_CHANGERECORDSASSIGNEDTOBOM Type: view_entity COMPOSITE Package: CS_RAP
19 Fields 5 Associations

Change Records Assigned to BOM

I_ChangeRecordsAssignedToBOM is a Composite CDS View that provides data about "Change Records Assigned to BOM" in SAP S/4HANA. It has 5 associations to related views. Part of development package CS_RAP.

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_ChgRecdRefEBOM _EBOMAssignment $projection.Plant = _EBOMAssignment.Plant and $projection.BillOfMaterial = _EBOMAssignment.BillOfMaterial and $projection.BillOfMaterialVariant = _EBOMAssignment.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _EBOMAssignment.ChgRecRefInternalKey4
[0..1] I_ChgRecdRefMBOM _MBOMAssignment $projection.Plant = _MBOMAssignment.Plant and $projection.BillOfMaterial = _MBOMAssignment.BillOfMaterial and $projection.BillOfMaterialVariant = _MBOMAssignment.BillOfMaterialVariant and $projection.BillOfMaterialVersion = _MBOMAssignment.ChgRecRefInternalKey4
[0..1] I_BOMVariantUsage _BOMUsage $projection.BillOfMaterialVariantUsage = _BOMUsage.BillOfMaterialVariantUsage
[0..*] I_ChangeRecordBsc _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
[0..1] I_ChgRecdRefBOM _BOMAssignment $projection.Plant = _BOMAssignment.Plant and $projection.Material = _BOMAssignment.Material and $projection.BillOfMaterial = _BOMAssignment.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMAssignment.BillOfMaterialVariant and $projection.BillOfMaterialVariantUsage = _BOMAssignment.BillOfMaterialVariantUsage

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Change Records Assigned to BOM view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BOM
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ChangeRecordUUIDendasChangeRecordUUID
ChangeRecordUUIDkeyBillOfMaterial
KEY BillOfMaterialCategory BillOfMaterialCategory BOM category
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY EngineeringChangeDocument EngineeringChangeDocument Change Number
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ChangeRecordUUID _BOMAssignment ChangeRecordUUID NodeID
_ChangeRecord _ChangeRecord

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_ChangeRecordsAssignedToBOM.
-- 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_ChangeRecordsAssignedToBOM AS
SELECT
  cast( BillOfMaterial as cs_stlnr preserving type ) AS BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  case when _BOMUsage.BOMIsProductionUsageRelevant = '+' then _MBOMAssignment.ChangeRecordUUID when _BOMUsage.BOMIsEngineeringUsageRelevant = '+' then _EBOMAssignment.ChangeRecordUUID end as ChangeRecordUUID AS ChangeRecordUUIDendasChangeRecordUUID,
  _BOMAssignment.ChangeRecordUUID AS ChangeRecordUUID
LEFT OUTER JOIN I_ChgRecdRefEBOM AS _EBOMAssignment ON Plant = _EBOMAssignment.Plant AND BillOfMaterial = _EBOMAssignment.BillOfMaterial AND BillOfMaterialVariant = _EBOMAssignment.BillOfMaterialVariant AND BillOfMaterialVersion = _EBOMAssignment.ChgRecRefInternalKey4  -- association [0..1]
LEFT OUTER JOIN I_ChgRecdRefMBOM AS _MBOMAssignment ON Plant = _MBOMAssignment.Plant AND BillOfMaterial = _MBOMAssignment.BillOfMaterial AND BillOfMaterialVariant = _MBOMAssignment.BillOfMaterialVariant AND BillOfMaterialVersion = _MBOMAssignment.ChgRecRefInternalKey4  -- association [0..1]
LEFT OUTER JOIN I_BOMVariantUsage AS _BOMUsage ON BillOfMaterialVariantUsage = _BOMUsage.BillOfMaterialVariantUsage  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordBsc AS _ChangeRecord ON ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID  -- association [0..*]
LEFT OUTER JOIN I_ChgRecdRefBOM AS _BOMAssignment ON Plant = _BOMAssignment.Plant AND Material = _BOMAssignment.Material AND BillOfMaterial = _BOMAssignment.BillOfMaterial AND BillOfMaterialVariant = _BOMAssignment.BillOfMaterialVariant AND BillOfMaterialVariantUsage = _BOMAssignment.BillOfMaterialVariantUsage  -- association [0..1]
;

Learn More