A_ChangeRecordReferenceMat

DDL: A_CHANGERECORDREFERENCEMAT Type: view_entity COMPOSITE Package: VDM_PLMB_CR_API
15 Fields 1 Data Sources 2 Associations

Material Assignments to Change Records

A_ChangeRecordReferenceMat is a Composite CDS View that provides data about "Material Assignments to Change Records" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordReferenceMatTP_2) and exposes 15 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views. Part of development package VDM_PLMB_CR_API.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordReferenceMatTP_2 I_ChangeRecordReferenceMatTP_2 from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordProduct _ChangeRecordProduct $projection.Material = _ChangeRecordProduct.Product
[0..1] E_ChgRecdRefMatBsc _MatExtension $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Material Assignments to Change Records view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID UUID
ChangeRecord ChangeRecord Char20
ChangeRecordUUID ChangeRecordUUID NodeID
ChangeRecordType ChangeRecordType Record Type
ChangeRecordReferenceType ChangeRecordReferenceType Object Type
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
Material Material Vehicle Model
MaterialType _ChangeRecordProduct ProductType Product Type Group
BaseUnit _ChangeRecordProduct BaseUnit Unit of Measure
MaterialStatus _ChangeRecordProduct CrossPlantStatus X-Plant Status
ChangeRecordItemRelevance ChangeRecordItemRelevance Relevance
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
_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 A_ChangeRecordReferenceMat.
-- 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 A_ChangeRecordReferenceMat AS
SELECT
  ChangeRecordReferenceUUID,
  ChangeRecord,
  ChangeRecordUUID,
  ChangeRecordType,
  ChangeRecordReferenceType,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  Material,
  _ChangeRecordProduct.ProductType AS MaterialType,
  _ChangeRecordProduct.BaseUnit AS BaseUnit,
  _ChangeRecordProduct.CrossPlantStatus AS MaterialStatus,
  ChangeRecordItemRelevance,
  ChangeRecordItemProcgStatus
FROM I_ChangeRecordReferenceMatTP_2
LEFT OUTER JOIN I_ChangeRecordProduct AS _ChangeRecordProduct ON Material = _ChangeRecordProduct.Product  -- association [1..1]
LEFT OUTER JOIN E_ChgRecdRefMatBsc AS _MatExtension ON ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID  -- association [0..1]
;

Learn More