/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 |