0FI_TX_4

Taxes: Line Items by Means of Delta Extraction | #TRAN | Extraction method: F1 | Delta: AIE | Component: Financial Accounting: General Ledger
Tables used: BKPFT001GLFUNCTKNKAKNB4 ... +2 more
Column Name Description
BUKRS Company Code
BELNR Accounting Document Number
KUNNR Customer Number
GJAHR Fiscal Year
MANDT Client
Column Name Description
💲 Condition Unit (Currency or Percentage) (KONWA):
PSATZ Tax Rate
KBETR Condition amount or percentage where no scale exists
💲 Currency Key (MLDWAER):
HWBAS Tax Base Amount in Local Currency
HWSTE Tax Amount in Local Currency
LWBAS Tax Base in Reporting Currency
LWSTE Tax Amount in Reporting Currency
💲 Currency Key (WAERS):
FWBAS Tax Base Amount in Document Currency
FWSTE Tax Amount in Document Currency
💲 Currency Key of Second Local Currency (HWAE2):
H2BAS Tax Base Amount in Local Currency 2
H2STE Tax Amount in Local Currency 2
💲 Currency Key of Third Local Currency (HWAE3):
H3BAS Tax Base Amount in Local Currency 3
H3STE Tax Amount in Local Currency 3
Column Name Description
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
VATDATE Tax Reporting Date
Column Name Description
STMELDETYP Control Message Type Show values
MARK_NAF Selection of Non-Deductible Input Tax Show values
XEGDR Indicator: Triangular Deal Within the EU Show values
EGRKZ EU Code/Code Show values
STGRP Tax type Show values
SHKZG Debit/Credit Indicator Show values
Column Name Description Domain name
UMKRS Taxes on Sales/Purchases Group UMKRS
FISCPER Fiscal year / period RSFISCPER
FISCVAR Fiscal year variant RSFISCVAR
BUZEI Number of Line Item Within Accounting Document BUZEI
KTOPL Chart of Accounts KTOPL
BLART Document Type BLART
XBLNR Reference Document Number XBLNR
VATTAXGROUP Group Number for Tax Amounts NUM2
TKONT General Ledger Account SAKNR
LOHNIND Subcontracting Indicator TEXT1
STCEG VAT Registration Number STCEG
LIFNR Account Number of Supplier LIFNR
LSTML Country/Region for Tax Report LAND1
BUPLA Business Place J_1BBRANCH
EGBLD Country/Region of Destination for Delivery of Goods LAND1
EGLLD Supplying Country/Region for Delivery of Goods LAND1
KSCHL Condition Type KSCHL
TXGRP Group Indicator for Tax Line Items NUM03
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
HKONT General Ledger Account SAKNR
KTOSL Transaction Key CHAR3
MONAT Fiscal period MONAT
MWSKZ Tax on sales/purchases code MWSKZ