I_EDCElectronicDocRelation

DDL: I_EDCELECTRONICDOCRELATION Type: view_entity BASIC
24 Fields 1 Data Sources

eDocument Consistency Relationship

I_EDCElectronicDocRelation is a Basic CDS View that provides data about "eDocument Consistency Relationship" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 24 fields.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc _CustElectronicDoc from

Annotations (7)

NameValueLevelField
EndUserText.label eDocument Consistency Relationship view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view

Fields (24)

KeyFieldSource TableSource FieldDescription
ElectronicDocUUID I_ElectronicDoc ElectronicDocUUID eDocument GUID
ElectronicDocSequenceNmbr I_ElectronicDoc ElectronicDocSequenceNmbr Value Number
ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
ElectronicDocCountry I_ElectronicDoc ElectronicDocCountry CtryReg ISO Cd
ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey Source System Key
ElectronicDocType I_ElectronicDoc ElectronicDocType eDoc Type
ElectronicDocProcessStatus I_ElectronicDoc ElectronicDocProcessStatus Work Item ID
ElectronicDocCreationDate I_ElectronicDoc ElectronicDocCreationDate Time Stamp
ElectronicDocLastChangeDate I_ElectronicDoc ElectronicDocLastChangeDate Time Stamp
ElectronicDocLastChangeTime I_ElectronicDoc ElectronicDocLastChangeTime Time Stamp
ElectronicDocPostingDate I_ElectronicDoc ElectronicDocPostingDate Posting Date
ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess Trans.
ElectronicDocCreatedByUser I_ElectronicDoc ElectronicDocCreatedByUser Version Created By
ElectronicDocCreationTime I_ElectronicDoc ElectronicDocCreationTime Time
ElectronicDocSrceCreatedByUser I_ElectronicDoc ElectronicDocSrceCreatedByUser Source Crted By
ElectronicDocMetaStatus I_ElectronicDoc ElectronicDocMetaStatus Status
EDCType _EdcRelation EDCType
EDCRepresentationType _EdcRelation EDCRepresentationType
EDCRepresentationKey _EdcRelation EDCRepresentationKey
EDCRecordUUID _EdcRelation EDCRecordUUID
EDCCommonKey _EdcRelation EDCCommonKey
EDCCompany _EdcRelation EDCCompany
EDCCreatedOnDateTime _EdcRelation EDCCreatedOnDateTime

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_EDCElectronicDocRelation.
-- 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.

CREATE VIEW I_EDCElectronicDocRelation AS
SELECT
  _CustElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  _CustElectronicDoc.ElectronicDocSequenceNmbr AS ElectronicDocSequenceNmbr,
  _CustElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _CustElectronicDoc.ElectronicDocCountry AS ElectronicDocCountry,
  _CustElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _CustElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _CustElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _CustElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _CustElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _CustElectronicDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  _CustElectronicDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  _CustElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _CustElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  _CustElectronicDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  _CustElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  _CustElectronicDoc.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  _CustElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _EdcRelation.EDCType AS EDCType,
  _EdcRelation.EDCRepresentationType AS EDCRepresentationType,
  _EdcRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _EdcRelation.EDCRecordUUID AS EDCRecordUUID,
  _EdcRelation.EDCCommonKey AS EDCCommonKey,
  _EdcRelation.EDCCompany AS EDCCompany,
  _EdcRelation.EDCCreatedOnDateTime AS EDCCreatedOnDateTime
FROM I_ElectronicDoc AS _CustElectronicDoc
;

Learn More