DB2_VIEW_TS_DETAILS SAP (DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS) Structure details

Dictionary Type: Structure
Description: DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS




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




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

DB2_VIEW_TS_DETAILS 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 "DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS" 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_DB2_VIEW_TS_DETAILS TYPE DB2_VIEW_TS_DETAILS.

The DB2_VIEW_TS_DETAILS table consists of various fields, each holding specific information or linking keys about DB2: structure for VIEW_DATA of ..._ACTION_DB02_TS_DETAILS data available in SAP. These include SPACENAME (DB2 TS Name), SPACE_CREATOR (DB2 creator name), DBNAME (DB2 DB Name), NUM_PART (2 byte integer (signed)).. 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: Cannot Be Enhanced


SAP DB2_VIEW_TS_DETAILS 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
GENERAL_DATA 0
SPACENAMEDB2 TS Name DB2TSNAMLCHAR24
SPACE_CREATORDB2 creator name DB2CREATORLCHAR128
DBNAMEDB2 DB Name DB2DBNAMLCHAR24
NUM_PART2 byte integer (signed) INT2INT25INT2
SPACE_TYPETS: Type of object DB2TSTYPECHAR20
BPOOLDB2 buffer pool name DB2BPNAMECHAR8DB2BPNAME
NTABLES2 byte integer (signed) INT2INT25INT2
SEGSIZE2 byte integer (signed) INT2INT25INT2
ENCODING_SCHEMEDB2 Encoding DB2_ENCODINGCHAR20
MAXROWS2 byte integer (signed) INT2INT25INT2
DSSIZENatural Number INT4INT410INT4
MAXPARTITIONS2 byte integer (signed) INT2INT25INT2
BASE_TABLE_NAMEDB2 long table name DB2TABNAMLCHAR128
BASE_TABLE_CREATORDB2 creator name DB2CREATORLCHAR128
TAB_DETAILS 0
ALLOC_KBSize in KB DB2SIZEKBDEC19
USED_KBSize in KB DB2SIZEKBDEC19
CREATEDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
PGSIZE2 byte integer (signed) INT2INT25INT2
STATSTIMECharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
ALTEREDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
AVGROWLENNatural Number INT4INT410INT4
MAXROWSMaximum number of rows that DB2 will place on a data page DB2MROWINT25DB2MROW
DSSIZENatural Number INT4INT410INT4
TAB_TABLES 0
IT_TABLES 0
TAB_HISTORY 0
FROM_INTERVALField type date, YYYYMMDD DB2DATEDATS8DB2DATE
TO_INTERVALField type date, YYYYMMDD DB2DATEDATS8DB2DATE
IT_TABLESPACES 0
RANGERange for History ( daily, weekly, monthly ) DB2HIST_RANGECHAR8
RANGE_LIST 0
COLLAPSEDSingle-Character Indicator CHAR1CHAR1CHAR1
EXPANDEDSingle-Character Indicator CHAR1CHAR1CHAR1
RANGE_PREVRange for History ( daily, weekly, monthly ) DB2HIST_RANGECHAR8
HIST_KEEP_DAYSCount parameters NUMC4NUMC4NUMC4
HIST_KEEP_WEEKSCount parameters NUMC4NUMC4NUMC4
HIST_KEEP_MONTHSCount parameters NUMC4NUMC4NUMC4
TAB_PARTITIONS 0
IT_PARTITIONS 0
TAB_PART_DETAILS 0
PARTNO2 byte integer (signed) INT2INT25INT2
ALLOC_KBSize in KB DB2SIZEKBDEC19
USED_KBSize in KB DB2SIZEKBDEC19
PQTYNatural Number INT4INT410INT4
SQTY2 byte integer (signed) INT2INT25INT2
STORNAMEStorage group DB2STOGROUPCHAR128
FARINDREFNatural Number INT4INT410INT4
NEARINDREFNatural Number INT4INT410INT4
PERCACTIVE2 byte integer (signed) INT2INT25INT2
LIMITKEYlimitkey DB2LIMITKEYCHAR128
FREEPAGE2 byte integer (signed) INT2INT25INT2
PCTFREE2 byte integer (signed) INT2INT25INT2
COMPRESSYes / NO Flag DB2YESNOCHAR3
PAGE_SAVE2 byte integer (signed) INT2INT25INT2
STATSTIMECharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
GBPCACHEGroup buffer pool cache option DB2GBPCACHLCHAR8
CARDFcardf DB2DB02CARDFDEC19
ALTEREDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
DSNUMNatural Number INT4INT410INT4
EXTENTSNatural Number INT4INT410INT4
LOGICAL_PART2 byte integer (signed) INT2INT25INT2
CREATEDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
AVGROWLENNatural Number INT4INT410INT4
ROW_FORMATRow Format DB2ROWFORMATCHAR16
REORG_LR_TSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
FREE_SPACESize in KB DB2SIZEKBDEC19
PCT_USED2 byte integer (signed) INT2INT25INT2
LIST_VOLSerial number of the volume DB2VOLIDCHAR6CHAR6
TAB_DATASETS 0
IT_DATASETS 0
PARTLIST 0

Key field Non-key field



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

As DB2_VIEW_TS_DETAILS 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 DB2_VIEW_TS_DETAILS as there is no data to select.

How to access SAP table DB2_VIEW_TS_DETAILS

Within an ECC or HANA version of SAP you can also view further information about DB2_VIEW_TS_DETAILS 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!