The DFKKQSR table in SAP ERP or S/4HANA stores Individual Records for Withholding Tax Report data. There are total 27 fields in DFKKQSR table. The Individual Records for Withholding Tax Report 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 DFKKQSR table. It is in Contract A/R & A/P: Central Objects (FKKB) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKQSR Table Fields
Following is the list of fields that are available in SAP DFKKQSR table. The primary key fields of the table are MANDT (Client), OPBEL (Number of a FI-CA Document), OPUPQ (Item Number In Reporting File For Withholding Tax).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| OPUPQ | Item Number In Reporting File For Withholding Tax | OPUPQ_KK | NUMC (4) | |
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS (8) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| HKONT | General ledger account | HKONT_KK | CHAR (10) | |
| GSBER | Business Area | GSBER | TGSB | CHAR (4) |
| BUPLA | Business Place | BUPLA | CHAR (4) | |
| PRCTR | Profit Center | PRCTR | CHAR (10) | |
| QSSKZ | Withholding Tax Code | QSSKZ | T059Q | CHAR (2) |
| QSSEW | Withholding Tax Supplement | QSSEW_KK | TFK059E | CHAR (2) |
| QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR (10) | |
| QSATZ | Additional Withholding Tax Rate | QSATZ_KK | DEC (4) | |
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR (13) | |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR (13) | |
| SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | SBASH_KK | CURR (13) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| HWAER | Local Currency | HWAER | CUKY (5) | |
| GPART | Business Partner Number | GPART_KK | CHAR (10) | |
| VKONT | Contract Account Number | VKONT_KK | CHAR (12) | |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR (20) | |
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR (1) | |
| KTOSL | Transaction key for account determination | KTOSL_KK | CHAR (3) | |
| XALLA | Withholding Tax Amount Can Be Entered in Document | XALLA_WH_KK | CHAR (1) | |
| PRLQS | Provisional Withholding Tax of Open Item in Local Currency | PRLQS_KK | CURR (13) | |
| PRLPZ | Provisional Percentage Rate for Withholding Tax | ORIPZ_KK | DEC (4) |
