C_MX_JrnlEntrAggregatedDetails

Mexico Journal Entry Aggregated Details | view: CMXJRNLENTAGGR | Extraction: Not supported | Component: Financials Mexico
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
GLAccount G/L Account
DocumentItemText Item Text
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
💲 Reporting Currency (ReportingCurrency):
DebitAmountInReportingCurrency null
CreditAmountInReportingCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
GLAccountLongName G/L Account Long Text TEXT50
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentReferenceID Document Reference ID XBLNR1
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_MX_JRNLENTRAGGREGATEDDETAILS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T003.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_MX_JRNLENTRAGGREGATEDDETAILS.CHARTOFACCOUNTS == T004.KTOPL
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_MX_JRNLENTRAGGREGATEDDETAILS.COMPANYCODE == T001.BUKRS
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == TCURC.MANDT
  • C_MX_JRNLENTRAGGREGATEDDETAILS.COMPANYCODECURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • C_MX_JRNLENTRAGGREGATEDDETAILS.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRAGGREGATEDDETAILS.LEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == FINSC_LEDGER.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • C_MX_JRNLENTRAGGREGATEDDETAILS.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRAGGREGATEDDETAILS.LEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == FINSC_LEDGER.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == SRF_RPG_ENT.MANDT
  • C_MX_JRNLENTRAGGREGATEDDETAILS.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY