C_EDocCockpitRelevantOvw

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_EDocCockpitRelevantOvw.
-- 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_EDocCockpitRelevantOvw AS
SELECT
  _eDocument.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  cast( '' as edoc_ced_relevant_flag ) AS ElectronicDocCkptRelevantFlag,
  _eDocument.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  _eDocument.ElectronicDocSourceType AS ElectronicDocSourceType,
  _eDocument.ElectronicDocType AS ElectronicDocType,
  _eDocument.ElectronicDocProcess AS ElectronicDocProcess,
  _eDocument.ElectronicDocInterfaceType AS ElectronicDocInterfaceType,
  _eDocument.ElectronicDocCountry AS ElectronicDocCountry,
  cast ('' as edoc_source_description) AS ElectronicDocSourceTypeText,
  cast ('' as vbeln_vf) AS BillingDocument,
  cast ('' as fkart) AS BillingDocumentType,
  cast ('' as kunag) AS SoldToParty,
  cast ('' as fkdat) AS BillingDocumentDate,
  cast ('' as farp_belnr_d) AS AccountingDocument,
  cast ('' as farp_blart) AS AccountingDocumentType,
  cast ('' as fis_gjahr) AS FiscalYear,
  cast ('' as fis_bldat) AS DocumentDate,
  cast ('' as fins_fiscalperiod) AS FiscalPeriod,
  cast ('' as fagl_ldgrp) AS LedgerGroup,
  cast ('' as mmiv_re_belnr) AS SupplierInvoice,
  cast ('' as gjahr) AS EDocCockpitSupplierFiscalYear,
  cast ('' as lifre) AS InvoicingParty,
  cast ('' as rbstat) AS SupplierInvoiceStatus,
  cast ('' as xblnr1) AS SupplierInvoiceIDByInvcgParty,
  cast ('' as wbeln_ag) AS SettlmtMgmtDoc,
  cast ('' as wlf_settlmt_doc_type) AS SettlmtDocType,
  cast ('' as wfdat) AS PostingDate,
  cast ('' as wlf_related_coco_num) AS SettlmtReltdCndnContr,
  cast ('' as wcb_contract_type) AS CndnContrType,
  cast ('' as invdocno_kk) AS CAInvoicingDocument,
  cast ('' as vkont_kk) AS ContractAccount,
  cast ('' as invdoc_crdat_kk) AS CAInvcgCreationDate,
  cast ('' as gpart_kk) AS BusinessPartner,
  cast ('' as ebeln) AS PurchasingDocument,
  cast ('' as ebdat) AS PurchasingDocumentOrderDate,
  cast ('' as elifn) AS Supplier,
  cast ('' as ekorg_ll) AS PurchasingOrganization,
  cast ('' as mblnr) AS MaterialDocument,
  cast ('' as nsdm_mjahr ) AS MaterialDocumentYear,
  cast ('' as budat) AS EDocCockpitMaterialPostingDate,
  cast ('' as vbeln_vl) AS DeliveryDocument,
  cast ('' as wadat_ist) AS ActualGoodsMovementDate,
  cast ('' as vstel) AS ShippingPoint
FROM I_ElectronicDoc AS _eDocument
;