I_JournalEntry

Journal Entry | view: IFIJOURNALENT | ATTR | Extraction: Full or Incremental | Component: Information System
Tables used: BKPF
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
Column Name Description
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
AccountingDocumentCreationDate Accounting Document Entry Date
CreationTime Creation Time
LastManualChangeDate Calendar date of the last manual change in document
LastAutomaticChangeDate Calendar date of the last automatic change in document
LastChangeDate Last Change Date
ExchangeRateDate Exchange Rate Date
PlannedReversalDate Planned Date for the Reversal Posting
ParkingDate Day of Parking of Accounting Document
ParkingTime Time of Parking
InvoiceReceiptDate Invoice Receipt Date
TaxReportingDate Tax Reporting Date
TaxFulfillmentDate Tax Fulfillment Date
CostAccountingValuationDate Special Valuation Date for Cost Accounting
JrnlEntryCntrySpecificDate1 Country/Region Specific Date 1 in the Document
JrnlEntryCntrySpecificDate2 Country/Region Specific Date 2 in the Document
JrnlEntryCntrySpecificDate3 Country/Region Specific Date 3 in the Document
JrnlEntryCntrySpecificDate4 Country/Region Specific Date 4 in the Document
JrnlEntryCntrySpecificDate5 Country/Region Specific Date 5 in the Document
WithholdingTaxReportingDate Withholding Tax Reporting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
NetAmountIsPosted Net Amount Is Posted Show values
ReversalIsPlanned Indicator: Reversal Is Planned for Document Show values
TaxIsCalculatedAutomatically Tax Is Automatically Calculated Show values
AdditionalCurrency1Role Currency Type of Second Local Currency Show values
AdditionalCurrency2Role Currency Type of Third Local Currency Show values
TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount Show values
IsDiscountDocument Indicator: entry represents a discount document Show values
AccountingDocumentClass Accounting Document Class Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsBudgetaryLedgerDoc Budgetary Ledger Indicator Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
AccountingDocCreatedByUser User that created the journal entry
TransactionCode Transaction Code TCODE
IntercompanyTransaction Intercompany Transaction Number BVORG
DocumentReferenceID Document Reference ID XBLNR1
RecurringAccountingDocument Recurring Journal Entry BELNR
ReverseDocument Reverse Document BELNR
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate UKURS
BusinessTransactionType Business Transaction Category FINS_BTTYPE
BatchInputSession Batch Input Session CHAR12
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
FinancialManagementArea Financial Management Area FIKRS
LogicalSystem Logical System LOGSYS
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
TaxExchangeRate Tax Exchange Rate KURSF
ParkedByUser Name of User Who Parked This Document XUBNAME
NmbrOfPages Number of pages of invoice J_1ANOPG
Reference1InDocumentHeader Internal ID of Reference Key 1 in Document Header CHAR20
Reference2InDocumentHeader Internal ID of Reference Key 2 in Document Header CHAR20
AlternativeReferenceDocument Alternative Reference Document XBLNR_ALT
SenderLogicalSystem Sender Logical System LOGSYS
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
ReversalReferenceDocumentCntxt Reversal: Reference Organizations of Document to Be Reversed AWORG
ReversalReferenceDocument Reversal: Reference Document No. of Document to Be Reversed AWREF
LatePaymentReason Late Payment Reason CHAR2
SalesDocumentCondition Sales Document Condition KNUMV
JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
JrnlEntryCntrySpecificRef2 Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
JrnlEntryCntrySpecificRef3 Country/Region Specific Reference 3 in the Document FAC_GLO_REF3_HD
JrnlEntryCntrySpecificRef4 Country/Region Specific Reference 4 in the Document FAC_GLO_REF4_HD
JrnlEntryCntrySpecificRef5 Country/Region Specific Reference 5 in the Document FAC_GLO_REF5_HD
JrnlEntryCntrySpecificBP1 Country/Region specific Business Partner 1 in the Document BU_PARTNER
JrnlEntryCntrySpecificBP2 Country/Region Specific Business Partner 2 in the Document BU_PARTNER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_JOURNALENTRY.MANDT == T003.MANDT
  • I_JOURNALENTRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • I_JOURNALENTRY.COMPANYCODE == T001.BUKRS
  • I_JOURNALENTRY.MANDT == T001.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_JOURNALENTRY.MANDT == TCURV.MANDT
  • I_JOURNALENTRY.EXCHANGERATETYPE == TCURV.KURST
Ledger Group
  • Client
  • Ledger Group
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • I_JOURNALENTRY.MANDT == T041C.MANDT
  • I_JOURNALENTRY.REVERSALREASON == T041C.STGRD
Source Company Code
  • Client
  • Source Company Code
  • I_JOURNALENTRY.MANDT == T001.MANDT
  • I_JOURNALENTRY.SOURCECOMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_JOURNALENTRY.MANDT == TCURC.MANDT
  • I_JOURNALENTRY.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Company Code
  • Client
  • Ledger