C_MX_AuxiliaryRptAcctDetailQ

MX Auxiliary Report for Accounts Details Query | view: CMXAUXACCTDETQ | Extraction: Not supported | Component: Financials Mexico
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
GLAccount FK G/L Account
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Reporting Currency (ReportingCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AmountInTransactionCurrency Amount in Transaction Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
AmountInGlobalCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
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
GLAccountType Type of a General Ledger Account Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentItem Journal Entry Posting View Item BUZEI
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == T003.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Alternative G/L Account Number In Company Code
  • ?
  • Alternative G/L Account Number In Company Code
  • Client
  • C_MX_AUXILIARYRPTACCTDETAILQ.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_MX_AUXILIARYRPTACCTDETAILQ.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == SKA1.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_MX_AUXILIARYRPTACCTDETAILQ.CHARTOFACCOUNTS == T004.KTOPL
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == T001.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • C_MX_AUXILIARYRPTACCTDETAILQ.CUSTOMER == KNA1.KUNNR
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == KNA1.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == T856.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == T009.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FISCALYEARVARIANT == T009.PERIV
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_MX_AUXILIARYRPTACCTDETAILQ.GLACCOUNT == SKB1.SAKNR
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == SKB1.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Reporting Entity
  • Client
  • Reporting Entity
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == SRF_RPG_ENT.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == LFA1.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_MX_AUXILIARYRPTACCTDETAILQ.MANDT == TCURC.MANDT
  • C_MX_AUXILIARYRPTACCTDETAILQ.TRANSACTIONCURRENCY == TCURC.WAERS