FIWTIN_TAN_EXEM SAP table for – Table for mapping TAN and Exemption Number

Here we would like to draw your attention to FIWTIN_TAN_EXEM table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). FIWTIN_TAN_EXEM is a SAP standard transp table used for storing Table for mapping TAN and Exemption Number related data in SAP. It comes under the package J1ICIN30A.

SAP FIWTIN_TAN_EXEM table

Table FIWTIN_TAN_EXEM technical data

TableFIWTIN_TAN_EXEM
Data storingTable for mapping TAN and Exemption Number
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1ICIN30A
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FIWTIN_TAN_EXEM 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 FIWTIN_TAN_EXEM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • KOART : Account type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ACCNO : Vendor/customer account number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • FIWTIN_TANEX_SUB : Indicator: Subject to TAN exemption?
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SECCODE : Section Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • WITHT : Indicator for withholding tax type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • WT_WITHCD : Withholding tax code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • WT_EXNR : Exemption certificate number
    Its data type is CHAR (Character String) with field length 15
  • WT_EXRT : Exemption rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WT_EXDF : Date on which exemption begins
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WT_EXDT : Date on which exemption ends
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WT_WTEXRS : Reason for exemption
    Its data type is CHAR (Character String) with field length 2
  • FIWTIN_EXEM_THR : Threshold amount for Exemption (India)
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5