The CFIN_ACCIT_WT table in SAP ERP or S/4HANA stores CFIN Withholding tax data. There are total 56 fields in CFIN_ACCIT_WT table. The CFIN Withholding tax table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CFIN_ACCIT_WT table. It is in Central Finance ΓÇô Integration (FIN_CFIN_INTEGRATION) ABAP package and is part of the Infrastructure, Tools, Mapping Framework (FI-CF-INF) module.
SAP CFIN_ACCIT_WT Table Fields
Following is the list of fields that are available in SAP CFIN_ACCIT_WT table. The primary key fields of the table are CLIENT (Client), ACC_WT_KEY (Grouping Key for Withholding Tax Information), ACC_WITHT (Indicator for Withholding Tax Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| ACC_WT_KEY | Grouping Key for Withholding Tax Information | WT_KEY | NUMC (6) | |
| ACC_WITHT | Indicator for Withholding Tax Type | WITHT | CHAR (2) | |
| WT_KEY | Grouping Key for Withholding Tax Information | WT_KEY | NUMC (6) | |
| WITHT | Indicator for Withholding Tax Type | WITHT | * | CHAR (2) |
| WT_WITHCD | Withholding Tax Code | WT_WITHCD | * | CHAR (2) |
| WT_QSSHH | Withholding Tax Base Amount (Local Currency) | WT_BS | CURR (23) | |
| WT_QSSHB | Withholding Tax Base Amount in Document Currency | WT_BS1 | CURR (23) | |
| WT_QSSH2 | Withholding Tax Base Amount in Second Local Currency | WT_BS2 | CURR (23) | |
| WT_QSSH3 | Withholding Tax Base Amount in Third Local Currency | WT_BS3 | CURR (23) | |
| WT_QBUIHH | Withholding Tax Amount Entered Manually in Local Currency | WT_QBUIHH | CURR (23) | |
| WT_QBUIHB | Withholding Tax Amount Entered Manually in Document Currency | WT_QBUIHB | CURR (23) | |
| WT_QBUIH2 | Withholding Tax Amount Entered Manually in 2nd Local Curr. | WT_QBUIH2 | CURR (23) | |
| WT_QBUIH3 | Withholding Tax Amount Entered Manually in 3rd Local Curr. | WT_QBUIH3 | CURR (23) | |
| WT_WDMBTR | Withholding Tax Amount Already Withheld in Local Currency | WT_AWT | CURR (23) | |
| WT_WWRBTR | Withholding Tax Amount Already Withheld in Document Currency | WT_AWT1 | CURR (23) | |
| WT_WDMBT2 | Withholding tax amount already withheld in 2nd local curr. | WT_AWT2 | CURR (23) | |
| WT_WDMBT3 | Withholding Tax Amt Already Withheld in 3rd Local Currency | WT_AWT3 | CURR (23) | |
| WT_BASMAN | Indicator: Withholding Tax Base Amount Entered Manually | WT_BASMAN | CHAR (1) | |
| WT_AMNMAN | Indicator: Withholding Tax Amount Entered Manually | WT_AMNMAN | CHAR (1) | |
| WT_QBSHH | Withholding Tax Amount in Local Currency | WT_WT | CURR (23) | |
| WT_QBSHB | Withholding Tax Amount in Document Currency | WT_WT1 | CURR (23) | |
| WT_QBSH2 | Withholding Tax Amount in Second Local Currency | WT_WT2 | CURR (23) | |
| WT_QBSH3 | Withholding Tax Amount in Third Local Currency | WT_WT3 | CURR (23) | |
| WT_QBSHHA | Withholding Tax Auxiliary Amount in Local Crcy for Reversal | WT_WTA | CURR (23) | |
| WT_QBSHHB | Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal | WT_WTB | CURR (23) | |
| WT_STAT | Line Item Status | WT_STAT | CHAR (1) | |
| WT_QSFHH | Amount Exempt from Withholding Tax in Local Currency | WT_EXMP | CURR (23) | |
| WT_QSFHB | Amount Exempt from Withholding Tax in Document Currency | WT_EXMP1 | CURR (23) | |
| WT_QSFH2 | Amount Exempt from Withholding Tax in 2nd Local Currency | WT_EXMP2 | CURR (23) | |
| WT_QSFH3 | Amount Exempt from Withholding Tax in 3rd Local Currency | WT_EXMP3 | CURR (23) | |
| WT_WTEXMN | Exemption Certificate Number | WT_EXNR | CHAR (25) | |
| KOART | Account type | KOART | CHAR (1) | |
| WT_ACCO | Vendor/Customer Account Number | WT_ACNO | CHAR (10) | |
| HKONT | General Ledger Account | HKONT | * | CHAR (10) |
| HKONT_OPP | General Ledger Account | HKONT | * | CHAR (10) |
| QSREC | Type of Recipient | WT_QSREC | * | CHAR (2) |
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR (10) | |
| AUGDT | Clearing Date | AUGDT | DATS (8) | |
| WT_QSZRT | Exemption Rate | WT_EXRT | DEC (5) | |
| TEXT15 | Text (15 characters) | TEXT15 | CHAR (15) | |
| QSATZ | Withholding Tax Rate | WT_QSATZ | DEC (7) | |
| WT_SLFWTPD | Indicator: Entry Posted as Self-Withholding Tax | WT_SLFWTPD | CHAR (1) | |
| WT_GRUWTPD | Indicator: Entry Posted as “Grossing Up” | WT_GRUWTPD | CHAR (1) | |
| WT_OPOWTPD | Indicator: Entry Posted as Debit/Credit | WT_OPOWTPD | CHAR (1) | |
| WT_GIVENPD | Indicator: Withholding Tax Amount Entered Manually with Payt | WT_GIVENPD | CHAR (1) | |
| CTNUMBER | Withholding Tax Certificate Number | CTNUMBER | CHAR (10) | |
| WT_DOWNC | Indicator: Entry Belongs to a Down Payment Clearing Item | WT_DOWNC | CHAR (1) | |
| WT_RESITEM | Indicator: Entry Belongs to a Residual Item | WT_RESITEM | CHAR (1) | |
| CTISSUEDATE | Issue or Print Date of Withholding Tax Certificate | CTISSUEDATE | DATS (8) | |
| WT_CALC | Withholding Tax Already Calculated/Determined? | WT_CALC | CHAR (2) | |
| WT_LOGSYS | Logical System in Which the Withholding Tax Was Calculated | WT_LOGSYS | * | CHAR (10) |
| BUKRS_REF | Company Code | BUKRS | CHAR (4) | |
| BELNR_REF | Accounting Document Number | BELNR_D | CHAR (10) | |
| GJAHR_REF | Fiscal Year | GJAHR | NUMC (4) | |
| BUZEI_REF | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) |
