C_MX_AuxiliaryRptAcctDetailC

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