SAP Reports / Programs | SAP Business Information Warehouse | Basis System and Installation | BW DB2 Universal Database(BW-SYS-DB-DB6) SAP BW

comments icon Comments

SAP_RSDB6_SHOW_TABLAYOUT SAP ABAP Report - Displays the Database Layout of InfoProvider Tables







SAP_RSDB6_SHOW_TABLAYOUT 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 SAP_RSDB6_SHOW_TABLAYOUT 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 SAP_RSDB6_SHOW_TABLAYOUT. "Basic submit
SUBMIT SAP_RSDB6_SHOW_TABLAYOUT AND RETURN. "Return to original report after report execution complete
SUBMIT SAP_RSDB6_SHOW_TABLAYOUT VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Displays the Database Layout of InfoProvider Tables


INCLUDES used within this REPORT SAP_RSDB6_SHOW_TABLAYOUT

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:

RSD_FACTTAB_GET_FOR_CUBE
    CALL FUNCTION 'RSD_FACTTAB_GET_FOR_CUBE'
      EXPORTING
        i_infocube = infocube
      IMPORTING
        e_facttab  = l_ftablename
        e_comptab  = l_etablename
      EXCEPTIONS
        OTHERS     = 1.

RSD_DIME_MULTI_GET
    CALL FUNCTION 'RSD_DIME_MULTI_GET'
      EXPORTING
        i_read_all = rs_c_true
        i_infocube = infocube
        i_objvers  = rs_c_objvers-active
      IMPORTING
        e_t_tbhd   = l_t_tbhd_basic_dim
      EXCEPTIONS
        OTHERS     = 1.

DB_EXISTS_VIEW
      CALL FUNCTION 'DB_EXISTS_VIEW'
        EXPORTING
          viewname = l_s_tbhd-tablnm
        IMPORTING
          subrc    = l_subrc.

RSDDK_COMPLEX_AGGRCAT_GET
      CALL FUNCTION 'RSDDK_COMPLEX_AGGRCAT_GET'
        EXPORTING
          i_s_aggrdir_db = 
        IMPORTING
          e_sx_aggrcat   = l_sx_aggrcat.

RSDDK_AGGRCAT_READ
*  CALL FUNCTION 'RSDDK_AGGRCAT_READ'
*      EXPORTING
*        i_infocube    = infocube
*      IMPORTING
*        e_thx_aggrcat = l_thx_aggr
*      EXCEPTIONS
*        no_aggregate  = 1
*        OTHERS        = 2. " ignore

RSD_FACTTAB_GET_FOR_CUBE
          CALL FUNCTION 'RSD_FACTTAB_GET_FOR_CUBE'
            EXPORTING
              i_infocube = -aggrcube
            IMPORTING
              e_facttab  = l_ftablename
              e_comptab  = l_etablename
            EXCEPTIONS
              OTHERS     = 1.

RSD_DIME_MULTI_GET
          CALL FUNCTION 'RSD_DIME_MULTI_GET'
            EXPORTING
              i_read_all = rs_c_true
              i_infocube = -aggrcube
              i_objvers  = rs_c_objvers-active
            IMPORTING
              e_t_tbhd   = l_t_tbhd
            EXCEPTIONS
              OTHERS     = 1.

DB_EXISTS_VIEW
            CALL FUNCTION 'DB_EXISTS_VIEW'
              EXPORTING
                viewname = l_s_tbhd-tablnm
              IMPORTING
                subrc    = l_subrc.

DYNP_VALUES_READ
  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname     = sy-repid
      dynumb     = sy-dynnr
    TABLES
      dynpfields = l_t_dy_fie
    EXCEPTIONS
      OTHERS     = 4.

RSD_CUBE_F4
  CALL FUNCTION 'RSD_CUBE_F4'
    CHANGING
      c_infocube = infocube
    EXCEPTIONS
      OTHERS     = 2.

DYNP_VALUES_READ
  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname     = sy-repid
      dynumb     = sy-dynnr
    TABLES
      dynpfields = l_t_dy_fie
    EXCEPTIONS
      OTHERS     = 4.

DB_EXISTS_INDEX
          CALL FUNCTION 'DB_EXISTS_INDEX'
            EXPORTING
              tabname   = l_s_prim_idx-sqltab
              indexname = l_s_prim_idx-indexname
            IMPORTING
              subrc     = l_subrc.

DB_EXISTS_INDEX
          CALL FUNCTION 'DB_EXISTS_INDEX'
            EXPORTING
              tabname   = l_s_sec_idx-sqltab
              indexname = l_s_sec_idx-indexname
            IMPORTING
              subrc     = l_subrc.


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


   
 

SAP_RSDB6_SHOW_TABLAYOUT - Displays the Database Layout of InfoProvider Tables
SAP_RSDB6_SHOW_TABLAYOUT - Displays the Database Layout of InfoProvider Tables
SAP_RSDB6_PINDEX_ON_FTABLE - Delete/Create P Index for F Fact Tables
SAP_RSDB6_PINDEX_ON_FTABLE - Delete/Create P Index for F Fact Tables
SAP_RSADMIN_MAINTAIN - RSADMIN Administration
SAP_RSADMIN_MAINTAIN - RSADMIN Administration