C_MX_JrnlEntryOperationalViewC

Journal Entries Items Cube | view: CMXJEDETAILSC | TRAN | 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
LedgerGLLineItem Ledger Journal Entry Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
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
AccountingDocumentCategory Journal Entry Category Show values
MX_ExternalPaymentMethod External Payment Method for Mexico Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
GLAccount G/L Account SAKNR
GLAccountLongName G/L Account Long Text TEXT50
DocumentItemText Item Text TEXT50
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentReferenceID Document Reference ID XBLNR1
FiscalPeriod Fiscal Period POPER
AssignmentReference Assignment Reference ZUONR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_MX_JRNLENTRYOPERATIONALVIEWC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == T003.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == T004.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == T001.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == TCURC.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == KNA1.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.CUSTOMER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == FINSC_LEDGER.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRYOPERATIONALVIEWC.LEDGER == FINSC_LEDGER.RLDNR
Payment Method
  • ?
  • Payment Method
  • Client
  • C_MX_JRNLENTRYOPERATIONALVIEWC.[column in domain "LAND1"] == T042Z.LAND1
  • C_MX_JRNLENTRYOPERATIONALVIEWC.PAYMENTMETHOD == T042Z.ZLSCH
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == T042Z.MANDT
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == FINSC_LEDGER.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • C_MX_JRNLENTRYOPERATIONALVIEWC.LEDGER == FINSC_LEDGER.RLDNR
Reporting Entity
  • Reporting Entity
  • Client
  • C_MX_JRNLENTRYOPERATIONALVIEWC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == SRF_RPG_ENT.MANDT
Supplier
  • Client
  • Supplier
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == LFA1.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • C_MX_JRNLENTRYOPERATIONALVIEWC.MANDT == T007A.MANDT
  • C_MX_JRNLENTRYOPERATIONALVIEWC.[column in domain "KALSM_D"] == T007A.KALSM
  • C_MX_JRNLENTRYOPERATIONALVIEWC.TAXCODE == T007A.MWSKZ