I_EngSnpshtRefDoc

DDL: I_ENGSNPSHTREFDOC SQL: IENGSNPREFDOC Type: view COMPOSITE
19 Fields 3 Data Sources 2 Associations

Engineering Snapshot Ref Obj Document

I_EngSnpshtRefDoc is a Composite CDS View that provides data about "Engineering Snapshot Ref Obj Document" in SAP S/4HANA. It reads from 3 data sources (I_DocumentInfoRecord, I_EngSnpshtHdr, I_EngSnpshtObjRef) and exposes 19 fields with key fields EngSnapshotRefUUID, DocumentType, DocumentInfoRecord, DocumentPart, DocumentVersion. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_DocumentInfoRecord DocumentInfoRecord inner
I_EngSnpshtHdr EngSnpshtHdr inner
I_EngSnpshtObjRef EngSnpshtObjRef from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_DocumentInfoRecordDocStatus _DocStatus $projection.DocumentType = _DocStatus.DocumentInfoRecordDocType and $projection.InternalDocumentStatus = _DocStatus.InternalDocumentStatus
[0..1] I_DocumentInfoRecordDocPrt _DocumentInfoRecordDocPrt $projection.DocumentType = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocType and $projection.DocumentInfoRecord = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocNumber and $projection.DocumentPart = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocPart and $projection.DocumentVersion = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPREFDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Engineering Snapshot Ref Obj Document view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY EngSnapshotRefUUID I_EngSnpshtObjRef EngSnapshotRefUUID Waste Partner UUID
KEY DocumentType I_DocumentInfoRecord DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecord I_DocumentInfoRecord DocumentInfoRecordDocNumber Document
KEY DocumentPart I_DocumentInfoRecord DocumentInfoRecordDocPart Document Part
KEY DocumentVersion I_DocumentInfoRecord DocumentInfoRecordDocVersion Doc. Version
EngSnapshotUUID I_EngSnpshtObjRef EngSnapshotUUID Waste Partner UUID
EngSnapshotID I_EngSnpshtHdr EngSnapshotID Snapshot ID
EngSnpshtRevisionNumber I_EngSnpshtHdr EngSnpshtRevisionNumber Snapshot Revision
EngSnpshtRefType I_EngSnpshtObjRef EngSnpshtRefType Worklist Type
InternalDocumentStatus InternalDocumentStatus Status
CreatedByUser I_EngSnpshtObjRef CreatedByUser User Name
CreationDateTime I_EngSnpshtObjRef CreationDateTime Timestamp
LastChangedByUser I_EngSnpshtObjRef LastChangedByUser User Name
LastChangeDateTime I_EngSnpshtObjRef LastChangeDateTime Timestamp
DocumentDescription _DocumentInfoRecordDocPrt DocumentDescription Doc. Name
_DocType _DocType
_DocNumber _DocNumber
_DocVersion _DocVersion
_DocStatus _DocStatus

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_EngSnpshtRefDoc.
-- 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: IENGSNPREFDOC

CREATE VIEW I_EngSnpshtRefDoc AS
SELECT
  EngSnpshtObjRef.EngSnapshotRefUUID AS EngSnapshotRefUUID,
  DocumentInfoRecord.DocumentInfoRecordDocType AS DocumentType,
  DocumentInfoRecord.DocumentInfoRecordDocNumber AS DocumentInfoRecord,
  DocumentInfoRecord.DocumentInfoRecordDocPart AS DocumentPart,
  DocumentInfoRecord.DocumentInfoRecordDocVersion AS DocumentVersion,
  EngSnpshtObjRef.EngSnapshotUUID AS EngSnapshotUUID,
  EngSnpshtHdr.EngSnapshotID AS EngSnapshotID,
  EngSnpshtHdr.EngSnpshtRevisionNumber AS EngSnpshtRevisionNumber,
  EngSnpshtObjRef.EngSnpshtRefType AS EngSnpshtRefType,
  InternalDocumentStatus,
  EngSnpshtObjRef.CreatedByUser AS CreatedByUser,
  EngSnpshtObjRef.CreationDateTime AS CreationDateTime,
  EngSnpshtObjRef.LastChangedByUser AS LastChangedByUser,
  EngSnpshtObjRef.LastChangeDateTime AS LastChangeDateTime,
  _DocumentInfoRecordDocPrt.DocumentDescription AS DocumentDescription
FROM I_EngSnpshtObjRef AS EngSnpshtObjRef
INNER JOIN I_EngSnpshtHdr AS EngSnpshtHdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_DocumentInfoRecord AS DocumentInfoRecord ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentInfoRecordDocStatus AS _DocStatus ON DocumentType = _DocStatus.DocumentInfoRecordDocType AND InternalDocumentStatus = _DocStatus.InternalDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_DocumentInfoRecordDocPrt AS _DocumentInfoRecordDocPrt ON DocumentType = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocType AND DocumentInfoRecord = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocNumber AND DocumentPart = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocPart AND DocumentVersion = _DocumentInfoRecordDocPrt.DocumentInfoRecordDocVersion  -- association [0..1]
;

Learn More