SAP ABAP Table /SDF/CSSIZING (Sizing estimation details for HDB Row Store)
Hierarchy
☛
ST-PI (Software Component) SAP Solution Tools Plug-In
⤷ SV-SMG-SDD (Application Component) Service Data Download
⤷ /SDF/STPI_6X (Package) Release 6.XX dependent Basis Addon SLM
⤷ SV-SMG-SDD (Application Component) Service Data Download
⤷ /SDF/STPI_6X (Package) Release 6.XX dependent Basis Addon SLM
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | /SDF/CSSIZING | Table Relationship Diagram |
Short Description | Sizing estimation details for HDB Row Store |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | TABLE_NAME | /SDF/TABLENAME | CHAR | 30 | 0 | Table name | |||
2 | COLUMN_NAME | /SDF/COLUMNNAME | CHAR | 60 | 0 | Column name | |||
3 | PART_ID | /SDF/PARTID | INT4 | 10 | 0 | Partition ID | |||
4 | KEYFLAG | /SDF/PKFIELD | CHAR | 1 | 0 | Identifies a primary key field | |||
5 | HAS_INDEX | /SDF/SKFIELD | CHAR | 1 | 0 | Identifies a secondary key field | |||
6 | NOPK_TYPE | /SDF/NKFIELD | CHAR | 1 | 0 | Identify a table with no primary key | |||
7 | MS_TOTAL | /SDF/MS | DEC | 20 | 0 | Total memory size in bytes | |||
8 | MS_MAIN | /SDF/MAINS | DEC | 20 | 0 | Main memory size in bytes | |||
9 | EST_MS_MAIN | /SDF/ESTMS | DEC | 20 | 0 | Estimated memory size in bytes | |||
10 | RECORD_COUNT | /SDF/RECCOUNT | DEC | 20 | 0 | Number of records in the table | |||
11 | DISTINCT_COUNT | /SDF/DISTCOUNT | DEC | 20 | 0 | Disctinct count | |||
12 | LOADED | /SDF/LOADED | CHAR | 5 | 0 | Load status | |||
13 | INDEX_LOADED | /SDF/KEYLOADED | CHAR | 16 | 0 | Index load status | |||
14 | COMPRESSION_TYPE | /SDF/COPMTYPE | CHAR | 16 | 0 | Compression type | |||
15 | MS_DICT | /SDF/DICTMS | DEC | 20 | 0 | Dictionnary size in bytes | |||
16 | EST_MS_DICT | /SDF/ESTDICTMS | DEC | 20 | 0 | Estimated dictionnary size in bytes | |||
17 | MS_INDEX | /SDF/INDEXMS | DEC | 20 | 0 | Index memory size in bytes | |||
18 | EST_MS_INDEX | /SDF/ESTINDEXMS | DEC | 20 | 0 | Estimated index memory size in bytes | |||
19 | MS_DATA | /SDF/DATAMS | DEC | 20 | 0 | Data size in bytes | |||
20 | EST_MS_DATA | /SDF/ESTDATAMS | DEC | 20 | 0 | Estimated data memory size in bytes | |||
21 | MS_MISC | /SDF/MISCMS | DEC | 20 | 0 | Miscelaneous size in bytes | |||
22 | EST_MS_MISC | /SDF/ESTMISCMS | DEC | 20 | 0 | Estimated miscelaneous size in bytes | |||
23 | TYPEKIND | /SDF/DATATYPE | CHAR | 1 | 0 | Category of dictionnary type | |||
24 | SIZE_IN_BYTE | /SDF/FIELDSIZE | DEC | 16 | 2 | Average field size in bytes | |||
25 | LOB_SIZE_IN_BYTE | /SDF/LOBFIELDSIZE | DEC | 16 | 2 | Average LOB field size in bytes |
History
Last changed by/on | SAP | 20140922 |
SAP Release Created in | 2008_1_620 |