I_ChgRecdRefMfgSnpshtTP

DDL: I_CHGRECDREFMFGSNPSHTTP SQL: ICRREFMFGSNPTP Type: view TRANSACTIONAL
32 Fields 2 Data Sources 1 Associations

Change Record Ref Obj Mfg Snapshot - TP

I_ChgRecdRefMfgSnpshtTP is a Transactional CDS View that provides data about "Change Record Ref Obj Mfg Snapshot - TP" in SAP S/4HANA. It reads from 2 data sources (I_EngSnpshtHdr, I_ChgRecdRefMfgSnpshtBsc) and exposes 32 fields with key field ChangeRecordReferenceUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_EngSnpshtHdr EngSnpHdr inner
I_ChgRecdRefMfgSnpshtBsc reference_mfg_snpsht from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFMFGSNPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFMSNP_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Change Record Ref Obj Mfg Snapshot - TP view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefMfgSnpshtBsc 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_ChgRecdRefMfgSnpshtBsc ChangeRecordUUID NodeID
ChangeRecordReferenceType I_ChgRecdRefMfgSnpshtBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefMfgSnpshtBsc ChangeRecordReferenceSubtype Subtype
ChangeRecordRefObjectUUID I_ChgRecdRefMfgSnpshtBsc ChangeRecordRefObjectUUID GUID-Key
ChangeRecordReference I_ChgRecdRefMfgSnpshtBsc ChangeRecordReference Ref. Object ID
ParentChangeRecordRefUUID I_ChgRecdRefMfgSnpshtBsc ParentChangeRecordRefUUID Node ID
IsMainReference I_ChgRecdRefMfgSnpshtBsc IsMainReference Main Reference
CreatedByUser I_ChgRecdRefMfgSnpshtBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefMfgSnpshtBsc CreationDateTime Timestamp
LastChangedByUser I_ChgRecdRefMfgSnpshtBsc LastChangedByUser User Name
LastChangeDateTime I_ChgRecdRefMfgSnpshtBsc LastChangeDateTime Timestamp
ChangeRecordItemRelevance I_ChgRecdRefMfgSnpshtBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefMfgSnpshtBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRefMfgSnpshtBsc ChangeRecordItemProcgStatus Processing Status
ChgRecdItmTgtSts I_ChgRecdRefMfgSnpshtBsc ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdItmDSgntr I_ChgRecdRefMfgSnpshtBsc ChgRecdItmDSgntr Itm. Dgt. Sign.
ChgRecdCurrentItemProcgStatus I_ChgRecdRefMfgSnpshtBsc ChgRecdCurrentItemProcgStatus Processing Status
ChgRecdReasonForChange I_ChgRecdRefMfgSnpshtBsc ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte I_ChgRecdRefMfgSnpshtBsc ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText I_ChgRecdRefMfgSnpshtBsc ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts I_ChgRecdRefMfgSnpshtBsc ChgRecdNmbrChgSts Status
ChangeNumber I_ChgRecdRefMfgSnpshtBsc ChangeNumber Change Number
_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_ChgRecdRefMfgSnpshtTP.
-- 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: ICRREFMFGSNPTP

CREATE VIEW I_ChgRecdRefMfgSnpshtTP AS
SELECT
  reference_mfg_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_mfg_snpsht.ChangeRecordUUID AS ChangeRecordUUID,
  reference_mfg_snpsht.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_mfg_snpsht.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_mfg_snpsht.ChangeRecordRefObjectUUID AS ChangeRecordRefObjectUUID,
  reference_mfg_snpsht.ChangeRecordReference AS ChangeRecordReference,
  reference_mfg_snpsht.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_mfg_snpsht.IsMainReference AS IsMainReference,
  reference_mfg_snpsht.CreatedByUser AS CreatedByUser,
  reference_mfg_snpsht.CreationDateTime AS CreationDateTime,
  reference_mfg_snpsht.LastChangedByUser AS LastChangedByUser,
  reference_mfg_snpsht.LastChangeDateTime AS LastChangeDateTime,
  reference_mfg_snpsht.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_mfg_snpsht.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_mfg_snpsht.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus,
  reference_mfg_snpsht.ChgRecdItmTgtSts AS ChgRecdItmTgtSts,
  reference_mfg_snpsht.ChgRecdItmDSgntr AS ChgRecdItmDSgntr,
  reference_mfg_snpsht.ChgRecdCurrentItemProcgStatus AS ChgRecdCurrentItemProcgStatus,
  reference_mfg_snpsht.ChgRecdReasonForChange AS ChgRecdReasonForChange,
  reference_mfg_snpsht.ExpdCompltnDte AS ExpdCompltnDte,
  reference_mfg_snpsht.ChgRecdAuthznGrpText AS ChgRecdAuthznGrpText,
  reference_mfg_snpsht.ChgRecdNmbrChgSts AS ChgRecdNmbrChgSts,
  reference_mfg_snpsht.ChangeNumber AS ChangeNumber
FROM I_ChgRecdRefMfgSnpshtBsc AS reference_mfg_snpsht
INNER JOIN I_EngSnpshtHdr AS EngSnpHdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeRecordDraftTP AS _ChangeRecord ON ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID  -- association [1..1]
;

Learn More