I_ChgRecdRefEngSnpshtTP

DDL: I_CHGRECDREFENGSNPSHTTP SQL: ICRREFENGSNPTP Type: view TRANSACTIONAL Package: VDM_PLMB_CR_O
31 Fields 2 Data Sources

Change Record Ref Object Eng Snapshot

I_ChgRecdRefEngSnpshtTP is a Transactional CDS View that provides data about "Change Record Ref Object Eng Snapshot" in SAP S/4HANA. It reads from 2 data sources (I_EngSnpshtHdr, I_ChgRecdRefEngSnpshtBsc) and exposes 31 fields with key field ChangeRecordReferenceUUID. Part of development package VDM_PLMB_CR_O.

Data Sources (2)

SourceAliasJoin Type
I_EngSnpshtHdr EngSnpHdr inner
I_ChgRecdRefEngSnpshtBsc reference_eng_snpsht from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFENGSNPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence PLMCRREFESNP_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Change Record Ref Object Eng Snapshot view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefEngSnpshtBsc ChangeRecordReferenceUUID UUID
EngSnapshotID I_EngSnpshtHdr EngSnapshotID Snapshot ID
EngSnpshtRevisionNumber I_EngSnpshtHdr EngSnpshtRevisionNumber Snapshot Revision
EngSnapshotType I_EngSnpshtHdr EngSnapshotType Snapshot Type
Material I_EngSnpshtHdr Material Vehicle Model
Plant I_EngSnpshtHdr Plant Valuation Area
BillOfMaterialVariantUsage I_EngSnpshtHdr BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_EngSnpshtHdr BillOfMaterialVariant AlternativeBOM
EngSnapshotUUID I_EngSnpshtHdr EngSnapshotUUID Waste Partner UUID
ChangeRecordUUID I_ChgRecdRefEngSnpshtBsc ChangeRecordUUID NodeID
ChangeRecordReferenceType I_ChgRecdRefEngSnpshtBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefEngSnpshtBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRefEngSnpshtBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefEngSnpshtBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefEngSnpshtBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefEngSnpshtBsc IsMainReference Main Reference
CreatedByUser I_ChgRecdRefEngSnpshtBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefEngSnpshtBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefEngSnpshtBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefEngSnpshtBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefEngSnpshtBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefEngSnpshtBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRefEngSnpshtBsc ChangeRecordItemProcgStatus Processing Status
ChgRecdItmTgtSts I_ChgRecdRefEngSnpshtBsc ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr I_ChgRecdRefEngSnpshtBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
ChgRecdCurrentItemProcgStatus I_ChgRecdRefEngSnpshtBsc ChgRecdCurrentItemProcgStatus Processing Status
ChgRecdReasonForChange I_ChgRecdRefEngSnpshtBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRefEngSnpshtBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRefEngSnpshtBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRefEngSnpshtBsc ChgRecdNmbrChgSts Status
ChangeNumber I_ChgRecdRefEngSnpshtBsc ChangeNumber Change Number

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_ChgRecdRefEngSnpshtTP.
-- 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: ICRREFENGSNPTP

CREATE VIEW I_ChgRecdRefEngSnpshtTP AS
SELECT
  reference_eng_snpsht.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  EngSnpHdr.EngSnapshotID AS EngSnapshotID,
  EngSnpHdr.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  EngSnpHdr.EngSnapshotType AS EngSnapshotType,
  EngSnpHdr.Material AS Material,
  EngSnpHdr.Plant AS Plant,
  EngSnpHdr.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  EngSnpHdr.BillOfMaterialVariant AS BillOfMaterialVariant,
  EngSnpHdr.EngSnapshotUUID AS EngSnapshotUUID,
  reference_eng_snpsht.ChangeRecordUUID AS ChangeRecordUUID,
  reference_eng_snpsht.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_eng_snpsht.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_eng_snpsht.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_eng_snpsht.ChangeRecordReference AS ChangeRecordReference,
  reference_eng_snpsht.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_eng_snpsht.IsMainReference AS IsMainReference,
  reference_eng_snpsht.CreatedByUser AS CreatedByUser,
  reference_eng_snpsht.CreationDateTime AS CreationDateTime,
  reference_eng_snpsht.LastChangedByUser AS LastChangedByUser,
  reference_eng_snpsht.LastChangeDateTime AS LastChangeDateTime,
  reference_eng_snpsht.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_eng_snpsht.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_eng_snpsht.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_eng_snpsht.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_eng_snpsht.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  reference_eng_snpsht.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  reference_eng_snpsht.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_eng_snpsht.ExpdCompltnDte AS ExpdCompltnDte,
  reference_eng_snpsht.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_eng_snpsht.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_eng_snpsht.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefEngSnpshtBsc AS reference_eng_snpsht
INNER JOIN I_EngSnpshtHdr AS EngSnpHdr ON /* join condition not captured in parsed metadata */
;

Learn More