P_MX_JrnlEntrAggregatedDets2

Mexico Journal Entry Aggregated Details | view: PMXJRNLENTAGGR2 | Extraction: Not supported | Component: Financials Mexico
Tables used: ACDOCABKPFBSEGT004SKA1PROJPRPST001T014SKATT004FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
GLAccount G/L Account
DocumentItemText Item Text
DebitCreditCode Debit/Credit Code Show values
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Reporting Currency (ReportingCurrency):
DebitAmountInReportingCurrency Debit Amount in Reporting Currency
CreditAmountInReportingCrcy Credit Amount in Reporting Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
GLAccountLongName G/L Account Long Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
FiscalPeriod Fiscal Period POPER
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == T003.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETS2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == SKA1.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETS2.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_MX_JRNLENTRAGGREGATEDDETS2.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETS2.CHARTOFACCOUNTS == T004.KTOPL
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETS2.COMPANYCODE == T001.BUKRS
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETS2.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == TCURC.MANDT
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_MX_JRNLENTRAGGREGATEDDETS2.MANDT == T004.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETS2.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger