SAP Reports / Programs

RFKQST20 SAP ABAP Report - Withholding Tax Report for the Vendor







RFKQST20 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program is relevant for the following countries: ,,,,France ,,,,Belgium Program RFKQST20 provides evaluations on sales subject to withholding tax for reporting to the vendor...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RFKQST20 into the relevant SAP transactions such as SE38 or SE80


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT RFKQST20. "Basic submit
SUBMIT RFKQST20 AND RETURN. "Return to original report after report execution complete
SUBMIT RFKQST20 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: ALTCURR = Alternative local currency
Selection Text: ALT_CTRY = Country in title
Selection Text: AUGDAT = Clearing date
Selection Text: BELART = Document type
Selection Text: BELNUM = Document number
Selection Text: BKRSUMME = Totals by company code
Selection Text: BUCHDT = Posting date
Selection Text: CONVDAT = Translation date
Selection Text: EINZELPO = Line items
Selection Text: FORMULAR = Form printout
Selection Text: KD_AUGDT = ?...(KD_AUGDT)
Selection Text: KTOSUMME = Total by vendor
Selection Text: LISTSEPA = Separate list
Selection Text: PROTOKOL = Log
Selection Text: P_ADRID = Address ID
Selection Text: P_FORID = Form ID
Selection Text: P_IMMEA = Print immediately
Selection Text: P_PRINT = Printer
Selection Text: P_VARIA = Country variant
Selection Text: P_ZAEHL = Consecutive account no. from
Selection Text: P_ZUTIT = Additional heading
Selection Text: QSTKZ = Withholding tax code
Selection Text: QSTSUMME = Totals per w/hld.tax type/code
Selection Text: SUMMENTB = Totals table
Selection Text: TESTDRCK = Number of sample printouts
Selection Text: UMRECHN = Exchange rate from invoice
Selection Text: UNAUSGEG = Also invoices not cleared
Selection Text: WITHT = Withholding tax type
Selection Text: KD_BUDAT = ?...(KD_BUDAT)
Selection Text: KD_BUKRS = ?...(KD_BUKRS)
Selection Text: KD_LIFNR = ?...(KD_LIFNR)
Selection Text: KD_STIDA = ?...(KD_STIDA)
Selection Text: KD_UMSKZ = ?...(KD_UMSKZ)
Selection Text: KD_ZUONR = ?...(KD_ZUONR)
Title: Withholding Tax Report for the Vendor
Text Symbol: 510 = Withholding tax code:
Text Symbol: 509 = With/tax type:
Text Symbol: 001 = Company Code





Text Symbol: 003 = WT code Withholding tax name Invoice amount Base amount Withholding tax Net amount Tax-exempt amnt
Text Symbol: 004 = P.no. Acct no. Tax number Address
Text Symbol: 005 = Po.dte Doc.no. Doc.dt.Reference no. Clg dt.WT code Invoice amnt Base amount Withhold.tax Net amount Tax-exempt amt
Text Symbol: 010 = Wthld.tax code:
Text Symbol: 011 = License number:
Text Symbol: 012 = Valid until:
Text Symbol: 013 = Licence has now expired
Text Symbol: 014 = Tax code:
Text Symbol: 015 = (One-time acct)
Text Symbol: 101 = Company Code
Text Symbol: 102 = Ref.No. Doc.No. PstDte DocDte WT Code Invoice Amount
Text Symbol: 105 = Reference no. Doc.No. Pstng Date Doc.Date WT Code WT Base Amount
Text Symbol: 106 = Withholding tax code
Text Symbol: 107 = Account number
Text Symbol: 111 = Logging the withholding tax report:
Text Symbol: 112 = Output in alternat. local currency:
Text Symbol: 200 = Male ,,
Text Symbol: 201 = Female ,,
Text Symbol: 202 = Born ,,
Text Symbol: 203 = in ,,
Text Symbol: 204 = on ,,
Text Symbol: 222 = Withholding Tax Report Variant & for Company Code
Text Symbol: 300 = Male ,,
Text Symbol: 301 = Female ,,
Text Symbol: 302 = Born ,,
Text Symbol: 303 = in ,,
Text Symbol: 304 = on ,,
Text Symbol: 400 = Log: Withhold.tax report for $
Text Symbol: 401 = Italy
Text Symbol: 402 = Spain
Text Symbol: 403 = France
Text Symbol: 404 = Belgium
Text Symbol: 407 = Czech Rep.
Text Symbol: 408 = Puerto Rico
Text Symbol: 409 = Mexico
Text Symbol: 410 = Colombia


INCLUDES used within this REPORT RFKQST20

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:






FI_WT_READ_WT_INFO CALL FUNCTION 'FI_WT_READ_WT_INFO' EXPORTING I_BUKRS = BSIK-BUKRS I_BELNR = BSIK-BELNR I_GJAHR = BSIK-GJAHR I_BUZEI = BSIK-BUZEI " Get WT data of complete doc.

CONVERT_TO_FOREIGN_CURRENCY CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY' EXPORTING DATE = CONVDAT FOREIGN_CURRENCY = ALTCURR LOCAL_AMOUNT = WDMBTR LOCAL_CURRENCY = T001-WAERS * rate = ??? TYPE_OF_RATE = 'M' IMPORTING FOREIGN_AMOUNT = WDMBTR.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = INV_DATE " Insert OSS 306375 FOREIGN_CURRENCY = CURR_INV LOCAL_CURRENCY = T001-WAERS FOREIGN_AMOUNT = BSIK-QSSHB * rate from tcurr RATE = RATE_INV " Insert OSS 306375 TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QSSHB.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = INV_DATE FOREIGN_AMOUNT = BSIK-QBSHB FOREIGN_CURRENCY = CURR_PAY LOCAL_CURRENCY = T001-WAERS RATE = RATE_INV TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QBSHB.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = INV_DATE FOREIGN_AMOUNT = BSIK-QBSHB FOREIGN_CURRENCY = CURR_PAY LOCAL_CURRENCY = T001-WAERS * rate from tcurr TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QBSHB.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = PAY_DATE FOREIGN_CURRENCY = CURR_INV LOCAL_CURRENCY = T001-WAERS FOREIGN_AMOUNT = BSIK-QSSHB RATE = RATE_PAY TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QSSHB.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = PAY_DATE FOREIGN_CURRENCY = CURR_INV LOCAL_CURRENCY = T001-WAERS FOREIGN_AMOUNT = BSIK-QSSHB * rate from tcurr TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QSSHB.

CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING DATE = PAY_DATE FOREIGN_CURRENCY = CURR_PAY LOCAL_CURRENCY = T001-WAERS FOREIGN_AMOUNT = BSIK-QBSHB RATE = RATE_PAY TYPE_OF_RATE = 'M' IMPORTING LOCAL_AMOUNT = BSIK-QBSHB.



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name RFKQST20 or its description.