DB2_VIEW_IX_DETAILS SAP (DB2: structure for VIEW_DATA of ..._ACTION_DB02_IX_DETAILS) Structure details

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




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




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

DB2_VIEW_IX_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_IX_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_IX_DETAILS TYPE DB2_VIEW_IX_DETAILS.

The DB2_VIEW_IX_DETAILS table consists of various fields, each holding specific information or linking keys about DB2: structure for VIEW_DATA of ..._ACTION_DB02_IX_DETAILS data available in SAP. These include NAME (Index name), CREATOR (DB2 creator name), TBNAME (DB2 long table name), TBCREATOR (DB2 creator name).. 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_IX_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
NAMEIndex name DB2IXNAMLCHAR128
CREATORDB2 creator name DB2CREATORLCHAR128
TBNAMEDB2 long table name DB2TABNAMLCHAR128
TBCREATORDB2 creator name DB2CREATORLCHAR128
DBDB2 DB Name DB2DBNAMLCHAR24
IXSPACEIndex Space DB2IXSPACELCHAR24
TYPEIX Type DB2IXTYPCHAR34
UNIQUE_RULEunique rule DB2UNIQUERULECHAR40
CLUSTERYes / NO Flag DB2YESNOCHAR3
BPDB2 buffer pool name DB2BPNAMECHAR8DB2BPNAME
DS_SIZENatural Number INT4INT410INT4
COMPRESSEDYes / NO Flag DB2YESNOCHAR3
CLUSTERINGYes / NO Flag DB2YESNOCHAR3
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
LEAFDISTNatural Number INT4INT410INT4
LIMITKEYlimitkey DB2LIMITKEYCHAR128
FREEPAGE2 byte integer (signed) INT2INT25INT2
PCT_FREE2 byte integer (signed) INT2INT25INT2
STATSTIMECharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
GBPCACHEGroup buffer pool cache option DB2GBPCACHLCHAR8
FAROFFcardf DB2DB02CARDFDEC19
NEAROFFcardf DB2DB02CARDFDEC19
#ROWScardf DB2DB02CARDFDEC19
ALTEREDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
#DSNatural Number INT4INT410INT4
#EXTENTSNatural Number INT4INT410INT4
PSEUDO_DELNatural Number INT4INT410INT4
LEAFNEARNatural Number INT4INT410INT4
LEAFFARNatural Number INT4INT410INT4
CREATEDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
AVGKEYLENNatural Number INT4INT410INT4
TAB_HISTORY 0
FROM_INTERVALField type date, YYYYMMDD DB2DATEDATS8DB2DATE
TO_INTERVALField type date, YYYYMMDD DB2DATEDATS8DB2DATE
IT_IX 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_STRUCTURE 0
IT_COLS 0
TAB_PARTITIONS 0
IT_PARTITIONS 0
TAB_DATASETS 0
IT_DATASETS 0
TAB_DETAILS 0
ALLOC_KBSize in KB DB2SIZEKBDEC19
USED_KBSize in KB DB2SIZEKBDEC19
CREATEDTSCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
CLUSTERRATIO2 byte integer (signed) INT2INT25INT2
FIRSTKEYcardf DB2DB02CARDFDEC19
FULLKEYcardf DB2DB02CARDFDEC19
LAST_ALTERCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
PGSIZESize in bytes of the leaf pages in the index DB2IXPGSIZINT25DB2SINT
NLEAFNatural Number INT4INT410INT4
NLEVELS2 byte integer (signed) INT2INT25INT2
LAST_RUNSTCharacter Representation of DB2 Timestamp DB2TIMESTRINGCHAR26
AVG_LENNatural Number INT4INT410INT4
PADDEDIndex - padded DB2PADDEDCHAR24
NUM_PART2 byte integer (signed) INT2INT25INT2
PARTLIST 0

Key field Non-key field



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

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

How to access SAP table DB2_VIEW_IX_DETAILS

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