C_MX_JrnlEntrItmInvcDetailsC

Journal Entries Items with Invoices Cube | view: CMXJEINVDETC | 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
AccountingDocument Journal Entry
FiscalYear Fiscal Year
GLAccount G/L Account
DocumentItemText Item Text
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency null
Column Name Description
Column Name Description
ClearingDate Clearing Date
PostingDate Posting Date in the Document
Column Name Description
MX_ExternalPaymentMethod External Payment Method for Mexico Show values
CompensationType Compensation Type Show values
Column Name Description Domain name
ClearingAccountingDocument Document Number of the Clearing Document BELNR
DocumentReferenceID Document Reference ID XBLNR1
ElectronicInvoiceUUID Mexico Compensation UUID for Electronic Accounting
Country Country/Region Key LAND1
TaxNumber1 Tax Number 1 STCD1
InvoiceReferenceFiscalYear Fiscal Year FIS_GJAHR_NO_CONV
AccountingDocumentType Document Type BLART
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
FinancialAccountType null
ExchangeRate null
LedgerGLLineItem null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_MX_JRNLENTRITMINVCDETAILSC.COMPANYCODE == T001.BUKRS
  • C_MX_JRNLENTRITMINVCDETAILSC.MANDT == T001.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Reporting Entity
  • Client
  • Reporting Entity
  • C_MX_JRNLENTRITMINVCDETAILSC.MANDT == SRF_RPG_ENT.MANDT
  • C_MX_JRNLENTRITMINVCDETAILSC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Transaction Currency
  • Client
  • Transaction Currency
  • C_MX_JRNLENTRITMINVCDETAILSC.MANDT == TCURC.MANDT
  • C_MX_JRNLENTRITMINVCDETAILSC.TRANSACTIONCURRENCY == TCURC.WAERS