I_SAFTJournalLineItem

SAF-T Journal Item | view: ISAFTJOURNALITM | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: VBRK, VBRP, ACDOCA, BKPF, BSEG, CFIN_AV_CI_ROOT, CFIN_AV_CI_ITEM, CFIN_AV_CI_ROOT, T001, TKA02, T005, SKB1, T001, T014, FINSC_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
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Quantity Quantity
Column Name Description
PostingDate Posting Date
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
ReconciliationAccountType Account is Reconciliation Account Show values
Column Name Description Domain name
ReferenceDocument Reference document number AWREF
DocumentItemText Item Text TEXT50
ReversalReferenceDocument Reversal Reference Document AWREF
TransactionTypeDetermination Transaction Key CHAR3
ReferenceSDDocument Document number of the reference document VBELN
PersonnelNumber Personnel Number PERNR
WBSElement WBS Element FIS_WBS
AccountingDocumentItem Journal Entry Posting View Item BUZEI
SalesDocumentItem Sales Document Item POSNR
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
PaymentReference null
BillingDocument null
CashDiscount2Days Cash Discount Days 2 ZBDXT
CashDiscount1Days Cash Discount Days 1 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
AccountingDocumentItemType Identification of the Line Item CHAR1
DocumentReferenceID Document Reference ID XBLNR1
CentralFinanceBillingDocument Central Finance Billing Document VBELN
CentralFinanceSalesDocument Central Finance Sales Document VBELN
ExchangeRate Exchange Rate
ReferenceDocumentContext Reference Document Context AWORG
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_SAFTJOURNALLINEITEM.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_SAFTJOURNALLINEITEM.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_SAFTJOURNALLINEITEM.MANDT == SKA1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_SAFTJOURNALLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • I_SAFTJOURNALLINEITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_SAFTJOURNALLINEITEM.COMPANYCODE == T001.BUKRS
  • I_SAFTJOURNALLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_SAFTJOURNALLINEITEM.MANDT == TCURC.MANDT
  • I_SAFTJOURNALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_SAFTJOURNALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_SAFTJOURNALLINEITEM.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • I_SAFTJOURNALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • I_SAFTJOURNALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • I_SAFTJOURNALLINEITEM.MANDT == CSKS.MANDT
  • I_SAFTJOURNALLINEITEM.COSTCENTER == CSKS.KOSTL
Country/Region Key
  • Country/Region Key
  • Client
  • I_SAFTJOURNALLINEITEM.COUNTRY == T005.LAND1
  • I_SAFTJOURNALLINEITEM.MANDT == T005.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_SAFTJOURNALLINEITEM.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_SAFTJOURNALLINEITEM.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • I_SAFTJOURNALLINEITEM.CUSTOMER == KNA1.KUNNR
  • I_SAFTJOURNALLINEITEM.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_SAFTJOURNALLINEITEM.GLACCOUNT == SKB1.SAKNR
  • I_SAFTJOURNALLINEITEM.COMPANYCODE == SKB1.BUKRS
  • I_SAFTJOURNALLINEITEM.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Logical System I_SAFTJOURNALLINEITEM.LOGICALSYSTEM == TBDLS.LOGSYS
Order ID
  • Order ID
  • Client
  • I_SAFTJOURNALLINEITEM.ORDERID == AUFK.AUFNR
  • I_SAFTJOURNALLINEITEM.MANDT == AUFK.MANDT
Reference Document Type I_SAFTJOURNALLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • Account Type
  • I_SAFTJOURNALLINEITEM.SPECIALGLCODE == T074U.UMSKZ
  • I_SAFTJOURNALLINEITEM.MANDT == T074U.MANDT
  • I_SAFTJOURNALLINEITEM.FINANCIALACCOUNTTYPE == T074U.KOART
Supplier
  • Supplier
  • Client
  • I_SAFTJOURNALLINEITEM.SUPPLIER == LFA1.LIFNR
  • I_SAFTJOURNALLINEITEM.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • I_SAFTJOURNALLINEITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_SAFTJOURNALLINEITEM.[column in domain "KAPPL"] == T683.KAPPL
  • I_SAFTJOURNALLINEITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_SAFTJOURNALLINEITEM.MANDT == T683.MANDT
Tax on Sales/Purchases Code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on Sales/Purchases Code
  • I_SAFTJOURNALLINEITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_SAFTJOURNALLINEITEM.MANDT == T007A.MANDT
  • I_SAFTJOURNALLINEITEM.TAXCODE == T007A.MWSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • I_SAFTJOURNALLINEITEM.MANDT == TCURC.MANDT
  • I_SAFTJOURNALLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS