EWUCSIZE SAP ABAP Report - Program to Determine Free DB Memory Required

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

Text pool values

INCLUDES used within this REPORT EWUCSIZE

INCLUDE EWUSTDDD.
INCLUDE EWUSTEPR.
INCLUDE RSSQDMON.

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:

DDIF_FIELDINFO_GET
    CALL FUNCTION 'DDIF_FIELDINFO_GET'
      EXPORTING
        TABNAME   = G_VIEWNAME
      TABLES
        DFIES_TAB = T_FIELDS.

DD_TBFD_GET
  CALL FUNCTION 'DD_TBFD_GET'
    EXPORTING
      TABL_NAME     = P_TABNAME
      WITHTEXT      = 'X'
    TABLES
      DD03P_TAB_A   = DD03P_TAB_A
      DD03P_TAB_N   = DD03P_TAB_N
    EXCEPTIONS
      ILLEGAL_VALUE = 1
      OP_FAILURE    = 2
      OTHERS        = 3.

DDIF_FIELDINFO_GET
    CALL FUNCTION 'DDIF_FIELDINFO_GET'
      EXPORTING
        TABNAME   = P_TABNAME
      TABLES
        DFIES_TAB = T_FIELDS.

DB02_ORA_SELECT_DBA_SEGMENTS
        CALL FUNCTION 'DB02_ORA_SELECT_DBA_SEGMENTS'
          EXPORTING
            SEG_NAME     = 'EWUCLU'
            TB_SPACE     = '*'
            SEG_TYPE     = '*'
            KBYTES       = 0
            NR_EXTENTS   = 0
          TABLES
            DBA_SEGMENTS = DBA_SEGMENTS73.

DB_INF_TBL_EXTENTS
      CALL FUNCTION 'DB_INF_TBL_EXTENTS'
        EXPORTING
          DBSPACE1    = DBSPACE_TMP
          VERSION     = VERSION_TMP
          TFLAG       = TFLAG_TMP
        TABLES
          DBA_SEG_TAB = DBA_SEG
          FRAGTAB     = FRAGTAB
          DBA_TMP_TAB = DBA_TMP.

call function
  PROG = ' call function '.                               APPEND PROG.

S_DB_INFORMIX_VERSION_GET
  CALL FUNCTION 'S_DB_INFORMIX_VERSION_GET'
    EXPORTING
      FULL_VERSION = ' '
    IMPORTING
      VERSION      = INFORMIX_VERSION.

DD_EXIST_TABLE
      CALL FUNCTION 'DD_EXIST_TABLE'
        EXPORTING
          TABNAME = IT_DBA_SEGMENTS-TABNAME
          STATUS  = 'A'
*         NTAB    = ' '
        IMPORTING
          SUBRC   = D_SUBRC.

DD_EXIST_TABLE
      CALL FUNCTION 'DD_EXIST_TABLE'
        EXPORTING
          TABNAME = SIZES-ONAME
          STATUS  = 'A'
*         NTAB    = ' '
        IMPORTING
          SUBRC   = D_SUBRC.

DD_EXIST_TABLE
      CALL FUNCTION 'DD_EXIST_TABLE'
        EXPORTING
          TABNAME = DB_TAB_AND_INDEXES-TABNAME
          STATUS  = 'A'
*         NTAB    = ' '
        IMPORTING
          SUBRC   = D_SUBRC.

SEL_SERVERDBSTATISTICS_ADA
    CALL FUNCTION 'SEL_SERVERDBSTATISTICS_ADA'
      IMPORTING
        serverdbstatistics = ld_servdbstat
      EXCEPTIONS
        table_not_found
        no_entry_found
      .                                                  "#EC NO_INCOMP

GET_PAGESIZE_SDB
    CALL FUNCTION 'GET_PAGESIZE_SDB'
      IMPORTING
        pagesize = h_pagesize.                             "#EC FB_NORC

MSS_GET_DB_MAINVERSION
  CALL FUNCTION 'MSS_GET_DB_MAINVERSION'
    IMPORTING
      DBVERSION = DBVERS.

GET_SQLFILES_MSS
    CALL FUNCTION 'GET_SQLFILES_MSS'
      EXPORTING
        dbname         = db_name
      TABLES
        dbfiles        = dbfiles
      EXCEPTIONS
        internal_error = 1
        OTHERS         = 2.                                 "#EC FB_RC

MSS_GET_DB_SIZE_INFO
    CALL FUNCTION 'MSS_GET_DB_SIZE_INFO'
      EXPORTING
        db_name     = db_name
      IMPORTING
        db_sizeinfo = db_sizeinfo
      EXCEPTIONS
        OTHERS      = 1.

MSS_GET_SERVERINFO
    CALL FUNCTION 'MSS_GET_SERVERINFO'
      IMPORTING
        server = server_info.

MSS_DB_AND_SCHEMA
    CALL FUNCTION 'MSS_DB_AND_SCHEMA'
      CHANGING
        db_name              = db_name
        schema_name          = s_name
      EXCEPTIONS
        not_running_on_mssql = 1
        db_error             = 2
        internal_error       = 3
        db_not_found         = 4
        no_db_access         = 5
        schema_not_found     = 6.

MSS_GET_SCHEMA_SIZE_INFO
    CALL FUNCTION 'MSS_GET_SCHEMA_SIZE_INFO'
      EXPORTING
        schema_name     = s_name
        db_name         = db_name
      IMPORTING
        schema_sizeinfo = s_sizeinfo
      EXCEPTIONS
        OTHERS          = 1.

MSS_GET_DB_MAINVERSION














  CALL FUNCTION 'MSS_GET_DB_MAINVERSION'
    IMPORTING
      DBVERSION = DBVERS.

GET_SQLFILES_MSS
    CALL FUNCTION 'GET_SQLFILES_MSS'
      EXPORTING
        dbname  = db_name
      TABLES
        DBFILES = DBFILES.

MSS_GET_TABLE_SIZE_INFO
    CALL FUNCTION 'MSS_GET_TABLE_SIZE_INFO'
      EXPORTING
        table_name     = 'EWUCLU'
*       db_name        = dbname  " get internal
      IMPORTING
        table_sizeinfo = tabstats.

MSS_GET_TABSTATS
*    CALL FUNCTION 'MSS_GET_TABSTATS'
*      EXPORTING
*        tabname  = 'EWUCLU'
*      IMPORTING
*        tabstats = tablestats.

G_TABLE_READ
    CALL FUNCTION 'G_TABLE_READ'
      EXPORTING
        TABLE      = T800A-TAB
      IMPORTING
        TABLE_ATTR = LD_TABLE_ATTR
      EXCEPTIONS
        NOT_FOUND  = 1
        OTHERS     = 2.