I_AccountingDocument

Accounting Document | view: IFIACCDOC | ATTR | Extraction: Not supported | 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
LastChangeDate Last Change Date
ExchangeRateDate Exchange Rate Date
InvoiceReceiptDate Invoice Receipt Date
TaxReportingDate Tax Reporting Date
ParkingDate Day of Parking of Accounting Document
ParkingTime Time of Parking
Column Name Description
AccountingDocumentCategory Document Status Show values
IsDiscountDocument Indicator: entry represents a discount document Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
TaxIsCalculatedAutomatically Calculate Tax Automatically 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 Reference Document Number XBLNR1
RecurringAccountingDocument Recurring Journal Entry BELNR
ReverseDocument Reverse Document Number BELNR
ReverseDocumentFiscalYear Fiscal Year of Reversal Document GJAHR
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate UKURS
BusinessTransactionType Business Transaction Category FINS_BTTYPE
BatchInputSession Batch Input Session Name CHAR12
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
FinancialManagementArea Financial Management Area FIKRS
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
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 Number XBLNR_ALT
NmbrOfPages Number of pages of invoice J_1ANOPG
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_ACCOUNTINGDOCUMENT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_ACCOUNTINGDOCUMENT.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • I_ACCOUNTINGDOCUMENT.MANDT == T001.MANDT
  • I_ACCOUNTINGDOCUMENT.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • I_ACCOUNTINGDOCUMENT.CURRENCY == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENT.MANDT == TCURC.MANDT
Currency Key for the Group Currency
  • Currency Key for the Group Currency
  • Client
  • I_ACCOUNTINGDOCUMENT.GROUPCURRENCY == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENT.MANDT == TCURC.MANDT
Ledger Group
  • Ledger Group
  • Client
Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • Client
  • I_ACCOUNTINGDOCUMENT.REVERSALREASON == T041C.STGRD
  • I_ACCOUNTINGDOCUMENT.MANDT == T041C.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Ledger
  • Client
  • Company Code