SAP Reports / Programs | Basis Components | Basis Components | Retention Warehouse(BC-ILM-RW) SAP BC

comments icon Comments

RIWP_QUERY_EXPORT SAP ABAP Report - Export the Results of a Query







RIWP_QUERY_EXPORT is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Exports the query results to a file using SAP audit format...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 RIWP_QUERY_EXPORT into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

IWP_QUERY_EXPORT - Export Query Results


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 RIWP_QUERY_EXPORT. "Basic submit
SUBMIT RIWP_QUERY_EXPORT AND RETURN. "Return to original report after report execution complete
SUBMIT RIWP_QUERY_EXPORT 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: P_XTEXT = D .
Selection Text: P_XFILE = D .
Selection Text: P_XDIRS = D .
Selection Text: P_WPEXT = D .
Selection Text: P_VARNT = Variant
Selection Text: P_QUERY = BW Query
Selection Text: P_OVERWR = D .
Selection Text: P_HEADER = D .
Selection Text: P_FRMT3 = SAP Audit Format
Selection Text: P_FRMT2 = Columns with Fixed Length
Selection Text: P_FRMT1 = D .
Selection Text: P_BW_SYS = D .
Title: Export the Results of a Query
Text Symbol: SRC = Source
Text Symbol: R43 = SAP Audit Format
Text Symbol: R42 = Columns with Fixed Length
Text Symbol: R41 = Columns Separated by Semicolon
Text Symbol: R31 = Overwrite File
Text Symbol: P31 = Insert Header Row
Text Symbol: EXP = Options for Export in File
Text Symbol: 002 = Export Query in SAP Audit format
Text Symbol: 001 = Data from BI Query


INCLUDES used within this REPORT RIWP_QUERY_EXPORT

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:

F4IF_INT_TABLE_VALUE_REQUEST
    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
      EXPORTING
        retfield        = 'BW_SYS'
        value_org       = 'S'
      TABLES
        value_tab       = value_tab
        return_tab      = l_t_return_tab
      EXCEPTIONS
        parameter_error = 1
        no_values_found = 2
        OTHERS          = 3.

DYNP_VALUES_READ
  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname             = l_sy_repid
      dynumb             = sy-dynnr
      translate_to_upper = ' '
    TABLES
      dynpfields         = l_t_dynprofields.

DYNP_VALUES_READ
  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname             = l_sy_repid
      dynumb             = sy-dynnr
      translate_to_upper = ' '
    TABLES
      dynpfields         = l_t_dynprofields.

BAL_LOG_CREATE
  CALL FUNCTION 'BAL_LOG_CREATE'
    EXPORTING
      i_s_log = ls_log
    EXCEPTIONS
      OTHERS  = 1.

BAL_LOG_MSG_ADD
    CALL FUNCTION 'BAL_LOG_MSG_ADD'
      EXPORTING
        i_s_msg       = ls_msg
*       I_LOG_HANDLE  =
      EXCEPTIONS
        log_not_found = 0
        OTHERS        = 1.

BAL_DSP_LOG_DISPLAY
  CALL FUNCTION 'BAL_DSP_LOG_DISPLAY'
    EXCEPTIONS
      OTHERS = 1.


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


   
 

RIWP_QUERY_EXPORT - Export the Results of a Query
RIWP_QUERY_EXPORT - Export the Results of a Query
RIWP_MIGRATE_REUSE - Migrates InfoObject Reuse Customizing from Audit Area to template
RIWP_MIGRATE_REUSE - Migrates InfoObject Reuse Customizing from Audit Area to template
RIWP_LR_CREATE_FILE - Creation of the file for local reporting
RIWP_LR_CREATE_FILE - Creation of the file for local reporting