Rv_I_HdbTabSizes

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view Rv_I_HdbTabSizes.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RVITABSIZE

CREATE VIEW Rv_I_HdbTabSizes AS
SELECT
  sizing_guid AS sizingGuid,
  table_name AS tableName,
  part_id AS partId,
  tlogo,
  object_name AS objectName,
  tab_type AS tableType,
  store_type AS storeType,
  cast( cast (division(src_db_size, 1024, 1) as abap.dec(20,1) ) as rsvs_src_db_size ) AS srcDbSize,
  cast( cast (division(abap_size, 1024, 1) as abap.dec(20,1) ) as rsvs_abap_size ) AS abapSize,
  cast( cast (division(hana_size, 1024, 1) as abap.dec(20,1) ) as rsvs_hana_size ) AS hanaSize,
  record_count AS recordCount,
  records_sampled AS recordsSampled,
  cast( cast (division(data_size_sample, 1024, 1) as abap.dec(20,1) ) as rsvs_data_size_sample ) AS dataSizeSample,
  cast( cast (division(lob_size_sampled, 1024, 1) as abap.dec(20,1) ) as rsvs_lob_size_sampled ) AS logSizeSampled,
  cast( cast (division(data_size, 1024, 1) as abap.dec(20,1) ) as rsvs_data_size ) AS dataSize,
  cast( cast (division(lob_size, 1024, 1) as abap.dec(20,1) ) as rsvs_lob_size ) AS logSize,
  cast( cast (division(hana_index_size, 1024, 1) as abap.dec(20,1) ) as rsvs_hana_index_size ) AS hanaIndexSize
FROM rsvhdbtabsizes
;