P_MX_eDocuments

DDL: P_MX_EDOCUMENTS SQL: PMXEDOC Type: view BASIC Package: GLO_FIN_IS_GL_MX_JE
5 Fields 1 Data Sources

Data from eDocument table

P_MX_eDocuments is a Basic CDS View that provides data about "Data from eDocument table" in SAP S/4HANA. It reads from 1 data source (edocument) and exposes 5 fields with key fields DocumentGUID, CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_GL_MX_JE.

Data Sources (1)

SourceAliasJoin Type
edocument edocument from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMXEDOC view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY DocumentGUID edoc_guid eDocument GUID
KEY CompanyCode bukrs Value
KEY AccountingDocument
KEY FiscalYear
DocumentType eDoc Type

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 P_MX_eDocuments.
-- 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: PMXEDOC

CREATE VIEW P_MX_eDocuments AS
SELECT
  edoc_guid AS DocumentGUID,
  bukrs AS CompanyCode,
  cast(substring(source_key,5,10) as fis_belnr preserving type ) AS AccountingDocument,
  cast(substring(source_key,15,4) as fis_gjahr_no_conv ) AS FiscalYear,
  cast(edoc_type as edoc_type preserving type) AS DocumentType
FROM edocument
;

Learn More