/SDF/HANA_BW_SIZING

[Former Member]

Hi,

We are performing the sizing required to migrate our BW system to HANA and in this regard when we executed the report

/sdf/hana_bw_sizing it displayed :

1. ABAP size Row store

2. ABAP size Column store

What does the word ' ABAP' in the above means ?   Does this means that the normal database size of table/ tables are different from ABAP size of table ? or it is the same as the size of tables on database ?

BR,

DVRK

[candy_zhan]

Hi DVRK,

yes, they are different. See SAP note 1736976, the attachment SAP_BW_on_HANA_Sizing_V2.pdf for more details.

　

The sizing report reads a sample set of records from the DB, analyzes the sample size in its ABAP representation, and extrapolates the total size of the table if it was entirely loaded into ABAP memory, using the total row count information of the DB. By looking at the ABAP representation, the impact of DB specific features like intrinsic compression or special data formats on sizing is automatically eliminated, and the report can estimate the size of the table in ABAP by applying a suitable compression factor. In the output of the report you can find the ABAP size of tables along with the estimated HANA size. Due to the different representation of data in ABAP and the underlying DB system, the DB table sizes may significantly differ from the ABAP sizes.

Regards,

Candy