SAP BLOG BW Table Monitor

SAP Blog

Kayıtlı Üye
22 Ara 2017
Tepki puanı
Keeping BW system size under control is important for system performance and stability. There are many ways you can monitor table sizes. Some BW developers approach it from HANA native side, but I prefer from application side using CDS views (with is in line with BW/4HANA statistics approach). My BW table monitor program is helpful in many ways:

  • Monitor table sizes (find candidates for clean up and partitioning)
  • Overview data target types (find candidates for HANA optimization and BW/4HANA conversion)
  • Overview of PSAs (find candidates for housekeeping and ODP BW/4HANA conversion)


BW table monitor program is developed for BW on HANA and allows to monitor following tables:

  • HANA Optimized Cube F-Table
  • Standad Cube F-table
  • Standad Cube E-table
  • Classic DSO Active Table
  • Classic DSO Change Log Table
  • Classic DSO Inbound Queue
  • Advanced DSO Inbound Table
  • Advanced DSO Active Data Table
  • Advanced DSO Change Log
  • 3.x DataSource PSA
  • 7.x DataSource PSA

By default, data is sorted by table size descending allowing to focus on largest tables first, but you can filter and sort data any way you like.

ABAP program code and CDS view code can be downloaded from Github:

Okumaya devam et...