DBA_DBH_COLL_TPL SAP (DBA-DBH: Collector Configuration Template) Structure details

Dictionary Type: Structure
Description: DBA-DBH: Collector Configuration Template




ABAP Code to SELECT data from DBA_DBH_COLL_TPL
Related tables to DBA_DBH_COLL_TPL
Access table DBA_DBH_COLL_TPL




Structure field list including key, data, relationships and ABAP select examples

DBA_DBH_COLL_TPL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DBA-DBH: Collector Configuration Template" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DBA_DBH_COLL_TPL TYPE DBA_DBH_COLL_TPL.

The DBA_DBH_COLL_TPL table consists of various fields, each holding specific information or linking keys about DBA-DBH: Collector Configuration Template data available in SAP. These include DBSYS (Database system), DBREL (DBA-DBH: Database minimal Release), DBMAX (DBA-DBH: Database maximal Release (not included)), CLASS (DBA-DBH: Collector/Extractor Class).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP DBA_DBH_COLL_TPL structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TEMPLATE_ID DBA-DBH: Template ID0
DBSYSDatabase system DBCON_DBMSCHAR3DBCON_DBMS
DBREL DBA-DBH: Database minimal Release0
DBMAX DBA-DBH: Database maximal Release (not included)0
CLASS DBA-DBH: Collector/Extractor Class0
COLLECT_DTRUN DBA-DBH: Time difference between snapshots in minutes0
COLLECT_SETUP DBA-DBH: Setup Collect0
COLLECT_FIRSTRUN DBA-DBH: First Execution of Data Collection0
COLLECT_LEVELDBA-DBH: Level DBA_DBH_LEVELINT25
CHECK_DTRUN DBA-DBH: Time difference between checks in minutes0
CHECK_SETUP DBA-DBH: Setup Check0
CHECK_FIRSTRUN DBA-DBH: First Execution of Check0
REMOVE_DTRUN DBA-DBH: Time difference between data removal in minutes0
REMOVE_SETUP DBA-DBH: Setup Data Removal0
REMOVE_FIRSTRUN DBA-DBH: First Execution of Data Removal0
CATEGORY DBA-DBH: Collector Category0

Key field Non-key field



How do I retrieve data from SAP structure DBA_DBH_COLL_TPL using ABAP code?

As DBA_DBH_COLL_TPL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DBA_DBH_COLL_TPL as there is no data to select.

How to access SAP table DBA_DBH_COLL_TPL

Within an ECC or HANA version of SAP you can also view further information about DBA_DBH_COLL_TPL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!