SAP DB4IDA0100 table - iSeries: Database Performance: Advised Indexes (Main screen) details in SAP

SAP DB4IDA0100 table summary

Object Name: DB4IDA0100
Dictionary Type: Structure
Description: iSeries: Database Performance: Advised Indexes (Main screen)

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

Details

DB4IDA0100-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

DB4IDA0100-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

DB4IDA0100-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

DB4IDA0100-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

DB4IDA0100-QQQRYCNT table field - iSeries: Number of Different Statements (Database Monitor) ▼

Description: iSeries: Number of Different Statements (Database Monitor)
Field Name: QQQRYCNT
Data Element: QQQRYCNT
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 QQQRYCNT

DB4IDA0100-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

DB4IDA0100-QQCIA table field - iSeries: Index Advice (Database Monitor) ▼

Description: iSeries: Index Advice (Database Monitor)
Field Name: QQCIA
Data Element: QQCIA
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 QQCIA

DB4IDA0100-QQIDACNT table field - iSeries: Index Advice (Database Monitor) ▼

Description: iSeries: Index Advice (Database Monitor)
Field Name: QQIDACNT
Data Element: QQIDACNT
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 QQIDACNT

DB4IDA0100-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

DB4IDA0100-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

DB4IDA0100-QQARSS table field - iSeries: Average Result Set Size (Database Monitor) ▼

Description: iSeries: Average Result Set Size (Database Monitor)
Field Name: QQARSS
Data Element: QQARSS
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 QQARSS

DB4IDA0100-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

DB4IDA0100-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