RIACCESS SAP ABAP Report - Structure Download for MSAccess

RIACCESS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for You can use this program to generate Microsoft Access databases automatically...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 RIACCESS 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

OIDV - Download SAP Tables into MS Access

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.

Text pool values

INCLUDES used within this REPORT RIACCESS

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:

WS_QUERY
  CALL FUNCTION 'WS_QUERY'
    EXPORTING
      query  = 'CD'              "// Current Directory
    IMPORTING
      return = h_path.

WS_FILENAME_GET
  CALL FUNCTION 'WS_FILENAME_GET'
       EXPORTING
            def_filename     = 'sapfile'
            def_path         = h_path
            mask             = h_mask
            mode             = 'O'
       IMPORTING
            filename         = dbname
*         rc               =
       EXCEPTIONS
            inv_winsys       = 1
            no_batch         = 2
            selection_cancel = 3
            selection_error  = 4
            OTHERS           = 5.

STRUCTURE_EXPORT_TO_MSACCESS
      CALL FUNCTION 'STRUCTURE_EXPORT_TO_MSACCESS'
        EXPORTING
          dbname  = h_dbname
          langu   = langu
          dest    = h_dest
        TABLES
          tabname = h_tabname.

GET_FIELDTAB
        CALL FUNCTION 'GET_FIELDTAB'
             EXPORTING
                  langu         = h_langu
                  tabname       = h_tab
                  withtext      = 'X'
             TABLES
                  fieldtab      = h_fieldtab
             EXCEPTIONS
                  no_texts_found.

REUSE_ALV_GRID_DISPLAY
  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
	   EXPORTING
	    i_callback_program                = g_repid
	    is_layout                         = ls_layout
	    it_fieldcat                       = lt_fieldcat
           i_save                            = gc_save
	    it_events                         = lt_eventtab
         TABLES
	    t_outtab                          = gt_output_alv
	  EXCEPTIONS
	    program_error                     = 1
	    OTHERS                            = 2
	            .

REUSE_ALV_FIELDCATALOG_MERGE
  CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE'
    EXPORTING
      i_program_name         = g_repid
      i_structure_name       = gc_structure
    CHANGING
      ct_fieldcat            = xt_fieldcat
    EXCEPTIONS
      inconsistent_interface = 1
      program_error          = 2
      OTHERS                 = 3.

REUSE_ALV_EVENTS_GET
  CALL FUNCTION 'REUSE_ALV_EVENTS_GET'
    EXPORTING
      i_list_type = 0
    IMPORTING
      et_events   = xt_eventtab.

REUSE_ALV_COMMENTARY_WRITE
  CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE'
    EXPORTING
      it_list_commentary = gt_commentary.

FORMAT_TEXTLINES
    CALL FUNCTION 'FORMAT_TEXTLINES'
      EXPORTING
        formatwidth = 60
        linewidth   = 132
        startline   = 1
      TABLES
        lines       = lt_tline
      EXCEPTIONS
        OTHERS      = 0.