Select data from sap tables HDB_

Display SAP table details
  



HDBNAVSYST - List of all HANAs with Database Status, Memory Size, etc.

HDBS_ABAP_COMPDESCR - ABAP component for RFC function module

HDBS_ATTR_DEF - HANA: Attribute Definition

HDBS_BO_VIEW - HANA: Business object view

HDBS_BUILD_VERSION - HANA: Build version

HDBS_BUILD_VERSION2 - HANA: Build version (patch level is added)

HDBS_CALCULATED_ATTRIBUTE - HANA: concatenate attribute information

HDBS_CALC_ATTRIBUTE - HANA: calculation attribute

HDBS_CONSTRAINTS_L - Constraints (no length limitation - also for INDEX_ID)

HDBS_EXPRESSION - HANA: expression

HDBS_FEMS_COMPRESS_MAP - Mapping between FEMS string and FEMS integer

HDBS_FOR_ALL_ENTRIES - Tupelfilter for TREX_EXT function modules

HDBS_FREESTYLE_ATTRIBUTE - HANA: Freestyle Attribute

HDBS_FREESTYLE_ATTRIBUTE2 - HANA: Freestyle Attribute

HDBS_FULLTEXT_INDEX - HANA: fulltext index parameters

HDBS_INDEX_DESCR - Index with description

HDBS_INDEX_RESULT - HANA: Index and Return code - no length limit

HDBS_JOIN_INDEX - HANA: Join index

HDBS_KEY_FIGURE - HANA: Key Figure

HDBS_KEY_FIGURE_2 - HANA: Key figure

HDBS_KEY_FIGURE_L - HANA: Key Figure

HDBS_QUERY_ENTRY - HANA: QueryEntry

HDBS_RUNTIME_MODE - HANA: runtime mode for data mining

HDBS_SQL_OPTION - SQL option (ex. RAWTOHEX)

HDBS_SQL_OPTION_FOR_WHERE - SQL option (ex. RAWTOHEX)

HDBS_STATIC_JOIN_CONDITION - HANA: Static join condition

HDBS_TABLE_GROUP - HANA: table group

HDBS_TABLE_METADATA - table meta data with no lenght information for column name

HDBS_TEXT_ANALYSIS_LANGUAGE - HANA: list of supported languages

HDBS_VIEW_ATTRIBUTE - HANA: View attribute

HDB_ABAPCLIENT - HANA: global parameters for ABAP Client

HDB_ABAPCLIENT2 - HANA: global parameters for ABAP Client

HDB_ABAPCLIENT_CUSTOMIZING - HANA: customizing for HANA-ABAP-Client

HDB_ACTIVE_STATEMENTS - Structure for application 'Active statements'

HDB_ALERTS - Fields of table _SYS_STATISTICS.ALERT_LAST_CHECK_INFORMATION

HDB_ALERT_CATEGORIES - Categories of HANA alerts

HDB_ALERT_CHECKS - Fields For Alert Last Check

HDB_ALERT_CHECKS_SCREEN - Screen: Alerts

HDB_ALERT_CURRENT - Fields For Current Alerts

HDB_ALERT_OLD - _sys_statistics.statistics_alerts

HDB_ALERT_THRESHOLDS - Fields for Thresholds display

HDB_APPL - ERP Accelerators: Applications

HDB_BACKUP_CAT - Screen: Backup Catalogue

HDB_BACKUP_CATALOGUE - M_BACKUP_CATALOG und M_BACKUP_CATALOG_FILES

HDB_BACKUP_CATALOGUE_MDB - SYS_DATABASES (MultiDB)

HDB_BACKUP_CAT_MDB - Screen: Backup Catalogue

HDB_BACKUP_CONFIG - HDB: Backup Configuration

HDB_BACKUP_CONFIG_RETENTION - Retention Policy

HDB_BACKUP_CONFIG_RETENTION_UI - Retention Policy UI

HDB_BLOCKED_TRANS - Screen: Blocked Transactions

HDB_CACHES - Screen: Caches

HDB_CHECK_ACTIONS - Check actions

HDB_COLUMN_TABLES_PART_SIZE - Table HOST_COLUMN_TABLES_PART_SIZE/GLOBAL_COLUMN_TABLES_SIZE

HDB_COLUMN_TABLES_PART_SIZEALV - Table HOST_COLUMN_TABLES_PART_SIZE

HDB_COLUMN_TABLES_PART_SIZE_A - HDB_COLUMN_TABLES_PART_SIZE (adhoc)

HDB_CONNECTIONS - Screen: Connections

HDB_CONNECTION_STATISTICS - Screen: Connection Statistics

HDB_DATABASE_NAME_PORT - database_name, host and port (MDB only)

HDB_DATA_VOL_PAGE_STATS - HDB: Data Volume Page Statistics

HDB_DBCON - ERP Accelerators: Connections

HDB_DB_SIZE - DB Size

HDB_DB_SIZE_SCREEN - DB Size

HDB_DETAILED_RESOURCE_UTIL - Screen: Detailed memory and cpu utilization for services

HDB_DISKS - Screen: Disks

HDB_EFFECTIVE_PRIVILEGES - SYS.EFFECTIVE_PRIVILEGES

HDB_EFFECTIVE_ROLES - SYS.EFFECTIVE_ROLES

HDB_ENGINE_HINT - HANA: store engine hint names (customizable)

HDB_EXECUTION_TRACE_EDITOR - Screen: Statistic Server Tables Display

HDB_EXPLAIN_PLAN_TABLE - Structure for EXPLAIN_PLAN_TABLE for EXPLAIN

HDB_EXP_STMNT_CONFIG - sys.m_expensive_statements config

HDB_F1_HELP - Screen: F1 Help

HDB_FAE_METADATA - Metadata info for FOR ALL ENTRIES (aka Tupel Filter)

HDB_FULL_DISK - Screen: Full Disk event handling

HDB_GLOBAL_COLUMN_TAB_SIZE - Table HOST_COLUMN_TABLES_PART_SIZE/GLOBAL_COLUMN_TABLES_SIZE

HDB_GLOBAL_CPU_STATISTICS - HDB: Global CPU Statistics

HDB_GLOBAL_DB_TRACE_CONFIG - Global Database Trace

HDB_GLOBAL_INTERNAL_EVENTS - HDB: Global Internal Events

HDB_GLOBAL_MEMORY_STATISTICS - HDB: Global Memory Statistics

HDB_GLOBAL_PERS_STATISTICS - HDB: Global Persistence Statistics

HDB_GLOBAL_ROWSTORE_TABLE_SIZA - HDB_GLOBAL_ROWSTORE_TABLE_SIZE (adhoc)

HDB_GLOBAL_ROWSTORE_TABLE_SIZE - _SYS_STATISTICS.GLOBAL_ROWSTORE_TABLES_SIZE

HDB_GLOBAL_TABLES_SIZE - HDB: Global Tables Size

HDB_GLOBAL_TABLE_PERSIST_STAT - _SYS_STATISTICS.GLOBAL_TABLE_PERSISTENCE_STATISTICS

HDB_GLOBAL_TABLE_PERSIST_STATA - HDB_GLOBAL_TABLE_PERSIST_STAT (adhoc)

HDB_HOST_JOB_HISTORY - _SYS_STATISTICS.HOST_JOB_HISTORY

HDB_HOST_JOB_HISTORY_SCREEN - History of Long-Running System Operations

HDB_HOST_MEMORY_STATISTICS - HDB: Host Memory Statistics

HDB_HOST_RESOURCE_UTIL_STATS - HDB: Host Resource Utilization statistics

HDB_HOST_VOLUME_FILES - HDB: Host Volume Files

HDB_INDEXES - Fields of view INDEX_COLUMNS

HDB_INDEXES_OVERVIEW - „HANA_Indexes_Overview“ from note 1969700

HDB_INDEXES_SCREEN - Screen: Indexes

HDB_INDEXES_SIZES - Fields of table M_RS_INDEXES (only ROW tables)

HDB_INDEX_SIZES - Inverted indexes + concatenated indexes

HDB_INDX_SERV_HEAP_MEM_STAT - HDB: Index Server Heap Memory Statistics

HDB_INIFILE_TREE_NODE - Screen: ALV tree for ini file node

HDB_JOB_BCKUP - HDB: Parameters of Backup Job

HDB_JOB_BCKUP_MDB - HDB: Parameters of Backup Job (MULTIDB version)

HDB_JOB_PROGRESS - Kernel Profiler Configuration

HDB_JOB_PROGRESS_EXT - Kernel Profiler Configuration

HDB_JOB_SCHEDULES - _SYS_XS.JOB_SCHEDULES

HDB_JOB_VERI - HDB: Parameters of Check Database Job

HDB_KERNEL_PROFILER_CONFIG - Kernel Profiler Configuration

HDB_LANDSCAPE_SRVHST_CONFIG - SYS.M_LANDSCAPE_HOST_CONFIGURATION per Service/Host

HDB_LANDSCAPE_SRVHST_CONFIGALV - SYS.M_LANDSCAPE_HOST_CONFIGURATION per Service/Host

HDB_LC_CONTAINER_STATISTICS - liveCache Container Statistics

HDB_LC_CONTAINER_STATISTICSALV - liveCache Container Statistics

HDB_LC_LOCK_STATISTICS - liveCache Lock Statistics

HDB_LC_LOCK_STATISTICS_ALV - liveCache Lock Statistics

HDB_LC_SCHEMA_STATISTICS - Schemas

HDB_LC_SCHEMA_STATISTICS_ALV - Schemas

HDB_LIVECACHE_LOCKS - liveCache locks

HDB_LIVECACHE_LOCKS_ALV - liveCache locks for ALV

HDB_LOAD_HISTORY_HOST - Hosts

HDB_LOAD_HISTORY_KPI - KPIs for M_LOAD_HISTORY_SERVICE

HDB_LOAD_UNIT_COLUMN_STRUC - Column wise load unit specification for storage parameters

HDB_LOG_FILES - Screen: Log Files

HDB_MEMORY - Screen: Memory

HDB_MERGED_TRACES - Screen for merged tarces

HDB_META_DATA_DESCR_S - Output Structure for REPLACE_PARAMETERS_IN_SQL

HDB_MSXXLIST_V6 - Structure of Server List with IPv6 Addresses

HDB_M_ACTIVE_STATEMENTS - M_ACTIVE_STATEMENTS

HDB_M_BLOCKED_TRANSACTIONS - Fields of table M_BLOCKED_TRANSACTIONS with lock owner info

HDB_M_CACHES - Fields:M_CACHES

HDB_M_CONNECTIONS - Fields of table M_CONNECTIONS with Statement String

HDB_M_CONNECTION_STATISTICS - Fields of table M_CONNECTION_STATISTICS

HDB_M_CS_TABLES - Fields of table SYS.M_CS_TABLES

HDB_M_CS_TABLES_EXT - Fields of table SYS.M_CS_TABLES

HDB_M_CS_TABLES_NUM - Fields of table SYS.M_CS_TABLES

HDB_M_DATA_VOL_PAGE_STAT - M_DATA_VOLUME_PAGE_STATISTICS

HDB_M_DATA_VOL_SUPERBL_STAT - M_DATA_VOLUME_SUPERBLOCK_STATISTICS

HDB_M_DISKS - Fields of table M_DISKS

HDB_M_DUMPS - Fields of view FULL_SYSTEM_INFO_DUMPS

HDB_M_DUMPS2 - Output of full_system_info_dump_create

HDB_M_ES_TABLES - Fields of table SYS.M_ES_TABLES

HDB_M_EVENTS - Fields of table M_EVENTS

HDB_M_EXPENSIVE_STATEMENTS - sys.m_expensive_statements

HDB_M_EXPENSIVE_STATEMENTS_ALV - sys.m_expensive_statements

HDB_M_HEAP_MEMORY - M_HEAP_MEMORY

HDB_M_HOST_INFORMATION - SYS.M_HOST_INFORMATION

HDB_M_HOST_RESOURCE_UTIL - Fields of table M_HOST_RESOURCE_UTILIZATION

HDB_M_INIFILES - Fields of monitoring view M_INIFILES

HDB_M_INIFILE_CONTENTS - Fields of table M_INIFILE_CONTENTS

HDB_M_INIFILE_CONTENTS_MDB - Fields of table M_INIFILE_CONTENTS

HDB_M_LANDSCAPE_HOST_CONFIG - SYS.M_LANDSCAPE_HOST_CONFIGURATION

HDB_M_LANDSCAPE_HOST_CONFIGALV - SYS.M_LANDSCAPE_HOST_CONFIGURATION

HDB_M_LICENSE - sys.m_license

HDB_M_LICENSES - sys.m_licenses

HDB_M_LICENSE_SCREEN - sys.m_license

HDB_M_LOAD_HISTORY_HOST - Host specific load history KPIs

HDB_M_LOAD_HISTORY_INFO - Load history KPI description

HDB_M_LOAD_HISTORY_SERVICE - Host specific load history KPIs

HDB_M_LOAD_HISTORY_SERVICE_ALV - Host specific load history KPIs

HDB_M_LOG_FILES - Fields of table M_LOG_FILES

HDB_M_MEMORY - sys.m_memory

HDB_M_MEMORY_ALV - sys.m_memory

HDB_M_MERGED_TRACES - Fields of M_MERGED_TRACES

HDB_M_MERGED_TRACES_EXT - Fields of M_MERGED_TRACES

HDB_M_MONITORS - Fields of table M_MONITORS

HDB_M_MONITOR_COLUMNS - Fields of table M_MONITOR_COLUMNS

HDB_M_PERFTRACE - Fields of table M_PERFTRACE

HDB_M_PERSISTENCE_STATISTICS - Fields of table M_TABLE_PERSISTENCE_STATISTICS

HDB_M_PLUGIN_MANIFESTS - Fields of table m_PLUGIN_MANIFESTS

HDB_M_QUERY_CACHED_PLANS - Fields of table M_QUERY_CACHED_PLANS

HDB_M_RECORD_LOCKS - Fields of table M_RECORD_LOCKS

HDB_M_RS_TABLES - Fields of table SYS.M_RS_TABLES

HDB_M_SERVICES - Fields of table M_SERVICES

HDB_M_SERVICE_COMPONENT_MEMORY - M_SERVICE_COMPONENT_MEMORY

HDB_M_SERVICE_REPLICATION - Fields of table M_SERVICE_REPLICATION

HDB_M_SERVICE_THREADS - Fields of table M_SERVICE_THREADS

HDB_M_SQL_PLAN_CACHE - sys.m_sql_plan_cache

HDB_M_SQL_PLAN_CACHE_ALV - sys.m_sql_plan_cache

HDB_M_SQL_PLAN_CACHE_PARAMETER - SYS.M_SQL_PLAN_CACHE_PARAMETERS

HDB_M_SQL_PLAN_CACHE_RESET - sys.m_sql_plan_cache_reset

HDB_M_SYS_INFO_STATEMENTS - sys.m_system_information_statements

HDB_M_SYS_INFO_STATEMENTS_ALV - sys.m_system_information_statements

HDB_M_TENANTS - Fields of table M_TENANTS

HDB_M_TRACEFILES - Fields of table HDB_M_TRACEFILES

HDB_M_TRACEFILES_MDB - Fields of table SYS_DATABASES.M_TRACEFILES

HDB_M_TRACEFILE_CONTENTS - Fields of table M_TRACEFILE_CONTENTS

HDB_M_TRANSACTIONS - Transactions

HDB_M_VOLUMES - Fields of table M_VOLUMES

HDB_M_VOLUME_FILES - M_VOLUME_FILES + M_LOG_SEGMENTS

HDB_M_VOLUME_IO_STATISTICS - M_VOLUME_IO_STATISTICS

HDB_M_VOLUME_IO_TOTAL_STATIST - M_VOLUME_IO_TOTAL_STATISTICS

HDB_M_WORKLOAD - Fields of table M_WORKLOAD

HDB_OMS_VERSIONS - OMS Versions

HDB_OMS_VERSIONS_ALV - OMS Versions for ALV

HDB_OVERVIEW - Screen: Overview

HDB_PLACEHOLDER - HAHA: store placeholder values (customizable)

HDB_PORTS_SERVICES - Ports and Services

HDB_PORTS_SERVICES_MDB - Ports and Services (MDC)

HDB_PROCEDURES - Procedures

HDB_PROCEDURES_SCREEN - Screen: Procedures

HDB_PROCEDURE_PARAMS - Procedure parameters

HDB_PROCEDURE_STATISTICS - OMS Monitor

HDB_PROCEDURE_STATISTICS_ALV - OMS Monitor for ALV

HDB_PYTHONTRACE - Screen: Python trace

HDB_PYTHONTRACE_STRUCT - Fields for displaying current Python trace settings.

HDB_P_QUERYPLANS - Structure for P_QUERYPLANS for EXPLAIN

HDB_QUERY_CACHED_PLANS - Screen: Query Cached Plans

HDB_RANGES - ERP Accelerators: Generic Restrictions

HDB_RANGES_STRUC - Generic Structure for RANGES

HDB_RECORD_LOCKS - Screen for Record Locks

HDB_REPLICATION - Screen: System Replication

HDB_RESOURCE_UTILIZATION - Data : Detailed memory and CPU information

HDB_SCALAR_VARIABLE - Scalar Variable

HDB_SCHEDULER_JOBS - SYS.SCHEDULER_JOBS

HDB_SCHEDULER_JOB_PARAMETERS - SYS.SCHEDULER_JOB_PARAMETERS

HDB_SCHEMAS - Schemas

HDB_SCHEMA_PROC_PARAM - Schema + Procdure + Parameter

HDB_SERVICES - Screen: Services

HDB_SERVICE_COMP_MEM - Screen: Service Component memory

HDB_SERVICE_CONFIGURATIONS - Service Configurations

HDB_SETLEAF - Return structure for HDB_SET_GET_LEAVES

HDB_SETLEAF1 - Leaf view for SLT hierarchy replication (primary)

HDB_SETLEAF2 - Leaf view for SLT hierarchy replication (secondary)

HDB_SETNODE - Node view for SLT hierarchy replication

HDB_SIZE_HISTORY - History of the DB Size

HDB_STATISTICS_LASTVALUES - _sys_statistics.statistics_lastvalues

HDB_STATISTICS_SCHEDULE - _SYS_STATISTICS.STATISTICS_SCHEDULE

HDB_STATISTICS_SERVER - Screen: Statistic Server Tables Display

HDB_STATUS - ERP Accelerators: Generic Status

HDB_S_APPL_CUSTOMIZING - Display Structure Application Customizing

HDB_S_APPL_CUST_SCREEN - Application Customizing: Screen Settings

HDB_S_APPL_SETTINGS - Display Structure Application Customizing

HDB_S_COLUM_DESCR - Fieldcatalog to compare ERP & HDB Table Columns

HDB_S_OBJECT_DETAIL - Object Details

HDB_S_OBJECT_DETAIL_APPL - Object Details (Including Application)

HDB_S_OBJECT_DETAIL_DISP - Object Details for GRID Display

HDB_S_OBJECT_DETAIL_DISP_APPL - Object Details for GRID Display (Including Application)

HDB_S_OLAP_ATTRIBUTE - OLAP-Definition Attribute

HDB_S_OLAP_JOIN - OLAP-Definition Join

HDB_S_OLAP_KEYFIGURE - OLAP-Definition Keyfigure

HDB_S_PARAMETERS - Parameters for Range and Status Check

HDB_S_RANGE - Range of Values

HDB_S_REQUIRED_OBJECT - Attributes of Required Objects

HDB_S_REQUIRED_OBJECT_APPL - Attributes of Required Objects (Including Application)

HDB_S_REQUIRED_OBJECT_APPL_DIS - Attributes of Required Objects (Including Application)

HDB_S_REQUIRED_OBJECT_DISP - Attributes of Required Objects

HDB_S_STATUS - ERP Accelerators: Generic Status

HDB_S_TABLE_DETAIL - Table Details

HDB_S_USER - HDBC User

HDB_S_VIEW_DETAIL - View Details

HDB_TABLELIST - Index with language

HDB_TABLES - Fields of table TABLES

HDB_TABLES_VIEWS - List of selected tables, views or monitoring views

HDB_TABLE_COLUMNS - Fields of table TABLE_COLUMNS

HDB_TABLE_EXPORT - Screen:Table Export

HDB_TABLE_IMPORT - Screen:Table Import

HDB_TABLE_LOCKS - Table Locks (Object Locks)

HDB_TABLE_SELECTION - Screen: Table/view selection

HDB_TABLE_SIZES - HANA Table Sizes History

HDB_TABULAR_VARIABLE - Tabular Variable

HDB_THREADS - Screen: Threads

HDB_THREADS_CANCEL_OPERATIONS - Screen: Threads

HDB_THRESHOLDS - Thresholds display

HDB_THRESHOLDS_SCREEN - Screen: Thresholds display

HDB_TOTAL_PHYSICAL_MEMORY - To show physical memory information

HDB_TRACE - HDB Trace

HDB_TRACEFILES - Screen: Tracefiles

HDB_TRACEFILES_MDB - Screen: Tracefiles (MultiDB)

HDB_TRACE_ALV - HDB Trace

HDB_TRACE_USER_E2E - User and E2E-Trace

HDB_TRACING - Tracing

HDB_TRANSACTIONS - Screen: Transactions

HDB_TREXVIADBSL - store TrexViaDbsl data for tool RHANA_TREXVIADBSL_ANALYZER

HDB_USERS_AND_ROLES - Screen for Display of Users and roles

HDB_USER_TRACE - User Specific Trace

HDB_VIEWS - Fields of table VIEWS

HDB_VIEW_COLUMNS - Fields of table VIEW_COLUMNS

HDB_VIEW_DISKS - Fields of table M_DISKS

HDB_VIEW_JOB_PROGRESS - Screen Elements for Configuration of the Kernel Profiler

HDB_VIEW_KERNEL_PROFILER - Screen Elements for Configuration of the Kernel Profiler

HDB_VIEW_STATISTICS_SERVER - Screen: Statistics Server

HDB_VIEW_TABLE_LOCKS - Table locks

HDB_VIEW_TENANTS_ADD - Screen: Tenant Creation

HDB_VIEW_TENANTS_OVERVIEW - Screen: Tenants Overview

HDB_VOLUMES - Screen:Volumes

HDB_WORKLOAD - Screen: Workload

HDB_WORKLOAD2 - Screen: Workload

Return Table index