C_EDocCockpitRelevantOvw

DDL: C_EDOCCOCKPITRELEVANTOVW Type: view_entity CONSUMPTION

Entity for Create Electronic Documents

C_EDocCockpitRelevantOvw is a Consumption CDS View that provides data about "Entity for Create Electronic Documents" in SAP S/4HANA. It reads from 1 data source (I_ElectronicDoc) and exposes 36 fields with key fields ElectronicDocCompanyCode, ElectronicDocCkptRelevantFlag, ElectronicDocSourceKey, ElectronicDocSourceType, ElectronicDocType.

Data Sources (1)

SourceAliasJoin Type
I_ElectronicDoc _eDocument from

Annotations (8)

NameValueLevelField
EndUserText.label Entity for Create Electronic Documents view
ObjectModel.query.implementedBy ABAP:CL_CED_CDS_UNMANAGED_QUERY view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocCompanyCode I_ElectronicDoc ElectronicDocCompanyCode Value
KEY ElectronicDocCkptRelevantFlag
KEY ElectronicDocSourceKey I_ElectronicDoc ElectronicDocSourceKey Source System Key
KEY ElectronicDocSourceType I_ElectronicDoc ElectronicDocSourceType SRVC Source Type
KEY ElectronicDocType I_ElectronicDoc ElectronicDocType eDoc Type
KEY ElectronicDocProcess I_ElectronicDoc ElectronicDocProcess Trans.
KEY ElectronicDocInterfaceType I_ElectronicDoc ElectronicDocInterfaceType Plug-In Interface Tp
KEY ElectronicDocCountry I_ElectronicDoc ElectronicDocCountry CtryReg ISO Cd
ElectronicDocSourceTypeText
BillingDocument
BillingDocumentType
SoldToParty
BillingDocumentDate
AccountingDocument
AccountingDocumentType
FiscalYear
DocumentDate
FiscalPeriod
LedgerGroup
SupplierInvoice
InvoicingParty
SupplierInvoiceStatus
SupplierInvoiceIDByInvcgParty
SettlmtMgmtDoc
SettlmtDocType
PostingDate
SettlmtReltdCndnContr
CndnContrType
CAInvoicingDocument
ContractAccount
CAInvcgCreationDate
BusinessPartner
PurchasingDocument
PurchasingDocumentOrderDate
Supplier
PurchasingOrganization

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 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
FROM I_ElectronicDoc AS _eDocument
;