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

Here we would like to draw your attention to DFKKTAX_EXEMPT 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). DFKKTAX_EXEMPT 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 DFKKTAX_EXEMPT table

Table DFKKTAX_EXEMPT technical data

TableDFKKTAX_EXEMPT
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 DFKKTAX_EXEMPT 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 DFKKTAX_EXEMPT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • EXKEY : Key Value For Tax Exemption
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • 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 certificate
    Its data type is CHAR (Character String) with field length 15
  • EXRAT : Exemption rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • 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