P_JrnlEntrItmAmtAbvThld

JE Item Amount above Threshold | view: PGRCJEIABOVETHLD | 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):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
NegDebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
NegCreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
LastChangeDate Last Change 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
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
TransactionCode Transaction Code TCODE
ReverseDocument Reverse Document BELNR
DocumentReferenceID Document Reference ID XBLNR1
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_JRNLENTRITMAMTABVTHLD.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_JRNLENTRITMAMTABVTHLD.MANDT == T003.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_JRNLENTRITMAMTABVTHLD.CHARTOFACCOUNTS == T004.KTOPL
  • P_JRNLENTRITMAMTABVTHLD.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_JRNLENTRITMAMTABVTHLD.COMPANYCODE == T001.BUKRS
  • P_JRNLENTRITMAMTABVTHLD.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_JRNLENTRITMAMTABVTHLD.COMPANYCODECURRENCY == TCURC.WAERS
  • P_JRNLENTRITMAMTABVTHLD.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == TKA01.KOKRS
  • P_JRNLENTRITMAMTABVTHLD.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • P_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == CSKS.KOKRS
  • P_JRNLENTRITMAMTABVTHLD.COSTCENTER == CSKS.KOSTL
  • P_JRNLENTRITMAMTABVTHLD.[column in domain "DATBI"] == CSKS.DATBI
  • P_JRNLENTRITMAMTABVTHLD.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • P_JRNLENTRITMAMTABVTHLD.CUSTOMER == KNA1.KUNNR
  • P_JRNLENTRITMAMTABVTHLD.MANDT == KNA1.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_JRNLENTRITMAMTABVTHLD.FISCALYEARVARIANT == T009.PERIV
  • P_JRNLENTRITMAMTABVTHLD.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_JRNLENTRITMAMTABVTHLD.GLACCOUNT == SKB1.SAKNR
  • P_JRNLENTRITMAMTABVTHLD.COMPANYCODE == SKB1.BUKRS
  • P_JRNLENTRITMAMTABVTHLD.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • P_JRNLENTRITMAMTABVTHLD.CONTROLLINGAREA == CEPC.KOKRS
  • P_JRNLENTRITMAMTABVTHLD.PROFITCENTER == CEPC.PRCTR
  • P_JRNLENTRITMAMTABVTHLD.[column in domain "DATBI"] == CEPC.DATBI
  • P_JRNLENTRITMAMTABVTHLD.MANDT == CEPC.MANDT
Reference Document Type P_JRNLENTRITMAMTABVTHLD.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Supplier
  • Client
  • P_JRNLENTRITMAMTABVTHLD.SUPPLIER == LFA1.LIFNR
  • P_JRNLENTRITMAMTABVTHLD.MANDT == LFA1.MANDT