I_SAFTJournalItem

SAF-T Journal Ledger Entry Item | view: IPTJRNLENTRYI | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: ACDOCABKPFBSEGT001TKA02T005T001T014FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument 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
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
AccountingDocumentCreationDate Accounting Document Entry Date
CreationTime Creation Time
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
Column Name Description Domain name
DocumentItemText Item Text TEXT50
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocument Reference document number AWREF
AccountingDocumentItem Journal Entry Posting View Item BUZEI
CostCenter Cost Center KOSTL
PersonnelNumber Personnel Number PERNR
WBSElement WBS Element FIS_WBS
TransactionTypeDetermination Transaction Key CHAR3
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ReversalReferenceDocument Reversal Reference Document AWREF
BillingDocument Billing Document VBELN
AccountingDocumentItemType Identification of the Line Item CHAR1
PaymentReference Payment Reference CHAR30
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
DocumentReferenceID null
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_SAFTJOURNALITEM.MANDT == T004.MANDT
  • I_SAFTJOURNALITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_SAFTJOURNALITEM.MANDT == T001.MANDT
  • I_SAFTJOURNALITEM.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_SAFTJOURNALITEM.MANDT == TKA01.MANDT
  • I_SAFTJOURNALITEM.CONTROLLINGAREA == TKA01.KOKRS
Country/Region Key
  • Client
  • Country/Region Key
  • I_SAFTJOURNALITEM.MANDT == T005.MANDT
  • I_SAFTJOURNALITEM.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_SAFTJOURNALITEM.MANDT == KNA1.MANDT
  • I_SAFTJOURNALITEM.CUSTOMER == KNA1.KUNNR
G/L Account
  • G/L Account
  • Client
  • ?
  • I_SAFTJOURNALITEM.GLACCOUNT == SKB1.SAKNR
  • I_SAFTJOURNALITEM.MANDT == SKB1.MANDT
  • I_SAFTJOURNALITEM.[column in domain "BUKRS"] == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Order ID
  • Client
  • I_SAFTJOURNALITEM.ORDERID == AUFK.AUFNR
  • I_SAFTJOURNALITEM.MANDT == AUFK.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Supplier
  • Client
  • I_SAFTJOURNALITEM.SUPPLIER == LFA1.LIFNR
  • I_SAFTJOURNALITEM.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_SAFTJOURNALITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_SAFTJOURNALITEM.[column in domain "KAPPL"] == T683.KAPPL
  • I_SAFTJOURNALITEM.MANDT == T683.MANDT
  • I_SAFTJOURNALITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_SAFTJOURNALITEM.TAXCODE == T007A.MWSKZ
  • I_SAFTJOURNALITEM.MANDT == T007A.MANDT
  • I_SAFTJOURNALITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
Transaction Currency
  • Transaction Currency
  • Client
  • I_SAFTJOURNALITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SAFTJOURNALITEM.MANDT == TCURC.MANDT