C_MX_JournalEntryDetailsCube

DDL: C_MX_JOURNALENTRYDETAILSCUBE SQL: CMXJRNLENTRYC Type: view CONSUMPTION
15 Fields 1 Data Sources

Mexico Journal Entry Details Cube

C_MX_JournalEntryDetailsCube is a Consumption CDS View (Cube) that provides data about "Mexico Journal Entry Details Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpJournalEntryHeaderLog) and exposes 15 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
I_StRpJournalEntryHeaderLog I_StRpJournalEntryHeaderLog inner

Parameters (1)

NameTypeDefault
P_AlternativeGLAccount figlmx_prim

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMXJRNLENTRYC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mexico Journal Entry Details Cube view
Analytics.dataCategory #CUBE view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.internalName #LOCAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger JournalEntry SourceLedger Source Ledger
KEY Ledger JournalEntry Ledger Ledger
KEY CompanyCode JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear
KEY AccountingDocument JournalEntry AccountingDocument Journal Entry
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID Report Run ID
DocumentReferenceID
PostingDate JournalEntry PostingDate Posting Date for GR
DocumentDate JournalEntry DocumentDate Journal Entry Date
AccountingDocumentType JournalEntry AccountingDocumentType Journal Entry Type
GLAccountendasGLAccount
PaymentMethod
MX_ExternalPaymentMethod

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_MX_JournalEntryDetailsCube.
-- 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: CMXJRNLENTRYC
-- Parameters: P_AlternativeGLAccount : figlmx_prim

CREATE VIEW C_MX_JournalEntryDetailsCube AS
SELECT
  JournalEntry.SourceLedger AS SourceLedger,
  JournalEntry.Ledger AS Ledger,
  JournalEntry.CompanyCode AS CompanyCode,
  cast( JournalEntry.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  I_StRpJournalEntryHeaderLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpJournalEntryHeaderLog.StatryRptCategory AS StatryRptCategory,
  I_StRpJournalEntryHeaderLog.StatryRptRunID AS StatryRptRunID,
  JournalEntry._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  case $parameters.P_AlternativeGLAccount when 'X' then JournalEntry.AlternativeGLAccount else JournalEntry.GLAccount end as GLAccount AS GLAccountendasGLAccount,
  '' AS PaymentMethod,
  cast( '' as fimx_external_payment_method ) AS MX_ExternalPaymentMethod
INNER JOIN I_StRpJournalEntryHeaderLog ON /* join condition not captured in parsed metadata */
;

Learn More