I_ChgRecdAssgdToBOMWthStsDesc

DDL: I_CHGRECDASSGDTOBOMWTHSTSDESC Type: view_entity COMPOSITE Package: CS_RAP
15 Fields 1 Data Sources 2 Associations

Change Records Assigned to BOM with CR Status Desc

I_ChgRecdAssgdToBOMWthStsDesc is a Composite CDS View that provides data about "Change Records Assigned to BOM with CR Status Desc" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordsAssignedToBOM) and exposes 15 fields with key fields BillOfMaterial, BillOfMaterialCategory, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument. It has 2 associations to related views. Part of development package CS_RAP.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordsAssignedToBOM I_ChangeRecordsAssignedToBOM from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChgRecordUserStatus _ChangeRecordUserStatus $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
[0..1] I_ChangeRecordTypeText _ChangeRecordTypeText $projection.changerecordtype = _ChangeRecordTypeText.ChangeRecordType and _ChangeRecordTypeText.Language = $session.system_language

Annotations (7)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial 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
KEY ChangeRecord _ChangeRecord ChangeRecord Char20
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
ChangeRecordUUID ChangeRecordUUID NodeID
ChangeRecordType _ChangeRecord ChangeRecordType Record Type
ChangeRecordStatus _ChangeRecord ChangeRecordStatus
ChgRecordDescriptionText _ChangeRecord ChgRecordDescriptionText
_ChangeRecordUserStatus _ChangeRecordUserStatus
_ChangeRecordTypeText _ChangeRecordTypeText

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_ChgRecdAssgdToBOMWthStsDesc.
-- 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_ChgRecdAssgdToBOMWthStsDesc AS
SELECT
  BillOfMaterial,
  BillOfMaterialCategory,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  EngineeringChangeDocument,
  Material,
  Plant,
  _ChangeRecord.ChangeRecord AS ChangeRecord,
  BillOfMaterialVariantUsage,
  ChangeRecordUUID,
  _ChangeRecord.ChangeRecordType AS ChangeRecordType,
  _ChangeRecord.ChangeRecordStatus AS ChangeRecordStatus,
  _ChangeRecord.ChgRecordDescriptionText AS ChgRecordDescriptionText
FROM I_ChangeRecordsAssignedToBOM
LEFT OUTER JOIN I_ChgRecordUserStatus AS _ChangeRecordUserStatus ON ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus  -- association [0..1]
LEFT OUTER JOIN I_ChangeRecordTypeText AS _ChangeRecordTypeText ON changerecordtype = _ChangeRecordTypeText.ChangeRecordType AND _ChangeRecordTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More