P_ChgRecdSnapshotObjRef

DDL: P_CHGRECDSNAPSHOTOBJREF SQL: PCRSNPOBJREF Type: view COMPOSITE Package: VDM_MPE_PLAN_ENG_SNPSHT
7 Fields 2 Data Sources

Snapshots Obj Ref assigned to Chg Record

P_ChgRecdSnapshotObjRef is a Composite CDS View that provides data about "Snapshots Obj Ref assigned to Chg Record" in SAP S/4HANA. It reads from 2 data sources (I_ChgRecdSnapshotObjRefBsc, I_EngSnpshtHdr) and exposes 7 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_MPE_PLAN_ENG_SNPSHT.

Data Sources (2)

SourceAliasJoin Type
I_ChgRecdSnapshotObjRefBsc ChgRecdSnapshotObjRef from
I_EngSnpshtHdr EngSnpshtHeader inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PCRSNPOBJREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Snapshots Obj Ref assigned to Chg Record view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdSnapshotObjRefBsc ChangeRecordReferenceUUID UUID
ChangeRecord I_ChgRecdSnapshotObjRefBsc ChangeRecord Char20
ChangeRecordUUID I_ChgRecdSnapshotObjRefBsc ChangeRecordUUID NodeID
ChgRecRefInternalKey1 I_ChgRecdSnapshotObjRefBsc ChgRecRefInternalKey1 Key
ChgRecRefInternalKey2 I_ChgRecdSnapshotObjRefBsc ChgRecRefInternalKey2 Key
ChangeRecordItemRelevance I_ChgRecdSnapshotObjRefBsc ChangeRecordItemRelevance Relevance
EngSnapshotType I_EngSnpshtHdr EngSnapshotType Snapshot Type

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 P_ChgRecdSnapshotObjRef.
-- 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.
-- SQL view name: PCRSNPOBJREF

CREATE VIEW P_ChgRecdSnapshotObjRef AS
SELECT
  ChgRecdSnapshotObjRef.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  ChgRecdSnapshotObjRef.ChangeRecord AS ChangeRecord,
  ChgRecdSnapshotObjRef.ChangeRecordUUID AS ChangeRecordUUID,
  ChgRecdSnapshotObjRef.ChgRecRefInternalKey1 AS ChgRecRefInternalKey1,
  ChgRecdSnapshotObjRef.ChgRecRefInternalKey2 AS ChgRecRefInternalKey2,
  ChgRecdSnapshotObjRef.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  EngSnpshtHeader.EngSnapshotType AS EngSnapshotType
FROM I_ChgRecdSnapshotObjRefBsc AS ChgRecdSnapshotObjRef
INNER JOIN I_EngSnpshtHdr AS EngSnpshtHeader ON /* join condition not captured in parsed metadata */
;

Learn More