C_MX_JrnlEntryOperationalViewC

DDL: C_MX_JRNLENTRYOPERATIONALVIEWC SQL: CMXJEDETAILSC Type: view CONSUMPTION Package: GLO_FIN_IS_GL_MX_JE
28 Fields 1 Data Sources 2 Associations

Journal Entries Items Cube

C_MX_JrnlEntryOperationalViewC is a Consumption CDS View (Cube) that provides data about "Journal Entries Items Cube" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryOperationalView) and exposes 28 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 2 associations to related views. Part of development package GLO_FIN_IS_GL_MX_JE.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryOperationalView DocumentItem from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccount figlmx_prim

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_StRpJournalEntryHeaderLog _ReportedItemsLog _ReportedItemsLog.CompanyCode = DocumentItem.CompanyCode and _ReportedItemsLog.FiscalYear = DocumentItem.FiscalYear and _ReportedItemsLog.AccountingDocument = DocumentItem.AccountingDocument
[0..1] I_MX_ExtPaymentMethodMapping _ExtPaymentMethodMapping _ExtPaymentMethodMapping.PaymentMethod = $projection.PaymentMethod

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMXJEDETAILSC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Journal Entries Items Cube view
AbapCatalog.preserveKey true 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 #BLOCKED_DATA_INCLUDED view
Analytics.internalName #LOCAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryOperationalView SourceLedger Source Ledger
KEY Ledger I_JournalEntryOperationalView Ledger Ledger
KEY CompanyCode I_JournalEntryOperationalView CompanyCode Receiver Company Code
KEY FiscalYear
KEY AccountingDocument I_JournalEntryOperationalView AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryOperationalView LedgerGLLineItem Journal Entry Item
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID
AccountingDocumentItem I_JournalEntryOperationalView AccountingDocumentItem Posting View Item
DocumentReferenceID
ChartOfAccounts I_JournalEntryOperationalView ChartOfAccounts Node Class
FiscalPeriod I_JournalEntryOperationalView FiscalPeriod Tax period
PostingDate I_JournalEntryOperationalView PostingDate Posting Date for GR
DocumentDate I_JournalEntryOperationalView DocumentDate Journal Entry Date
AccountingDocumentType I_JournalEntryOperationalView AccountingDocumentType Journal Entry Type
AssignmentReference I_JournalEntryOperationalView AssignmentReference Assignment Reference
AccountingDocumentCategory I_JournalEntryOperationalView AccountingDocumentCategory Journal Entry Category
PaymentMethod I_JournalEntryOperationalView PaymentMethod Pymt Meth.
MX_ExternalPaymentMethod _ExtPaymentMethodMapping MX_ExternalPaymentMethod
Supplier I_JournalEntryOperationalView Supplier Supplier
Customer I_JournalEntryOperationalView Customer Sold-to Party
TaxCode I_JournalEntryOperationalView TaxCode Tax Code
BusinessPlace I_JournalEntryOperationalView BusinessPlace Business place
CompanyCodeCurrency I_JournalEntryOperationalView CompanyCodeCurrency Local Currency
DebitAmountInCoCodeCrcy
CreditAmountInCoCodeCrcy
ReportingCurrency

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_JrnlEntryOperationalViewC.
-- 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: CMXJEDETAILSC
-- Parameters: P_AlternativeGLAccount : figlmx_prim

CREATE VIEW C_MX_JrnlEntryOperationalViewC AS
SELECT
  DocumentItem.SourceLedger AS SourceLedger,
  DocumentItem.Ledger AS Ledger,
  DocumentItem.CompanyCode AS CompanyCode,
  cast( DocumentItem.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  DocumentItem.AccountingDocument AS AccountingDocument,
  DocumentItem.LedgerGLLineItem AS LedgerGLLineItem,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  DocumentItem.AccountingDocumentItem AS AccountingDocumentItem,
  DocumentItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  DocumentItem.ChartOfAccounts AS ChartOfAccounts,
  DocumentItem.FiscalPeriod AS FiscalPeriod,
  DocumentItem.PostingDate AS PostingDate,
  DocumentItem.DocumentDate AS DocumentDate,
  DocumentItem.AccountingDocumentType AS AccountingDocumentType,
  DocumentItem.AssignmentReference AS AssignmentReference,
  DocumentItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  DocumentItem.PaymentMethod AS PaymentMethod,
  _ExtPaymentMethodMapping.MX_ExternalPaymentMethod AS MX_ExternalPaymentMethod,
  DocumentItem.Supplier AS Supplier,
  DocumentItem.Customer AS Customer,
  DocumentItem.TaxCode AS TaxCode,
  DocumentItem.BusinessPlace AS BusinessPlace,
  DocumentItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast ( DocumentItem.DebitAmountInCoCodeCrcy as fis_dr_hsl preserving type ) AS DebitAmountInCoCodeCrcy,
  cast ( DocumentItem.CreditAmountInCoCodeCrcy as fis_cr_hsl preserving type) AS CreditAmountInCoCodeCrcy,
  cast( 'MXN' as glo_reporting_currency ) AS ReportingCurrency
FROM I_JournalEntryOperationalView AS DocumentItem
LEFT OUTER JOIN I_StRpJournalEntryHeaderLog AS _ReportedItemsLog ON _ReportedItemsLog.CompanyCode = DocumentItem.CompanyCode AND _ReportedItemsLog.FiscalYear = DocumentItem.FiscalYear AND _ReportedItemsLog.AccountingDocument = DocumentItem.AccountingDocument  -- association [0..*]
LEFT OUTER JOIN I_MX_ExtPaymentMethodMapping AS _ExtPaymentMethodMapping ON _ExtPaymentMethodMapping.PaymentMethod = PaymentMethod  -- association [0..1]
;

Learn More