Show TOC

E2E Reporting: Database Size Locate this document in the navigation structure

Query Query: 0E2EREP_DBSIZE

 

This query is used in interactive reporting in the Technical Monitoring work center. It displays the total database size, the growth per day, and the used storage for the selected database. The query is displayed in the following interactive report:

  •   ABAP System   Capacity   Database  

The query is used in the Web Template 0E2EREP_DBLOAD_DETAIL (Interactive Reports: Database Growth (Detailed View)).

Note Note

For correct usage, this query must be used in the context of the Web template listed above. Using the query without this wrapper is not meaningful.

End of the note.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Type of Key Figure

0SMD_METY

= DB_KPI_dbsize_pfcl [DB_KPI_dbsize_pfcl]

= DB_KPI_dailygrowth_pfcl [DB_KPI_dailygrowth_pfcl]

= DB_KPI_usedspace_pfcl [DB_KPI_usedspace_pfcl]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Used Storage

Key Figure [1KYFNM] = Mean Value [0SMDAVG]

Metric Type [0SMD_METY] = DB_KPI_usedspace_pfcl [DB_KPI_usedspace_pfcl

Growth per Day

Key Figure [1KYFNM] = Mean Value [0SMDAVG]

Metric Type [0SMD_METY] = DB_KPI_dailygrowth_pfcl [DB_KPI_dailygrowth_pfcl

Total Storage

Key Figure [1KYFNM] = Mean Value [0SMDAVG]

Metric Type [0SMD_METY] = DB_KPI_dbsize_pfcl [DB_KPI_dbsize_pfcl]