C_ElectronicDocCockpitList

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_ElectronicDocCockpitList.
-- 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.
-- SQL view name: CEDODCCLIST

CREATE VIEW C_ElectronicDocCockpitList AS
SELECT
  _ElectronicDoc.ElectronicDocUUID AS ElectronicDocUUID,
  cast( '' as edoc_dcc_archivemode ) AS ElectronicDocCkptArchiveMode,
  cast( '' as arkey ) AS ElectronicDocArchiveFileID,
  _ElectronicDoc.ElectronicDocSequenceNmbr AS ElectronicDocSequenceNmbr,
  _ElectronicDoc.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _ElectronicDoc.ElectronicDocCountry AS ElectronicDocCountry,
  _CountryText.CountryShortName AS CountryShortName,
  _ElectronicDoc.ElectronicDocSourceType AS ElectronicDocSourceType,
  _ElectronicDocSourceTypeText.ElectronicDocSourceTypeText AS ElectronicDocSourceTypeText,
  _ElectronicDoc.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  ElectronicDocLogicalSystem,
  _ElectronicDoc.ElectronicDocType AS ElectronicDocType,
  _ElectronicDocTypeText.ElectronicDocTypeText AS ElectronicDocTypeText,
  _ElectronicDoc.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  _ElectronicDocCockpitProcSts.ElectronicDocProcStatusText AS ElectronicDocProcStatusText,
  _ElectronicDoc.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  _ElectronicDoc.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  _ElectronicDoc.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  _ElectronicDoc.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  _ElectronicDoc.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _ElectronicDoc.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  _ElectronicDoc.ElectronicDocProcess AS ElectronicDocProcess,
  _ElectronicDocProcessText.ElectronicDocProcessText AS ElectronicDocProcessText,
  _ElectronicDoc.ElectronicDocStatus AS ElectronicDocStatus,
  _ElectronicDoc.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _ElectronicDoc.ElectronicDocIsContingency AS ElectronicDocIsContingency,
  _ElectronicDoc.ElectronicDocReferenceProcess AS ElectronicDocReferenceProcess,
  _ElectronicDoc.ElectronicDocIsArchPrprocgDone AS ElectronicDocIsArchPrprocgDone,
  cast( _ElectronicDoc.ElectronicDocInterfaceUUID as abap.char( 32 ) ) AS ElectronicDocInterfaceUUID,
  _ElectronicDoc.ElectronicDocFileUUID AS ElectronicDocFileUUID,
  _ElectronicDoc.ElectronicDocInterfaceID AS ElectronicDocInterfaceID,
  _ElectronicDoc.ElectronicDocInterfaceVersion AS ElectronicDocInterfaceVersion,
  _ElectronicDoc.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _ElectronicDoc.ElectronicDocLastProcStep AS ElectronicDocLastProcStep,
  _ElectronicDoc.ElectronicDocLastProcStepVar AS ElectronicDocLastProcStepVar,
  _ElectronicDoc.ElectronicDocHasError AS ElectronicDocHasError,
  _ElectronicDoc.ElectronicDocProcessVersion AS ElectronicDocProcessVersion,
  _ElectronicDoc.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  _ElectronicDoc.ElectronicDocIsCntdInArchive AS ElectronicDocIsCntdInArchive,
  _AccountingDocument.AccountingDocument AS AccountingDocument,
  _AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  _AccountingDocument.DocumentDate AS DocumentDate,
  _AccountingDocument.FiscalYear AS FiscalYear,
  _AccountingDocument.FiscalPeriod AS FiscalPeriod,
  _AccountingDocument.LedgerGroup AS LedgerGroup,
  _BillingDocument.BillingDocument AS BillingDocument,
  _BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  _BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocument.SoldToParty AS SoldToParty,
  _BillingDocument.OverallBillingStatus AS OverallBillingStatus,
  _SettlmtMgmtDoc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  _SettlmtMgmtDoc.SettlmtDocType AS SettlmtDocType,
  _SettlmtMgmtDoc.PostingDate AS PostingDate,
  _SettlmtMgmtDoc.CndnContrType AS CndnContrType,
  _CAInvcgDocHeader.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocHeader.ContractAccount AS ContractAccount,
  _CAInvcgDocHeader.CAInvcgCreationDate AS CAInvcgCreationDate,
  _CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
  _PurchasingDoc.PurchasingDocument AS PurchasingDocument,
  _PurchasingDoc.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  _PurchasingDoc.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDoc.Supplier AS Supplier,
  cast('' as abap.char( 15 )) AS ElectronicDocAction,
  cast('' as edoc_dcc_msg_text ) AS LogMessageText,
  cast('' as abap.char( 1000 )) AS LogMessageLongText,
  cast('' as edoc_dcc_error_code ) AS ElectronicDocCockpitErrorCode,
  cast( '' as abap.char( 1 )) AS ElectronicDocCockpitUsageFlag,
  cast( '' as ad_namtext ) AS EDocSrceCrtedByUsrName,
  cast( '' as ad_smtpadr ) AS ElectronicDocSrceCrtedByUsrEml,
  cast( '' as abap.char( 20 ) ) AS ElectronicDocCockpitErrorCat,
  cast( '' as edoc_cvp_blocked ) AS ElectronicDocBPIsBlocked,
  cast( '' as abap.char( 1 ) ) AS ElectronicDocCockpitHistIcon,
  cast( '' as abap.char( 1 ) ) AS ElectronicDocCockpitLogIcon,
  cast( '' as abap.char( 1 ) ) AS ElectronicDocCockpitAttchIcon,
  cast(' ' as edoc_error_active ) AS ElectronicDocCkptIsErrorActive,
  cast(' ' as edoc_mail_active ) AS ElectronicDocCkptIsMailActive,
  cast( '99999999' as entry_no ) AS NumberOfMetaStsElectronicDocs,
  cast( '99999999' as entry_no ) AS NumberOfActnRqdElectronicDocs,
  cast( '99999999' as entry_no ) AS NumberOfInProcElectronicDocs,
  cast( '99999999' as entry_no ) AS NumberOfCmpltdElectronicDocs,
  cast( '' as abap.char( 1333 ) ) AS ElectronicDocCkptProcFieldsTxt,
  cast( '' as edoc_dcc_casemode) AS ElectronicDocCockpitCaseMode,
  cast( '0000' as abap.char( 4 ) ) AS ElectronicDocCockpitStstcHier,
  _SupplierInvoice.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoice.InvoicingParty AS InvoicingParty,
  _SupplierInvoice.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  _SupplierInvoice.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  _CADocument.CADocumentNumber AS CADocumentNumber,
  _CADocument.CAPostingDate AS CAPostingDate,
  _REInvoiceHeader.REInvoiceNumber AS REInvoiceNumber,
  _REInvoiceHeader.FiscalYear AS EDocCockpitREFiscalYear,
  _SalesDocumentBasic.SalesDocument AS SalesDocument,
  _SalesDocumentBasic.SalesDocumentDate AS SalesDocumentDate,
  _SalesDocumentBasic.SoldToParty AS EDocCockpitSalesSoldToParty,
  _SalesDocumentBasic.SalesOrganization AS SalesOrganization,
  _ElectronicDocCockpitProcSts.ElectronicDocCountryISOCode AS ElectronicDocCountryISOCode
FROM I_ElectronicDocCockpitList AS _ElectronicDoc
INNER JOIN I_ElectronicDocCockpitProcSts AS _ElectronicDocCockpitProcSts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON ElectronicDocSourceKey = _BillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocAccountingDoc AS _AccountingDocument ON _ElectronicDoc.AccountingDocument = _AccountingDocument.AccountingDocument AND _ElectronicDoc.FiscalYear = _AccountingDocument.FiscalYear AND _ElectronicDoc.CompanyCode = _AccountingDocument.CompanyCode  -- association [0..1]
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _SettlmtMgmtDoc ON ElectronicDocSourceKey = _SettlmtMgmtDoc.SettlmtMgmtDoc  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON ElectronicDocSourceKey = _CAInvcgDocHeader.CAInvoicingDocument  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON _ElectronicDoc.SupplierInvoice = _SupplierInvoice.SupplierInvoice AND _ElectronicDoc.FiscalYear = _SupplierInvoice.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDoc ON ElectronicDocSourceKey = _PurchasingDoc.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _CADocument ON ElectronicDocSourceKey = _CADocument.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesDocumentBasic ON ElectronicDocSourceKey = _SalesDocumentBasic.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_REInvoiceHeader AS _REInvoiceHeader ON _REInvoiceHeader.REInvoiceNumber = _ElectronicDoc.REInvoiceNumber AND _REInvoiceHeader.FiscalYear = _ElectronicDoc.FiscalYear AND _REInvoiceHeader.CompanyCode = _ElectronicDoc.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ElectronicDocTypeText AS _ElectronicDocTypeText ON ElectronicDocType = _ElectronicDocTypeText.ElectronicDocType AND _ElectronicDocTypeText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_ElectronicDocSourceTypeText AS _ElectronicDocSourceTypeText ON ElectronicDocSourceType = _ElectronicDocSourceTypeText.ElectronicDocSourceType AND _ElectronicDocSourceTypeText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _ElectronicDocProcessText ON ElectronicDocProcess = _ElectronicDocProcessText.ElectronicDocProcess AND _ElectronicDocProcessText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN C_ElectronicDocCockpitProcess AS _ElectronicDocCockpitProcess ON ElectronicDocProcess = _ElectronicDocCockpitProcess.ElectronicDocProcess  -- association [1..1]
LEFT OUTER JOIN C_ElectronicDocMetaStsStstc AS _ElectronicDocMetaStsStstc ON ElectronicDocProcess = _ElectronicDocMetaStsStstc.ElectronicDocProcess  -- association [1..1]
LEFT OUTER JOIN C_ElectronicDocMetaStsChtFlow AS _ElectronicDocMetaStsChtFlow ON ElectronicDocProcess = _ElectronicDocMetaStsChtFlow.ElectronicDocProcess AND ElectronicDocMetaStatus = _ElectronicDocMetaStsChtFlow.ElectronicDocMetaStatus  -- association [1..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = _ElectronicDocCockpitProcSts.ElectronicDocCountryISOCode AND _CountryText.Language = $session.system_language  -- association [0..*]
;