I_ES_EDCElectronicDocRelation

DDL: I_ES_EDCELECTRONICDOCRELATION Type: view_entity COMPOSITE
28 Fields 3 Data Sources

Spain eDoc and Source Doc Relationship

I_ES_EDCElectronicDocRelation is a Composite CDS View that provides data about "Spain eDoc and Source Doc Relationship" in SAP S/4HANA. It reads from 3 data sources (I_ElectronicDoc, I_EDCRelation, I_ES_ElectronicDocAccountDoc) and exposes 28 fields with key fields EDCType, EDCRepresentationType, EDCRepresentationKey.

Data Sources (3)

SourceAliasJoin Type
I_ElectronicDoc _CustElectronicDoc inner
I_EDCRelation _EdcRelation from
I_ES_ElectronicDocAccountDoc _SourceDoc inner

Annotations (7)

NameValueLevelField
EndUserText.label Spain eDoc and Source Doc Relationship view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY EDCType I_EDCRelation EDCType Consistency Scen.
KEY EDCRepresentationType I_EDCRelation EDCRepresentationType Rep. Type
KEY EDCRepresentationKey I_EDCRelation EDCRepresentationKey Representation Key
EDCRecordUUID I_EDCRelation EDCRecordUUID Consistency GUID
EDCCommonKey I_EDCRelation EDCCommonKey Common Key
EDCCompany I_EDCRelation EDCCompany Value
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
CompanyName I_ES_ElectronicDocAccountDoc CompanyName Text
ES_ElectronicDocSIIIssuerIdn I_ES_ElectronicDocAccountDoc ES_ElectronicDocSIIIssuerIdn
FiscalYear I_ES_ElectronicDocAccountDoc FiscalYear G/L Fiscal Year
FiscalPeriod I_ES_ElectronicDocAccountDoc FiscalPeriod Tax period
TaxFulfillmentDate I_ES_ElectronicDocAccountDoc TaxFulfillmentDate Tax Settlement Date

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_ES_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_ES_EDCElectronicDocRelation AS
SELECT
  _EdcRelation.EDCType AS EDCType,
  _EdcRelation.EDCRepresentationType AS EDCRepresentationType,
  _EdcRelation.EDCRepresentationKey AS EDCRepresentationKey,
  _EdcRelation.EDCRecordUUID AS EDCRecordUUID,
  _EdcRelation.EDCCommonKey AS EDCCommonKey,
  _EdcRelation.EDCCompany AS EDCCompany,
  _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,
  _SourceDoc.CompanyName AS CompanyName,
  _SourceDoc.ES_ElectronicDocSIIIssuerIdn AS ES_ElectronicDocSIIIssuerIdn,
  _SourceDoc.FiscalYear AS FiscalYear,
  _SourceDoc.FiscalPeriod AS FiscalPeriod,
  _SourceDoc.TaxFulfillmentDate AS TaxFulfillmentDate
FROM I_EDCRelation AS _EdcRelation
INNER JOIN I_ElectronicDoc AS _CustElectronicDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_ES_ElectronicDocAccountDoc AS _SourceDoc ON /* join condition not captured in parsed metadata */
;

Learn More