DFKKTAXEX SAP table for – Table of FI-CA Tax Exemptions

Here we would like to draw your attention to DFKKTAXEX table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKTAXEX is a SAP standard transp table used for storing Table of FI-CA Tax Exemptions related data in SAP. It comes under the package FKKB.

SAP DFKKTAXEX table

Table DFKKTAXEX technical data

TableDFKKTAXEX
Data storingTable of FI-CA Tax Exemptions
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKTAXEX Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in DFKKTAXEX table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VKONT : Contract Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • MWSKZ : Tax on sales/purchases code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • KSCHL : Condition Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • EXDFR : Start date of exemption
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXDTO : End date of exemption
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXNUM : Number of Exemption Licence
    Its data type is CHAR (Character String) with field length 15
  • EXRAT : Tax-Exempt Amount Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • LAUFD : Date ID
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Additional Identification Characteristic
    Its data type is CHAR (Character String) with field length 6