/SDF/HDBTABSIZES - Sizing estimation details for tables
Sizing estimation details for tables information is stored in SAP table /SDF/HDBTABSIZES.
It is part of development package /SDF/STPI_7X in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "7.x developments in ST-PI".
It is part of development package /SDF/STPI_7X in software component SV-SMG-SDD. This development package consists of objects that can be grouped under "7.x developments in ST-PI".
Fields for table /SDF/HDBTABSIZES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
SIZING_GUID | GUID in 'RAW' format | X | GUID_16 | RAW | 16 | |
TABLE_NAME | Table name | X | /SDF/TABLENAME | CHAR | 60 | |
PART_ID | Partition ID | X | /SDF/PARTID | INT4 | 4 | |
TAB_TYPE | BW table type | CHAR | 10 | |||
STORE_TYPE | Row/Column Store indicator | CHAR | 4 | |||
SRC_DB_SIZE | Table size as reported by source DB | DEC | 11 | |||
ABAP_SIZE | Extrapolated table size in ABAP | DEC | 11 | |||
HANA_SIZE | Estimated HANA size | DEC | 11 | |||
RECORD_COUNT | Total number of records | DEC | 11 | |||
RECORDS_SAMPLED | Number of records in sample set | DEC | 11 | |||
DATA_SIZE_SAMPLE | Calculated size of sampled records | DEC | 11 | |||
LOB_SIZE_SAMPLED | Calculated size of LOBs in sampled records | DEC | 11 | |||
DATA_SIZE | Extrapolated size of data in table | DEC | 11 | |||
OPT_SIZE | Extrapolated size of data in table after clean-up | DEC | 11 | |||
LOB_SIZE | Extrapolated size of LOBs in table | DEC | 11 | |||
HANA_INDEX_SIZE | Calculated size of HANA indexes (row store tables) | DEC | 11 | |||
OBJECT_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR | 80 | ||
TLOGO | Object Type | TROBJTYPE | CHAR | 8 |