C_ElectronicDocCockpitFilter

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_ElectronicDocCockpitFilter.
-- 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: CEDODCCF

CREATE VIEW C_ElectronicDocCockpitFilter AS
SELECT
  _eDocument.ElectronicDocUUID AS ElectronicDocUUID,
  _eDocument.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  _eDocument.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _eDocument.ElectronicDocType AS ElectronicDocType,
  _eDocument.ElectronicDocCreatedByUser AS ElectronicDocCreatedByUser,
  _eDocument.ElectronicDocCreationDate AS ElectronicDocCreationDate,
  _eDocument.ElectronicDocPostingDate AS ElectronicDocPostingDate,
  _eDocument.ElectronicDocCountry AS ElectronicDocCountry,
  _eDocument.ElectronicDocSourceType AS ElectronicDocSourceType,
  _eDocument.ElectronicDocMetaStatus AS ElectronicDocMetaStatus,
  _eDocument.ElectronicDocProcessStatus AS ElectronicDocProcessStatus,
  ElectronicDocLogicalSystem,
  _eDocument.ElectronicDocLastChangedByUser AS ElectronicDocLastChangedByUser,
  _eDocument.ElectronicDocLastChangeDate AS ElectronicDocLastChangeDate,
  _eDocument.ElectronicDocLastChangeTime AS ElectronicDocLastChangeTime,
  _eDocument.ElectronicDocCreationTime AS ElectronicDocCreationTime,
  _eDocument.ElectronicDocProcess AS ElectronicDocProcess,
  _eDocument.ElectronicDocLastProcStep AS ElectronicDocLastProcStep,
  _eDocument.ElectronicDocLastProcStepVar AS ElectronicDocLastProcStepVar,
  _eDocument.ElectronicDocHasError AS ElectronicDocHasError,
  _eDocument.ElectronicDocProcessVersion AS ElectronicDocProcessVersion,
  _eDocument.ElectronicDocStatus AS ElectronicDocStatus,
  _eDocument.ElectronicDocIsContingency AS ElectronicDocIsContingency,
  _eDocument.ElectronicDocReferenceProcess AS ElectronicDocReferenceProcess,
  _eDocument.ElectronicDocIsArchPrprocgDone AS ElectronicDocIsArchPrprocgDone,
  _eDocument.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  cast( _eDocument.ElectronicDocInterfaceUUID as abap.char( 32 ) ) AS ElectronicDocInterfaceUUID,
  _eDocument.ElectronicDocFileUUID AS ElectronicDocFileUUID,
  _eDocument.ElectronicDocInterfaceID AS ElectronicDocInterfaceID,
  _eDocument.ElectronicDocInterfaceVersion AS ElectronicDocInterfaceVersion,
  _eDocument.ElectronicDocIsCntdInArchive AS ElectronicDocIsCntdInArchive,
  _eDocument.ElectronicDocSrceCreatedByUser AS ElectronicDocSrceCreatedByUser,
  _BillingDocument.BillingDocument AS BillingDocument,
  _BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocument.SoldToParty AS SoldToParty,
  _BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  _AccountingDocument.AccountingDocument AS AccountingDocument,
  _AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  _AccountingDocument.FiscalYear AS FiscalYear,
  _AccountingDocument.DocumentDate AS DocumentDate,
  _AccountingDocument.FiscalPeriod AS FiscalPeriod,
  _AccountingDocument.LedgerGroup AS LedgerGroup,
  _SupplierInvoice.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoice.InvoicingParty AS InvoicingParty,
  _SupplierInvoice.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  _SupplierInvoice.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  _SettlmtMgmtDoc.SettlmtMgmtDoc AS SettlmtMgmtDoc,
  _SettlmtMgmtDoc.SettlmtDocType AS SettlmtDocType,
  _SettlmtMgmtDoc.PostingDate AS PostingDate,
  _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.Supplier AS Supplier,
  _PurchasingDoc.PurchasingOrganization AS PurchasingOrganization,
  _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
FROM I_ElectronicDoc AS _eDocument
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON _BillingDocument.BillingDocument = _eDocument.ElectronicDocSourceKey  -- association [0..1]
LEFT OUTER JOIN R_SettlmtMgmtDoc AS _SettlmtMgmtDoc ON _SettlmtMgmtDoc.SettlmtMgmtDoc = _eDocument.ElectronicDocSourceKey  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgDocHeader AS _CAInvcgDocHeader ON _CAInvcgDocHeader.CAInvoicingDocument = _eDocument.ElectronicDocSourceKey  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDoc ON _PurchasingDoc.PurchasingDocument = _eDocument.ElectronicDocSourceKey  -- 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]
;