SAP Reports / Programs

comments icon Comments

RFKQSE20 SAP ABAP Report - Withholding Tax Reporting Model 210 Spain







RFKQSE20 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program (which applies to Spain only) creates a DME file for the 210A report...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 RFKQSE20 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 RFKQSE20. "Basic submit
SUBMIT RFKQSE20 AND RETURN. "Return to original report after report execution complete
SUBMIT RFKQSE20 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: AUGDAT = Clearing Date
Selection Text: BELART = Document type
Selection Text: BELNUM = Document number
Selection Text: BUCHDT = Posting date
Selection Text: CONVDAT = Translation date
Selection Text: DTA_FLAG = Generate DME file
Selection Text: EINZELPO = Line items
Selection Text: KTOSUMME = Totals per vendor
Selection Text: LISTSEPA = Separate list
Selection Text: P_FILE = Path & file name
Selection Text: P_NAME = Company name for DME file
Selection Text: P_NUMBER = House number/Kilometer
Selection Text: P_PERIOD = Tax reporting period
Selection Text: P_SCODE = Street code
Selection Text: P_SNAME = Street
Selection Text: P_TAX_O = Financial authorities key
Selection Text: P_TOPC = File on presentation server
Selection Text: QSTKZ = Withholding tax codes
Selection Text: QSTSUMME = Totals per withholdng tax code
Selection Text: WITHT = Withholding Tax Type
Selection Text: ZUSTITEL = Additional heading
Title: Withholding Tax Reporting Model 210 Spain
Text Symbol: 406 = Spain
Text Symbol: 405 = Australia
Text Symbol: 404 = Great Britain
Text Symbol: 403 = Italy
Text Symbol: 402 = Belgium
Text Symbol: 401 = France
Text Symbol: 001 = Withholding tax reporting model 210A Spain
Text Symbol: 002 = *** No correct report variant has been chosen ***
Text Symbol: 003 = WT code Withholding tax name Invoice amount Base amount Withholding tax Net amount Tax-exempt amnt
Text Symbol: 004 = Acct no. Tax number Address
Text Symbol: 005 = Doc. no. PstDte ClrDte Reference no. Tpe W/tax Invoice amnt Down pmnts Base amount Withholding tax
Text Symbol: 007 = Withhldg tax report for $
Text Symbol: 008 = SeqNo Acct No. Address
Text Symbol: 009 = ClgDte Doc.no. PK S LI DT DocDte Reference no. Invoice amount Base amount Withhold.tax Net amount Tax-exempt amt
Text Symbol: 010 = W/tax code





Text Symbol: 011 = License no.:
Text Symbol: 012 = Valid until:
Text Symbol: 013 = Licence has now expired
Text Symbol: 014 = Tax code:
Text Symbol: 015 = (O-T acct)
Text Symbol: 016 = SeqNo Acct No. Address Tax number
Text Symbol: 021 = Output in alternat. local currency:
Text Symbol: 090 = Recpt
Text Symbol: 091 = In company code
Text Symbol: 092 = cannot be processed because there is more than one w/tax type.
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 = Acct
Text Symbol: 200 = Male ,,
Text Symbol: 201 = Female ,,
Text Symbol: 202 = Born ,,
Text Symbol: 203 = in ,,
Text Symbol: 204 = on ,,


INCLUDES used within this REPORT RFKQSE20

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:

FILE_VALIDATE_NAME
    CALL FUNCTION 'FILE_VALIDATE_NAME'
      EXPORTING
        logical_filename  = gc_filename
        parameter_1       = sy-cprog
      CHANGING
        physical_filename = p_file
      EXCEPTIONS
        OTHERS            = 1.

FILE_VALIDATE_NAME
      CALL FUNCTION 'FILE_VALIDATE_NAME'
        EXPORTING
          logical_filename  = gc_filename
          parameter_1       = sy-cprog
        CHANGING
          physical_filename = p_file
        EXCEPTIONS
          OTHERS            = 1.

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
      TABLES
        t_with_item = x_with_item
      EXCEPTIONS
        not_found   = 1
        OTHERS      = 2.

CONVERT_TO_FOREIGN_CURRENCY
      CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
        EXPORTING
          date             = convdat
          foreign_currency = altcurr
          local_amount     = main_tab-dmbtr
          local_currency   = t001-waers
          type_of_rate     = 'M'
        IMPORTING
          foreign_amount   = main_tab-dmbtr.

CONVERT_TO_FOREIGN_CURRENCY
      CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
        EXPORTING
          date             = convdat
          foreign_currency = altcurr
          local_amount     = main_tab-dmbas
          local_currency   = t001-waers
          type_of_rate     = 'M'
        IMPORTING
          foreign_amount   = main_tab-dmbas.

CONVERT_TO_FOREIGN_CURRENCY
      CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
        EXPORTING
          date             = convdat
          foreign_currency = altcurr
          local_amount     = main_tab-dmtax
          local_currency   = t001-waers
          type_of_rate     = 'M'
        IMPORTING
          foreign_amount   = main_tab-dmtax.

CONVERT_TO_FOREIGN_CURRENCY
      CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY'
        EXPORTING
          date             = convdat
          foreign_currency = altcurr
          local_amount     = main_tab-downd
          local_currency   = t001-waers
          type_of_rate     = 'M'
        IMPORTING
          foreign_amount   = main_tab-downd.

POPUP_NO_LIST
    CALL FUNCTION 'POPUP_NO_LIST'
      EXPORTING
        on_empty_list = 'X'.

ADDR_GET
















        CALL FUNCTION 'ADDR_GET'
          EXPORTING
            address_selection = addr1_sel
          IMPORTING
            sadr              = sadr
          EXCEPTIONS
            OTHERS            = 1.

FILE_VALIDATE_NAME
    CALL FUNCTION 'FILE_VALIDATE_NAME'
      EXPORTING
        logical_filename  = gc_filename
        parameter_1       = sy-cprog
      CHANGING
        physical_filename = P_FILE
      EXCEPTIONS
        OTHERS            = 1.

GUI_DOWNLOAD
    CALL FUNCTION 'GUI_DOWNLOAD'
      EXPORTING
*   BIN_FILESIZE                  =
        filename                      = file_name
        filetype                      = 'ASC'
*   APPEND                        = ' '
*   WRITE_FIELD_SEPARATOR         = ' '
*   HEADER                        = '00'
*   TRUNC_TRAILING_BLANKS         = ' '
*   WRITE_LF                      = 'X'
*   COL_SELECT                    = ' '
*   COL_SELECT_MASK               = ' '
* IMPORTING
*   FILELENGTH                    =
      TABLES
        data_tab                     = xfile
     EXCEPTIONS
       file_write_error              = 1
       no_batch                      = 2
       gui_refuse_filetransfer       = 3
       invalid_type                  = 4
       no_authority                  = 5
       unknown_error                 = 6
       header_not_allowed            = 7
       separator_not_allowed         = 8
       filesize_not_allowed          = 9
       header_too_long               = 10
       dp_error_create               = 11
       dp_error_send                 = 12
       dp_error_write                = 13
       unknown_dp_error              = 14
       access_denied                 = 15
       dp_out_of_memory              = 16
       disk_full                     = 17
       dp_timeout                    = 18
       file_not_found                = 19
       dataprovider_exception        = 20
       control_flush_error           = 21
       OTHERS                        = 22.

DOWNLOAD
*    CALL FUNCTION 'DOWNLOAD'
*         EXPORTING
*              BIN_FILESIZE       = ' '
*              CODEPAGE           = ' '
*              FILEMASK_ALL       = ' '
*              FILEMASK_MASK      = ' '
*              FILEMASK_TEXT      = ' '
*              FILENAME           = FILE_NAME
*              FILETYPE           = 'ASC'
*              FILETYPE_NO_CHANGE = 'X'
*              FILETYPE_NO_SHOW   = 'X'
*              ITEM               = ' '
*              MODE               = ' '
*              WK1_N_FORMAT       = ' '
*              WK1_N_SIZE         = ' '
*              WK1_T_FORMAT       = ' '
*              WK1_T_SIZE         = ' '
*         TABLES
*              DATA_TAB           = XFILE.

GET_CURRENT_YEAR
  CALL FUNCTION 'GET_CURRENT_YEAR'
    EXPORTING
      bukrs = bsik-bukrs
      date  = bsik-augdt
    IMPORTING
      curry = aug_year.

CONVERT_TO_LOCAL_CURRENCY
  CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
    EXPORTING
      date             = bkpf-wwert
      foreign_currency = bkpf-waers
      local_currency   = t001-waers
      foreign_amount   = bsik-wrbtr
      rate             = bkpf-kursf
      type_of_rate     = 'M'
    IMPORTING
      local_amount     = bsik-dmbtr.

CONVERT_TO_LOCAL_CURRENCY
  CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
    EXPORTING
      date             = bkpf-wwert
      foreign_currency = bkpf-waers
      local_currency   = t001-waers
      foreign_amount   = bsik-qsshb
      rate             = bkpf-kursf
      type_of_rate     = 'M'
    IMPORTING
      local_amount     = bsik-qsshb.

CONVERT_TO_LOCAL_CURRENCY
  CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY'
    EXPORTING
      date             = bkpf-wwert
      foreign_currency = bkpf-waers
      local_currency   = t001-waers
      foreign_amount   = bsik-qbshb
      rate             = bkpf-kursf
      type_of_rate     = 'M'
    IMPORTING
      local_amount     = bsik-qbshb.

F4IF_INT_TABLE_VALUE_REQUEST
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield    = 'QSSKZ'
      dynpprog    = sy-repid
      dynpnr      = sy-dynnr
      dynprofield = 'QSTKZ-LOW'
      value_org   = 'S'
    TABLES
      value_tab   = values_tab.

F4IF_INT_TABLE_VALUE_REQUEST
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield    = 'QSSKZ'
      dynpprog    = sy-repid
      dynpnr      = sy-dynnr
      dynprofield = 'QSTKZ-HIGH'
      value_org   = 'S'
    TABLES
      value_tab   = values_tab.


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 RFKQSE20 or its description.


   
 

RFKQSE20 - Withholding Tax Reporting Model 210 Spain
RFKQSE20 - Withholding Tax Reporting Model 210 Spain
RFKQSE11 - Form 190 to the Tax Authorities (Spain)
RFKQSE11 - Form 190 to the Tax Authorities (Spain)
RFKQSE10 - Withholding Tax Report (DME) to the Tax Authorities (Spain)
RFKQSE10 - Withholding Tax Report (DME) to the Tax Authorities (Spain)