C_EDCDocumentList

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 C_EDCDocumentList.
-- 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 C_EDCDocumentList AS
SELECT
  _EDCRecords.EDCRecordUUID AS EDCRecordUUID,
  _EDCRecords.EDCRunID AS EDCRunID,
  _EDCRecords.EDCCompany AS EDCCompany,
  _EDCRecords.EDCCommercialKey AS EDCCommercialKey,
  _EDCRecords.EDCMetaStatus AS EDCMetaStatus,
  _EDCRecords.EDCCreatedByUser AS EDCCreatedByUser,
  _EDCRecords.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  _EDCRecords.EDCChangedByUser AS EDCChangedByUser,
  _EDCRecords.EDCChangedOnDateTime AS EDCChangedOnDateTime,
  _EDCRecords.EDCCheckDateTime AS EDCCheckDateTime,
  cast(0 as abap.int8 ) AS EDCNumberOfExecutedChecks,
  cast(0 as abap.int8 ) AS EDCNumberOfTotalChecks,
  cast(0 as abap.int8 ) AS EDCNumberOfInProcessResults,
  cast(0 as abap.int8 ) AS EDCNumberOfAllResults,
  cast(0 as abap.int8 ) AS EDCNumberOfRelevantChecks,
  cast( ' ' as abap.char( 1 ) ) AS EDCCommercialNavLink,
  _EDCRecords.EDCOrganizationalUnit AS EDCOrganizationalUnit,
  _EDCRecords.EDCOrganizationalUnitValue AS EDCOrganizationalUnitValue,
  _EDCRecords.EDCSqncNmbr AS EDCSqncNmbr,
  _EDCRecords.EDCType AS EDCType,
  _EDCBusinessPartner.BusinessPartner AS BusinessPartner,
  _ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  _ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _ElectronicDoc.ElectronicDocSourceTypeText AS ElectronicDocSourceTypeText,
  _ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _ElectronicDoc.ElectronicDocTypeText AS ElectronicDocTypeText,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  _ElectronicDoc.ElectronicDocProcessText AS ElectronicDocProcessText,
  _ElectronicDoc.ElectronicDocStatus AS ElectronicDocStatus,
  _ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _ElectronicDoc.ElectronicDocProcStatusText AS ElectronicDocProcStatusText,
  _JournalEntry.AccountingDocument AS AccountingDocument,
  _JournalEntry.FiscalYear AS FiscalYear,
  _JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntry.DocumentDate AS DocumentDate,
  _JournalEntry.PostingDate AS PostingDate,
  _JournalEntry.FiscalPeriod AS FiscalPeriod,
  _JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _JournalEntry.CreationTime AS CreationTime,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _JournalEntry.ReverseDocument AS ReverseDocument,
  _JournalEntry.TransactionCurrency AS TransactionCurrency,
  _JournalEntry.TaxReportingDate AS TaxReportingDate,
  _JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  _JournalEntry.IsReversal AS IsReversal,
  _TaxAuthorityDocument.EDCDocumentPeriod AS EDCDocumentPeriod,
  _TaxAuthorityDocument.EDCTaxAuthDocumentKey AS EDCTaxAuthDocumentKey,
  _TaxAuthorityDocument.EDCTaxAuthDocumentType AS EDCTaxAuthDocumentType,
  _TaxAuthorityDocument.EDCBusinessPartnerID AS EDCBusinessPartnerID,
  _TaxAuthorityDocument.EDCTaxAuthStatusText AS EDCTaxAuthStatusText,
  _CountryText.CountryShortName AS CountryShortName,
  _CompanyCodeValueHelp.CompanyCodeName AS CompanyCodeName,
  _EDCMetaStatusText.EDCMetaStatusText AS EDCMetaStatusText,
  _EDCType.EDCCountry AS EDCCountry
FROM I_EDCRecords AS _EDCRecords
INNER JOIN R_EDCType AS _EDCType ON /* join condition not captured in parsed metadata */
INNER JOIN I_CountryText AS _CountryText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EDCRelation AS _EDCRelation ON EDCRecordUUID = _EDCRelation.EDCRecordUUID  -- association [1..*]
LEFT OUTER JOIN R_EDCElectronicDoc AS _ElectronicDoc ON _EDCRelationElectronicDocument.EDCRepresentationKey = _ElectronicDoc.ElectronicDocUUID  -- association [0..1]
LEFT OUTER JOIN C_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON EDCCompany = _CompanyCodeValueHelp.CompanyCode  -- association [1..1]
LEFT OUTER JOIN R_EDCMetaStatusText AS _EDCMetaStatusText ON EDCMetaStatus = _EDCMetaStatusText.EDCMetaStatus AND _EDCMetaStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TaxAuthorityDocument AS _TaxAuthorityDocument ON _EDCRelationTaxAuthDocument.EDCRepresentationKey = _TaxAuthorityDocument.EDCTaxAuthRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _EDCAccountingDocRelation.CompanyCode = _JournalEntry.CompanyCode AND _EDCAccountingDocRelation.AccountingDocument = _JournalEntry.AccountingDocument AND _EDCAccountingDocRelation.FiscalYear = _JournalEntry.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_EDCBusinessPartner AS _EDCBusinessPartner ON EDCRecordUUID = _EDCBusinessPartner.EDCRecordUUID  -- association [1..1]
;