P_MX_JrnlEntrAggregatedDetails

Mexico Journal Entry Aggregated Details | view: PMXJRNLENTAGGR | Extraction: Not supported | Component: Financials Mexico
Tables used: ACDOCABKPFBSEGPROJPRPST001T014FINSC_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 FK 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
DocumentReferenceID Document Reference ID XBLNR1
FiscalPeriod Fiscal Period POPER
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative G/L Account Number In Company Code
  • P_MX_JRNLENTRAGGREGATEDDETAILS.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == SKA1.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETAILS.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.CHARTOFACCOUNTS == T004.KTOPL
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.COMPANYCODE == T001.BUKRS
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == TCURC.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == T004.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_MX_JRNLENTRAGGREGATEDDETAILS.GLACCOUNT == SKB1.SAKNR
  • P_MX_JRNLENTRAGGREGATEDDETAILS.COMPANYCODE == SKB1.BUKRS
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == FINSC_LEDGER.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETAILS.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_MX_JRNLENTRAGGREGATEDDETAILS.LEDGER == FINSC_LEDGER.RLDNR
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • P_MX_JRNLENTRAGGREGATEDDETAILS.MANDT == FINSC_LEDGER.MANDT
  • P_MX_JRNLENTRAGGREGATEDDETAILS.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_MX_JRNLENTRAGGREGATEDDETAILS.LEDGER == FINSC_LEDGER.RLDNR