RSVHDBTABSIZES

Transparent Table Temporary Data
17 Fields 1 CDS Views

Sizing estimation details for tables. Size is in KB not MB

RSVHDBTABSIZES is an SAP database table in S/4HANA. Sizing estimation details for tables. Size is in KB not MB. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Rv_I_HdbTabSizes view from Sizing estimation details for tables

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY sizing_guid rsv_sizing_guid Sizing GUID
KEY table_name rsv_tablename Table Name
KEY part_id rsv_partid Partition ID
tab_type rsvs_tab_type BW Table Type
store_type rsvs_store_type Store Indicator
src_db_size rsvs_src_db_size Table Size (MB)
abap_size rsvs_abap_size ABAP Table Size (MB)
hana_size rsvs_hana_size HANA Table Size (MB)
record_count rsvs_record_count Total Records
records_sampled rsvs_records_sampled Sample Set: Records
data_size_sample rsvs_data_size_sample Sampled Records Size
lob_size_sampled rsvs_lob_size_sampled Sampled LOB Size(MB)
data_size rsvs_data_size Table Size (in MB)
lob_size rsvs_lob_size Table LOB Size (MB)
hana_index_size rsvs_hana_index_size Size of HANA Indexes
object_name sobj_name Object Name
tlogo trobjtype Object Type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sizing estimation details for tables. Size is in KB not MB
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSVHDBTABSIZES (
    SIZING_GUID,       -- Sizing GUID [rsv_sizing_guid]
    TABLE_NAME,        -- Table Name [rsv_tablename]
    PART_ID,           -- Partition ID [rsv_partid]
    TAB_TYPE,          -- BW Table Type [rsvs_tab_type]
    STORE_TYPE,        -- Store Indicator [rsvs_store_type]
    SRC_DB_SIZE,       -- Table Size (MB) [rsvs_src_db_size]
    ABAP_SIZE,         -- ABAP Table Size (MB) [rsvs_abap_size]
    HANA_SIZE,         -- HANA Table Size (MB) [rsvs_hana_size]
    RECORD_COUNT,      -- Total Records [rsvs_record_count]
    RECORDS_SAMPLED,   -- Sample Set: Records [rsvs_records_sampled]
    DATA_SIZE_SAMPLE,  -- Sampled Records Size [rsvs_data_size_sample]
    LOB_SIZE_SAMPLED,  -- Sampled LOB Size(MB) [rsvs_lob_size_sampled]
    DATA_SIZE,         -- Table Size (in MB) [rsvs_data_size]
    LOB_SIZE,          -- Table LOB Size (MB) [rsvs_lob_size]
    HANA_INDEX_SIZE,   -- Size of HANA Indexes [rsvs_hana_index_size]
    OBJECT_NAME,       -- Object Name [sobj_name]
    TLOGO,             -- Object Type [trobjtype]
    PRIMARY KEY (SIZING_GUID, TABLE_NAME, PART_ID)
);

Learn More