RSVHDBTABSIZES - Sizing estimation details for tables. Size is in KB not MB
Sizing estimation details for tables. Size is in KB not MB information is stored in SAP table RSVHDBTABSIZES.
It is part of development package RSVS in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "DDIC Objects and CDS views for HANA Sizing scenario".
It is part of development package RSVS in software component BW-WHM-DBA. This development package consists of objects that can be grouped under "DDIC Objects and CDS views for HANA Sizing scenario".
Fields for table RSVHDBTABSIZES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SIZING_GUID | Sizing GUID | X | RSV_SIZING_GUID | RAW | 16 | |
TABLE_NAME | Table Name | X | RSV_TABLENAME | CHAR | 60 | |
PART_ID | Partition ID | X | RSV_PARTID | INT4 | 4 | |
TAB_TYPE | BW table type | RSVS_TAB_TYPE | CHAR | 10 | ||
STORE_TYPE | Row/Column Store indicator | RSVS_STORE_TYPE | CHAR | 4 | ||
SRC_DB_SIZE | Table size as reported by source DB (in MB) | RSVS_SRC_DB_SIZE | DEC | 11 | ||
ABAP_SIZE | Extrapolated table size in ABAP (in MB) | RSVS_ABAP_SIZE | DEC | 11 | ||
HANA_SIZE | Estimated HANA table size (in MB) | RSVS_HANA_SIZE | DEC | 11 | ||
RECORD_COUNT | Total number of records | RSVS_RECORD_COUNT | DEC | 11 | ||
RECORDS_SAMPLED | Number of records in sample set | RSVS_RECORDS_SAMPLED | DEC | 11 | ||
DATA_SIZE_SAMPLE | Calculated size of sampled records (in MB) | RSVS_DATA_SIZE_SAMPLE | DEC | 11 | ||
LOB_SIZE_SAMPLED | Calculated size of LOBs in sampled records (in MB) | RSVS_LOB_SIZE_SAMPLED | DEC | 11 | ||
DATA_SIZE | Extrapolated size of data in table (in MB) | RSVS_DATA_SIZE | DEC | 11 | ||
LOB_SIZE | Extrapolated size of LOBs in table (in MB) | RSVS_LOB_SIZE | DEC | 11 | ||
HANA_INDEX_SIZE | Calculated size of HANA indexes (row store tables) (in MB) | RSVS_HANA_INDEX_SIZE | DEC | 11 | ||
OBJECT_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR | 80 | ||
TLOGO | Object Type | TROBJTYPE | CHAR | 8 |