C_JrnlEntrItmAmtAbvThld

JE Item Amount above Threshold | view: CGRCJEIABOVETHLD | Extraction: Not supported | Component: Information System
Tables used: ACDOCA, BKPF, FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
JournalEntry Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Accounting Document Entry Date
DocumentDate Journal Entry Date
LastChangeDate Last Change Date
PostingDate Posting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
TransactionCode Transaction Code TCODE
DocumentReferenceID Document Reference ID XBLNR1
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ReverseDocument Reverse Document BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_JRNLENTRITMAMTABVTHLD.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_JRNLENTRITMAMTABVTHLD.MANDT == T003.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_JRNLENTRITMAMTABVTHLD.MANDT == T004.MANDT
  • C_JRNLENTRITMAMTABVTHLD.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_JRNLENTRITMAMTABVTHLD.MANDT == T001.MANDT
  • C_JRNLENTRITMAMTABVTHLD.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_JRNLENTRITMAMTABVTHLD.MANDT == TCURC.MANDT
  • C_JRNLENTRITMAMTABVTHLD.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_JRNLENTRITMAMTABVTHLD.MANDT == TKA01.MANDT
  • C_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • C_JRNLENTRITMAMTABVTHLD.[column in domain "DATBI"] == CSKS.DATBI
  • C_JRNLENTRITMAMTABVTHLD.MANDT == CSKS.MANDT
  • C_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == CSKS.KOKRS
  • C_JRNLENTRITMAMTABVTHLD.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • C_JRNLENTRITMAMTABVTHLD.MANDT == KNA1.MANDT
  • C_JRNLENTRITMAMTABVTHLD.CUSTOMER == KNA1.KUNNR
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_JRNLENTRITMAMTABVTHLD.FISCALYEARVARIANT == T009.PERIV
  • C_JRNLENTRITMAMTABVTHLD.MANDT == T009.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_JRNLENTRITMAMTABVTHLD.MANDT == SKB1.MANDT
  • C_JRNLENTRITMAMTABVTHLD.GLACCOUNT == SKB1.SAKNR
  • C_JRNLENTRITMAMTABVTHLD.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • C_JRNLENTRITMAMTABVTHLD.[column in domain "DATBI"] == CEPC.DATBI
  • C_JRNLENTRITMAMTABVTHLD.PROFITCENTER == CEPC.PRCTR
  • C_JRNLENTRITMAMTABVTHLD.MANDT == CEPC.MANDT
  • C_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type C_JRNLENTRITMAMTABVTHLD.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Client
  • Supplier
  • C_JRNLENTRITMAMTABVTHLD.MANDT == LFA1.MANDT
  • C_JRNLENTRITMAMTABVTHLD.SUPPLIER == LFA1.LIFNR