I_IN_EDocReference

DDL: I_IN_EDOCREFERENCE Type: view_entity COMPOSITE
7 Fields 2 Data Sources

Electronic Document Reference

I_IN_EDocReference is a Composite CDS View that provides data about "Electronic Document Reference" in SAP S/4HANA. It reads from 2 data sources (I_StRpRepRun, I_ElectronicDocumentReference) and exposes 7 fields with key fields StatryRptRunUUID, ElectronicDocReferenceKey, ElectronicDocReferenceType.

Data Sources (2)

SourceAliasJoin Type
I_StRpRepRun _StrpRepRun inner
I_ElectronicDocumentReference I_ElectronicDocumentReference from

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Electronic Document Reference view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatryRptRunUUID I_ElectronicDocumentReference StatryRptRunUUID UUID
KEY ElectronicDocReferenceKey I_ElectronicDocumentReference ElectronicDocReferenceKey Key Number
KEY ElectronicDocReferenceType I_ElectronicDocumentReference ElectronicDocReferenceType Sttl. Ref. Type
ReferenceElectronicDocSqncNmbr I_ElectronicDocumentReference ReferenceElectronicDocSqncNmbr Reference Seq. Nr.
StatryRptgEntity I_StRpRepRun StatryRptgEntity Reporting Entity
StatryRptCategory I_StRpRepRun StatryRptCategory Report ID
StatryRptRunID I_StRpRepRun StatryRptRunID Report Run ID

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_IN_EDocReference.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_IN_EDocReference AS
SELECT
  I_ElectronicDocumentReference.StatryRptRunUUID AS StatryRptRunUUID,
  I_ElectronicDocumentReference.ElectronicDocReferenceKey AS ElectronicDocReferenceKey,
  I_ElectronicDocumentReference.ElectronicDocReferenceType AS ElectronicDocReferenceType,
  I_ElectronicDocumentReference.ReferenceElectronicDocSqncNmbr AS ReferenceElectronicDocSqncNmbr,
  _StrpRepRun.StatryRptgEntity AS StatryRptgEntity,
  _StrpRepRun.StatryRptCategory AS StatryRptCategory,
  _StrpRepRun.StatryRptRunID AS StatryRptRunID
FROM I_ElectronicDocumentReference
INNER JOIN I_StRpRepRun AS _StrpRepRun ON /* join condition not captured in parsed metadata */
;

Learn More