SAP_DROP_EMPTY_FPARTITIONS SAP ABAP Report - Locate/remove unused or empty partitions of an F-fact table

SAP_DROP_EMPTY_FPARTITIONS 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_DROP_EMPTY_FPARTITIONS 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.

Text pool values

INCLUDES used within this REPORT SAP_DROP_EMPTY_FPARTITIONS

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_CUBE_F4
  CALL FUNCTION 'RSD_CUBE_F4'
    EXPORTING
      i_objvers     = rs_c_objvers-active
      i_cubetype    = 'B'
      i_title       = 'Select an Infocube'                  "#EC NOTEXT
    CHANGING
      c_infocube    = cubename
    EXCEPTIONS
      illegal_input = 0
      OTHERS        = 0.

RSD_FACTTAB_GET_FOR_CUBE
  CALL FUNCTION 'RSD_FACTTAB_GET_FOR_CUBE'
    EXPORTING
      i_infocube = cubename
    IMPORTING
      e_facttab  = l_ftablnm
      e_comptab  = l_etablnm
    EXCEPTIONS
      name_error = 1
      OTHERS     = 2.

RSDU_PARTITIONS_INFO_GET
  CALL FUNCTION 'RSDU_PARTITIONS_INFO_GET'
    EXPORTING
      i_tablnm              = l_ftablnm
    IMPORTING
      e_partype             = l_parttype
      e_partkey             = l_partkey
      e_ts_part_info        = l_ts_part_info
*   CHANGING
*     c_processed           = l_processed
    EXCEPTIONS
      table_not_exists      = 1
      table_not_partitioned = 2
      OTHERS                = 3.

RSD_FIX_DIME_GET_FOR_CUBE
  CALL FUNCTION 'RSD_FIX_DIME_GET_FOR_CUBE'
    EXPORTING
      i_infocube = i_cubenm
    IMPORTING
*     e_pdime    = l_dimnm
      e_ptablnm  = l_dimtablnm
    EXCEPTIONS
      name_error = 1
      OTHERS     = 2.

RSD_SIDNM_GET_FROM_IOBJNM
  CALL FUNCTION 'RSD_SIDNM_GET_FROM_IOBJNM'
    EXPORTING
      i_iobjnm     = rsd_c_dpanm-requid
    IMPORTING
      e_sidfieldnm = l_sidnm
*     e_hidfieldnm = l_hidnm
    EXCEPTIONS
      name_error   = 1
      OTHERS       = 2.

RSD_IS_CUBE_TABLE
  CALL FUNCTION 'RSD_IS_CUBE_TABLE'
    EXPORTING
      i_tablnm   = i_tablnm
    IMPORTING
      e_infocube = l_cubenm.

RSD_FIX_DIME_GET_FOR_CUBE
  CALL FUNCTION 'RSD_FIX_DIME_GET_FOR_CUBE'
    EXPORTING
      i_infocube = l_cubenm
    IMPORTING
      e_pdime    = l_dimnm
*     e_ptablnm  = l_dimtablnm
    EXCEPTIONS
      name_error = 1
      OTHERS     = 2.

RSD_FIELDNM_GET_FOR_DIME
  CALL FUNCTION 'RSD_FIELDNM_GET_FOR_DIME'
    EXPORTING
      i_dimension = l_dimnm
    IMPORTING
      e_fieldnm   = l_keynm
    EXCEPTIONS
      name_error  = 1
      OTHERS      = 2.

DB_COMMIT
      CALL FUNCTION 'DB_COMMIT'.

RSDU_EXEC_SQL
    CALL FUNCTION 'RSDU_EXEC_SQL'
      EXPORTING
        i_stmt      = l_sqlstmt
      IMPORTING
        e_sqlerr    = l_sqlerr
        e_sqlerrtxt = l_errtxt
      EXCEPTIONS
        sql_error   = 1
        OTHERS      = 2.

DB_COMMIT
      CALL FUNCTION 'DB_COMMIT'.