C_EDCResultList

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_EDCResultList.
-- 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_EDCResultList AS
SELECT
  I_EDCResult.EDCResultUUID AS EDCResultUUID,
  I_EDCResult.EDCResultSqncNmbr AS EDCResultSqncNmbr,
  I_EDCResult.EDCRunID AS EDCRunID,
  I_EDCResult.EDCCompany AS EDCCompany,
  I_EDCResult.EDCRecordUUID AS EDCRecordUUID,
  I_EDCResult.EDCResultProcessStatus AS EDCResultProcessStatus,
  I_EDCResult.EDCResultMetaStatus AS EDCResultMetaStatus,
  I_EDCResult.EDCCreatedByUser AS EDCCreatedByUser,
  I_EDCResult.EDCCreatedOnDateTime AS EDCCreatedOnDateTime,
  I_EDCResult.EDCChangedByUser AS EDCChangedByUser,
  I_EDCResult.EDCChangedOnDateTime AS EDCChangedOnDateTime,
  _EDCRecords.EDCCommercialKey AS EDCCommercialKey,
  _EDCRecords.EDCCheckDateTime AS EDCCheckDateTime,
  I_EDCResult.EDCOrganizationalUnit AS EDCOrganizationalUnit,
  I_EDCResult.EDCOrganizationalUnitValue AS EDCOrganizationalUnitValue,
  _EDCBusinessPartner.BusinessPartner AS BusinessPartner,
  _CheckCategory.EDCCheckCategory AS EDCCheckCategory,
  _ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  _ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  _ElectronicDoc.ElectronicDocStatus AS ElectronicDocStatus,
  _ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _ElectronicDoc.ElectronicDocProcStatusText AS ElectronicDocProcStatusText,
  _EDCResultProcStatusText.ElectronicDocProcStatusText AS EDCResultProcessStatusText,
  _ElectronicDoc.ElectronicDocProcessText AS ElectronicDocProcessText,
  _TaxAuthorityDocument.EDCDocumentPeriod AS EDCDocumentPeriod,
  _TaxAuthorityDocument.EDCTaxAuthStatusText AS EDCTaxAuthStatusText,
  _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,
  case when _EDCResultUIGroup.EDCResultUIGroup is null then I_EDCResult.EDCResultProcess else _EDCResultUIGroup.EDCResultUIGroup end as EDCResultUIGroup AS EDCResultUIGroupendasEDCResultUIGroup,
  I_EDCResult.EDCResultProcess AS EDCResultProcess,
  cast(0 as abap.int4 ) AS EDCNumberOfAllResults,
  cast(' ' as edc_page_identifier ) AS EDCPageIdentifier,
  cast( case when I_EDCResult.EDCResultMetaStatus = '0004' then 1 else 0 end as abap.int4) as EDCNumberOfResolvedResults AS int4asEDCNumberOfResolvedResults,
  cast( case when ( I_EDCResult.EDCResultMetaStatus = '0002' or I_EDCResult.EDCResultMetaStatus = '0003' ) then 1 else 0 end as abap.int4) as EDCNumberOfInProcessResults AS int4asEDCNumberOfInProcessResults,
  _CountryText.CountryShortName AS CountryShortName,
  I_EDCResult.EDCResultStatus AS EDCResultStatus,
  I_EDCResult.EDCCountry AS EDCCountry,
  I_EDCResult.EDCSqncNmbr AS EDCSqncNmbr,
  I_EDCResult.EDCCommonKey AS EDCCommonKey,
  I_EDCResult.EDCType AS EDCType,
  I_EDCResult.EDCValidationType AS EDCValidationType,
  I_EDCResult.EDCCheckID AS EDCCheckID,
  I_EDCResult.EDCRepresentationKey AS EDCRepresentationKey,
  I_EDCResult.EDCRepresentationType AS EDCRepresentationType,
  I_EDCResult.EDCResultProcessVersion AS EDCResultProcessVersion,
  _CompanyCodeValueHelp.CompanyCodeName AS CompanyCodeName,
  _EDCResultProcessText.ElectronicDocProcessText AS EDCResultProcessText,
  _EDCResultMetaStatusText.EDCResultMetaStatusText AS EDCResultMetaStatusText,
  cast( '' as abap.char( 20 ) ) AS EDCMismatchGroupName,
  cast( ' ' as abap.char( 1 ) ) AS EDCCommercialNavLink,
  cast( ' ' as waers ) AS EDCSummaryCurrency
FROM I_EDCResult
INNER JOIN I_CountryText AS _CountryText ON /* join condition not captured in parsed metadata */
INNER JOIN I_EDCCheckCategory AS _CheckCategory 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 [1..1]
LEFT OUTER JOIN I_TaxAuthorityDocument AS _TaxAuthorityDocument ON _EDCRelationTaxAuthDocument.EDCRepresentationKey = _TaxAuthorityDocument.EDCTaxAuthRecordUUID  -- association [1..1]
LEFT OUTER JOIN I_EDCRecords AS _EDCRecords ON EDCRecordUUID = _EDCRecords.EDCRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON EDCCompany = _CompanyCodeValueHelp.CompanyCode  -- association [1..1]
LEFT OUTER JOIN R_EDCResultMetaStatusText AS _EDCResultMetaStatusText ON EDCResultMetaStatus = _EDCResultMetaStatusText.EDCResultMetaStatus AND _EDCResultMetaStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ElectronicDocProcStatusText AS _EDCResultProcStatusText ON EDCResultProcess = _EDCResultProcStatusText.ElectronicDocProcess AND EDCResultProcessStatus = _EDCResultProcStatusText.ElectronicDocProcessStatus AND _EDCResultProcStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _EDCResultProcessText ON I_EDCResult.EDCResultProcess = _EDCResultProcessText.ElectronicDocProcess AND _EDCResultProcessText.Language = $session.system_language  -- 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]
;