SAP DB4IDU0200 table - iSeries Database Performance: Used Indexes (Detail screen) details in SAP

SAP DB4IDU0200 table summary

Object Name: DB4IDU0200
Dictionary Type: Structure
Description: iSeries Database Performance: Used Indexes (Detail screen)

Field list for DB4IDU0200 table on an S/4 SAP system

Details

DB4IDU0200-SYSID table field - Name of SAP System ▼

Description: Name of SAP System
Field Name: SYSID
Data Element: SYSYSID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: SYCHAR08
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SYSID

DB4IDU0200-IPLTIME table field - Text field length 14 ▼

Description: Text field length 14
Field Name: IPLTIME
Data Element: CHAR14
Data Type: CHAR
length (Dec): 14(0)
Check table:
Conversion Routine:
Domain Name: CHAR14
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IPLTIME

DB4IDU0200-QQKEY table field - iSeries: Key Field (Database Monitor) ▼

Description: iSeries: Key Field (Database Monitor)
Field Name: QQKEY
Data Element: QQKEY
Data Type: CHAR
length (Dec): 17(0)
Check table:
Conversion Routine:
Domain Name: QQKEY
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQKEY

DB4IDU0200-QQILNM table field - iSeries: System Name of Index Library (Database Monitor) ▼

Description: iSeries: System Name of Index Library (Database Monitor)
Field Name: QQILNM
Data Element: QQILNM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQILNM

DB4IDU0200-QQIFNM table field - iSeries: System Name of Index (Database Monitor) ▼

Description: iSeries: System Name of Index (Database Monitor)
Field Name: QQIFNM
Data Element: QIFNM
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: DBINDEX
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIFNM

DB4IDU0200-QQTLN table field - iSeries: System Name of Library (Database Monitor) ▼

Description: iSeries: System Name of Library (Database Monitor)
Field Name: QQTLN
Data Element: QQTLN
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTLN

DB4IDU0200-QQTFN table field - iSeries: System Name of Table (Database Monitor) ▼

Description: iSeries: System Name of Table (Database Monitor)
Field Name: QQTFN
Data Element: QTFN
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTFN

DB4IDU0200-QQPTLN table field - iSeries: System Name of Base Library (Database Monitor) ▼

Description: iSeries: System Name of Base Library (Database Monitor)
Field Name: QQPTLN
Data Element: QQPTLN
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQTLN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPTLN

DB4IDU0200-QQPTFN table field - iSeries: System Name of Base Table (Database Monitor) ▼

Description: iSeries: System Name of Base Table (Database Monitor)
Field Name: QQPTFN
Data Element: QPTFN
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: AS4TAB
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPTFN

DB4IDU0200-QQLILN table field - iSeries: Index Library (Database Monitor) ▼

Description: iSeries: Index Library (Database Monitor)
Field Name: QQLILN
Data Element: QQLILN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLILN

DB4IDU0200-QQLIFN table field - iSeries: Index Name (Database Monitor) ▼

Description: iSeries: Index Name (Database Monitor)
Field Name: QQLIFN
Data Element: QQLIFN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLIFN

DB4IDU0200-QQLTLN table field - iSeries: Library Name (Database Monitor) ▼

Description: iSeries: Library Name (Database Monitor)
Field Name: QQLTLN
Data Element: QQLTLN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLTLN

DB4IDU0200-QQLTFN table field - iSeries: Table Name (Database Monitor) ▼

Description: iSeries: Table Name (Database Monitor)
Field Name: QQLTFN
Data Element: QQLTFN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLTFN

DB4IDU0200-QQLPTL table field - iSeries: Base Library (Database Monitor) ▼

Description: iSeries: Base Library (Database Monitor)
Field Name: QQLPTL
Data Element: QQLPTL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLPTL

DB4IDU0200-QQLPTF table field - iSeries: Base Table (Database Monitor) ▼

Description: iSeries: Base Table (Database Monitor)
Field Name: QQLPTF
Data Element: QQLPTF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQLPTF

DB4IDU0200-QQPLIB table field - iSeries: Package/Program Library (Database Monitor) ▼

Description: iSeries: Package/Program Library (Database Monitor)
Field Name: QQPLIB
Data Element: QQPLIB
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPLIB

DB4IDU0200-QQPNAM table field - iSeries: Package/Program Name (Database Monitor) ▼

Description: iSeries: Package/Program Name (Database Monitor)
Field Name: QQPNAM
Data Element: QQPNAM
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQC10
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQPNAM

DB4IDU0200-QQSNAM table field - iSeries: Statement Name (Database Monitor) ▼

Description: iSeries: Statement Name (Database Monitor)
Field Name: QQSNAM
Data Element: QQSNAM
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: QQC18
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSNAM

DB4IDU0200-QQCNT table field - iSeries: No. of Executions of a Statement (Database Monitor) ▼

Description: iSeries: No. of Executions of a Statement (Database Monitor)
Field Name: QQCNT
Data Element: QQCNT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCNT

DB4IDU0200-QQCIU table field - iSeries: Index Usage (Database Monitor) ▼

Description: iSeries: Index Usage (Database Monitor)
Field Name: QQCIU
Data Element: QQCIU
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCIU

DB4IDU0200-QQTOTR table field - iSeries: Total Rows in Table (Database Monitor) ▼

Description: iSeries: Total Rows in Table (Database Monitor)
Field Name: QQTOTR
Data Element: QTOTR
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQTOTR

DB4IDU0200-QQRROW table field - iSeries: Result Rows (Database Monitor) ▼

Description: iSeries: Result Rows (Database Monitor)
Field Name: QQRROW
Data Element: QQRROW
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQRROW

DB4IDU0200-QQAVGT table field - iSeries: Average Time (Database Monitor) ▼

Description: iSeries: Average Time (Database Monitor)
Field Name: QQAVGT
Data Element: QQAVGT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQAVGT

DB4IDU0200-TOTTIME table field - iSeries: Total Time (Database Monitor) ▼

Description: iSeries: Total Time (Database Monitor)
Field Name: TOTTIME
Data Element: TOTTIME
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTTIME

DB4IDU0200-QQMINT table field - iSeries: Minimum Time (Database Monitor) ▼

Description: iSeries: Minimum Time (Database Monitor)
Field Name: QQMINT
Data Element: QQMINT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQMINT

DB4IDU0200-QQMAXT table field - iSeries: Maximum Time (Database Monitor) ▼

Description: iSeries: Maximum Time (Database Monitor)
Field Name: QQMAXT
Data Element: QQMAXT
Data Type: DEC
length (Dec): 15(0)
Check table:
Conversion Routine:
Domain Name: QQDEC150
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQMAXT

DB4IDU0200-QQMETU table field - iSeries: Timest. of Most Expensive Stmt. (Database Monitor) ▼

Description: iSeries: Timest. of Most Expensive Stmt. (Database Monitor)
Field Name: QQMETU
Data Element: QQMETU
Data Type: CHAR
length (Dec): 26(0)
Check table:
Conversion Routine:
Domain Name: QQTIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQMETU

DB4IDU0200-QQCST table field - iSeries: Constraint Used (Y/N) (Database Monitor) ▼

Description: iSeries: Constraint Used (Y/N) (Database Monitor)
Field Name: QQCST
Data Element: QQCST
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: QQC11
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCST

DB4IDU0200-QQCSTN table field - iSeries: Constraint Name (Database Monitor) ▼

Description: iSeries: Constraint Name (Database Monitor)
Field Name: QQCSTN
Data Element: QQCSTN
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: DBINDEX
MemoryID:
AppClass: SDIC
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQCSTN

DB4IDU0200-QQIDXA table field - iSeries: Optimizer Advised Index (Database Monitor) ▼

Description: iSeries: Optimizer Advised Index (Database Monitor)
Field Name: QQIDXA
Data Element: QQIDXA
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: QQYN
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQIDXA

DB4IDU0200-QQRCOD table field - iSeries: Reason Code for Used Index (Database Monitor) ▼

Description: iSeries: Reason Code for Used Index (Database Monitor)
Field Name: QQRCOD
Data Element: QQRCODIDU
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: QQRCOD
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQRCOD

DB4IDU0200-QQSTTX_LEN table field - 2 Byte Signed Integer ▼

Description: 2 Byte Signed Integer
Field Name: QQSTTX_LEN
Data Element: INT2
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSTTX_LEN

DB4IDU0200-QQSTTX table field - iSeries: Statement Text (Database Monitor) ▼

Description: iSeries: Statement Text (Database Monitor)
Field Name: QQSTTX
Data Element: QQSTTX
Data Type: LCHR
length (Dec): 8000(0)
Check table:
Conversion Routine:
Domain Name: QQLCHR
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQSTTX

DB4IDU0200-QQUSER table field - iSeries: Job User (Database Monitor) ▼

Description: iSeries: Job User (Database Monitor)
Field Name: QQUSER
Data Element: QQUSER
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: QQUSER
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QQUSER

View list of all SAP tables(S4H/ECC)

Select data from SAP table