SAP Reports / Programs

comments icon Comments

RSDRH_MSSQL_ROUTINES SAP ABAP Report - MSSQL: DB-dependent routines for processing the hierarchy







RSDRH_MSSQL_ROUTINES is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter RSDRH_MSSQL_ROUTINES 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 RSDRH_MSSQL_ROUTINES. "Basic submit
SUBMIT RSDRH_MSSQL_ROUTINES AND RETURN. "Return to original report after report execution complete
SUBMIT RSDRH_MSSQL_ROUTINES VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: MSSQL: DB-dependent routines for processing the hierarchy


INCLUDES used within this REPORT RSDRH_MSSQL_ROUTINES

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:

RSDDTMPTAB_GET_NEW_NAME
  call function 'RSDDTMPTAB_GET_NEW_NAME'
    exporting
      i_nametype         = i_tbl_typ
    importing
      e_tmpnm            = e_tablnm
    exceptions
      insert_error       = 1
      wrong_nametype     = 2
      counter_overflow   = 3
      lock_error         = 4
      internal_error     = 5
      installation_error = 6
      others             = 7.

DB_DROP_TABLE
    call function 'DB_DROP_TABLE'
      exporting
        tabname       = e_tablnm
        db_check_flag = rs_c_true.

DB_EXISTS_TABLE
    call function 'DB_EXISTS_TABLE'
      exporting
        tabname = e_tablnm
      importing
        subrc   = l_subrc.

RSDU_TRUNCATE_DROP_TABLE
      call function 'RSDU_TRUNCATE_DROP_TABLE'
        exporting
          i_tablnm  = e_tablnm
        exceptions
          sql_error = 1
          others    = 2.

DB_CREATE_TABLE
  call function 'DB_CREATE_TABLE'
    exporting
      db_check_flag     = rs_c_false
      tabname           = e_tablnm
    tables
      ddfields          = l_t_ddfield
    exceptions
      table_exists      = 3
      table_not_created = 4
      others            = 5.

RSDDTMPTAB_GET_NEW_NAME
  call function 'RSDDTMPTAB_GET_NEW_NAME'
    exporting
      i_nametype             = rsd_c_id_tmp_view
    importing
      e_tmpnm                = e_viewnm
    exceptions
      insert_error       = 1
      wrong_nametype     = 2
      counter_overflow   = 3
      lock_error         = 4
      internal_error     = 5
      installation_error = 6
      others             = 7.

RSDU_EXEC_SQL
  call function 'RSDU_EXEC_SQL'
    exporting
      i_t_stmt                = l_t_code
      i_connection            = i_connection
    importing
      e_sqlerr                = l_sqlerr
    exceptions
      sql_error               = 1
      statement_too_complex   = 2
      no_statement            = 3
      inherited_error         = 4
      duprec                  = 5
      obj_exists              = 6
      obj_not_found           = 7
      others                  = 8 .

RSDU_EXEC_SQL
  call function 'RSDU_EXEC_SQL'
    exporting
      i_t_stmt                = l_t_code
      i_connection            = i_connection
    importing
      e_sqlerr                = l_sqlerr
    exceptions
      sql_error               = 1
      statement_too_complex   = 2
      no_statement            = 3
      inherited_error         = 4
      duprec                  = 5
      obj_exists              = 6
      obj_not_found           = 7
      others                  = 8 .

RSDU_ANALYZE_TABLE
  call function 'RSDU_ANALYZE_TABLE'
    exporting
      i_tablnm       = i_tablnm
      i_percentage   = 100
      i_connection   = i_connection
    exceptions
      analyze_failed = 0.


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


   
 

RSDRH_MSSQL_ROUTINES - MSSQL: DB-dependent routines for processing the hierarchy
RSDRH_MSSQL_ROUTINES - MSSQL: DB-dependent routines for processing the hierarchy
RSDRH_HDB_ROUTINES - NewDB: DB-Dependent Routines for Hierarchy Editing
RSDRH_HDB_ROUTINES - NewDB: DB-Dependent Routines for Hierarchy Editing
RSDRH_DB6_ROUTINES - DB6: DB-dependent routines for processing the hierarchy
RSDRH_DB6_ROUTINES - DB6: DB-dependent routines for processing the hierarchy