/SDF/HDB_SIZING SAP ABAP Report - Sizing for Suite on HANA

/SDF/HDB_SIZING is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter /SDF/HDB_SIZING into the relevant SAP transaction such as SE38 or SE80

Contribute (Add Comments)
Below is the basic information available for SAP report /SDF/HDB_SIZING and is provided for your convenience to access as and when required. Although the 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 /SDF/HDB_SIZING or its description.

ABAP code:

ABAP code listing snippet for SAP ABAP Report /SDF/HDB_SIZING

*&-------------------------------*
*& Report  /SDF/HDB_SIZING // ZNEWHDB_SIZE
*&
*&-------------------------------*
*& Estimates the memory requirement in HANA of non-HANA databases      *
*& When run on HANA, size the database using real memory consumption
*& values.
*&-------------------------------*
*
*
REPORT /SDF/HDB_SIZING  LINE-SIZE 101 LINE-COUNT 90
                        NO STANDARD PAGE HEADING.
DATA: l_version TYPE c LENGTH 6 VALUE '54'. "54.2
TYPES: ty_para(2) TYPE n,
       ty_top(3)  TYPE n.
TYPE-POOLS: abap.
DATA: tabname   TYPE tabname,
      subrc     TYPE sy-subrc,
      p_prf     TYPE abap_bool,

....See full code listing within your SAP system using transactions such as SE80 and SE38

Includes used within report:

No INCLUDES are used within this report code!

Tables used within report and the associated select statement:

DD02L
  SELECT * FROM dd02l INTO gs_dd02l
    WHERE as4local = 'A'
      AND tabname IN so_tab
      AND tabclass IN ('TRANSP', 'CLUSTER' , 'POOL')
      AND (where_clause).

DD02L
    SELECT tabname FROM dd02l INTO TABLE tt_t_multi
      FOR ALL ENTRIES IN gt_input
      WHERE as4local = 'A'
       AND tabclass = 'VIEW'
    AND tabname = gt_input-db_table.

DD02L
      SELECT tabname FROM dd02l INTO TABLE gt_cstab
        WHERE as4local = 'A'
          AND tabname IN so_cstab
          AND tabclass IN ('TRANSP', 'CLUSTER' , 'POOL')
      ORDER BY tabname.

DD02L
      SELECT tabname FROM dd02l INTO TABLE gt_rstab
        WHERE as4local = 'A'
          AND tabname IN so_rstab
          AND tabclass IN ('TRANSP', 'CLUSTER' , 'POOL')
      ORDER BY tabname.

DD09L
      SELECT tabname FROM dd09l INTO TABLE gt_row_tab
         FOR ALL ENTRIES IN gt_tables
         WHERE tabname = gt_tables-table_name
         AND as4local = 'A'
         AND (where_clause).

PROGDIR
  SELECT SINGLE fixpt FROM progdir INTO l_fixpt
         WHERE name = sy-repid
  AND state = 'A'.

CVERS
  SELECT SINGLE * FROM cvers INTO s_cvers WHERE component = 'SAP_BASIS'.

DD03L
    SELECT tabname FROM dd03l INTO TABLE lt_lob
      FOR ALL ENTRIES IN gt_error
      WHERE tabname  = gt_error-table_name
        AND as4local = 'A'
        AND ( datatype IN ('RSTR', 'STRG' )
         OR ( datatype IN ('LRAW', 'LCHR' ) AND leng >= 5000 ) ).

C_ADMI_RUN)
            SELECT MAX( creat_date ) FROM (c_admi_run)
              INTO ls_dvmarobj-arclrun
              WHERE object = -object AND
                    status = 1. "client specified?

NEWGL_T881)
    SELECT DISTINCT tab FROM (newgl_t881) INTO gs_sfin2-table_name
      WHERE appl = 'FI' AND subappl = 'GLF'.

NEWGL_T881)
    SELECT DISTINCT tab FROM (newgl_t881) INTO gs_sfin2-table_name
      WHERE appl = 'FI' AND subappl = 'SL'.

DD12L
    SELECT b~sqltab b~indexname b~fieldname b~position a~uniqueflag
    INTO TABLE gt_index FROM dd12l AS a
         JOIN dd17s AS b
           ON b~sqltab    = a~sqltab
          AND b~indexname = a~indexname
    FOR ALL ENTRIES IN gt_tables
    WHERE a~sqltab    = gt_tables-table_name
    AND   a~as4local  = 'A'
    AND  ( ( dbsyssel1 = '' AND dbsyssel2 = '' AND dbsyssel3 = ''
             AND dbsyssel4 = ''  AND dbstate = '' )
     OR  ( dbstate = 'D' AND dbinclexcl = 'I' AND ( dbsyssel1 = 'HDB'
           OR dbsyssel2 = 'HDB' OR dbsyssel3 = 'HDB'
           OR dbsyssel4 = 'HDB' ) )
     OR  ( dbstate = 'D' AND dbinclexcl = 'E' AND NOT
          ( dbsyssel1 = 'HDB' OR dbsyssel2 = 'HDB'
           OR dbsyssel3 = 'HDB' OR dbsyssel4 = 'HDB' ) )
    ).

SUM_TABLE)
      SELECT SINGLE sizing_guid FROM (sum_table) INTO lv_sizing_guid
              WHERE sizing_guid = lv_sizing_guid.

C_DAAG_OBJECTS_ACT)
        SELECT SINGLE active FROM (c_daag_objects_act)
          INTO -agobact WHERE object = -agobject.

DBTAB_JOIN)
      SELECT MAX( r~run_date ) INTO -aglrun
        FROM (dbtab_join)
        WHERE o~object = -agobject
              AND o~active = abap_true AND r~run_status = 'S'
              AND r~status_details = 'A'.

Function Modules used within report and the associated call statement:

DD_EXIST_TABLE CALL FUNCTION 'DD_EXIST_TABLE' EXPORTING tabname = 'BSIS' status = 'A' IMPORTING subrc = subrc EXCEPTIONS wrong_status = 1 OTHERS = 2.

SPBT_INITIALIZE CALL FUNCTION 'SPBT_INITIALIZE' EXPORTING group_name = p_group IMPORTING free_pbt_wps = maxrfc EXCEPTIONS invalid_group_name = 1 internal_error = 2 pbt_env_already_initialized = 3 currently_no_resources_avail = 4 no_pbt_resources_found = 5 cant_init_different_pbt_groups = 6 OTHERS = 7.

DDIF_NAMETAB_GET * CALL FUNCTION 'DDIF_NAMETAB_GET' * EXPORTING * tabname = 'DD02L' * TABLES * x031l_tab = gt_ddfields.

DB_COMMIT CALL FUNCTION 'DB_COMMIT'.

DDIF_NAMETAB_GET CALL FUNCTION 'DDIF_NAMETAB_GET' EXPORTING tabname = 'DD09L' TABLES x031l_tab = gt_ddfields.

Z_COLLECT_STATS

/SDF/COLLECT_DB_STATS CALL FUNCTION '/SDF/COLLECT_DB_STATS' STARTING NEW TASK taskname DESTINATION IN GROUP p_group PERFORMING collect_all ON END OF TASK EXPORTING precision = prec mode = mode load = p_load CHANGING data = data EXCEPTIONS system_error = 1 system_failure = 2 communication_failure = 3 resource_failure = 4 OTHERS = 5.

FUNCTION_IMPORT_DOKU CALL FUNCTION 'FUNCTION_IMPORT_DOKU' EXPORTING funcname = 'Z_COLLECT_STATS' IMPORTING remote_call = l_remoteflag TABLES dokumentation = lt_doku export_parameter = lt_export exception_list = lt_exeplist import_parameter = lt_import changing_parameter = lt_changing tables_parameter = lt_tabparam EXCEPTIONS error_message = 1 function_not_found = 2 invalid_name = 3 OTHERS = 4.

DB_DBRELINFO CALL FUNCTION 'DB_DBRELINFO' IMPORTING dbinfo = lt_dbinfo.

LCA_LIVECACHE_AVAILABLE CALL FUNCTION 'LCA_LIVECACHE_AVAILABLE' IMPORTING ev_installed = l_lcinstalled ev_available = l_lcavailable.

/SAPAPO/OM_ESTIMATE_LC_MEM CALL FUNCTION '/SAPAPO/OM_ESTIMATE_LC_MEM' IMPORTING ev_estimated_memory_mb = i_lc_size.

DB_STATISTICS_DATA_READ CALL FUNCTION 'DB_STATISTICS_DATA_READ' EXPORTING tableclass = 'I' activ_data = 'A' TABLES dbstat = lt_dbstatam EXCEPTIONS input_inconsistence = 1 no_data_found = 2 OTHERS = 3.

DD_EXIST_TABLE CALL FUNCTION 'DD_EXIST_TABLE' EXPORTING tabname = c_object status = 'A' IMPORTING subrc = subrc EXCEPTIONS wrong_status = 1 OTHERS = 2.

Text pool values

Title: Sizing for Suite on HANA

/SDF/HDB_MON

/SDF/ISPROXY_TEST