DFKKQSR SAP table for – Individual Records for Withholding Tax Report

Here we would like to draw your attention to DFKKQSR 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). DFKKQSR is a SAP standard transp table used for storing Individual Records for Withholding Tax Report related data in SAP. It comes under the package FKKB.

SAP DFKKQSR table

Table DFKKQSR technical data

TableDFKKQSR
Data storingIndividual Records for Withholding Tax Report
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • OPUPQ : Item Number In Reporting File For Withholding Tax
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • QSSEW : Withholding Tax Supplement
    Its data type is CHAR (Character String) with field length 2
  • QSZNR : Certificate Number of the Withholding Tax Exemption
    Its data type is CHAR (Character String) with field length 10
  • QSATZ : Additional Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • SBASH : Amount Subject to Tax in Local Currency (Tax Base Amount)
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • SUBAP : Subapplication in Contract Accounts Receivable and Payable
    Its data type is CHAR (Character String) with field length 1
  • KTOSL : Transaction key for account determination
    Its data type is CHAR (Character String) with field length 3