SAP Function ST04_DB4_GET_IDC_INFO - OS/400: Get index created info for ST04 Detail Analysis

Parameter Reference Type Length Default Optional Text
RESETFLAG DB4QQPAR-QRESET C 1 SPACE X Feld vom Typ CHAR z.Zt nicht verwendet

Parameter Reference Length Optional Text
IDC_0100 DB4IDC0100 387 X Overview info about indexes created performed
IDC_0200 DB4IDC0200 10094 X Detail index used info for tables specified
TABLES_FOR_DETAILS DB4TABLST 40 X List of tables for which details are requested

Exception Text
NO_DATA_FOUND No data found about indexes created
NO_DETAIL_DATA_FOUND No detail data found for tables specified
NO_TABLE_FOR_DETAIL_SPECIFIED Internal table TABLES_FOR_DETAILS is empty

Functionality
The function module collects data from the mySAP ERP databaseperformance tables about index creates performed.
This data is displayed in transaction ST04, Detail Analysis Menu, IndexCreates (the report executed is RSDB4IDC).

Use
The table parameters IDC_0100 and IDC_0200 are used for exportinginformation only. Data in them handed to the function module will beremoved.
The table parameter TABLES_FOR_DETAILS is used for importing tables forwhich detailed information about index creates performed on them isrequested.
The table parameter IDC_0100 (see reference structureDB4IDC0100) will contain overview information abouttables on which table scans were performed if the function module iscalled using this parameter .
The table parameter IDC_0200 (see reference structureDB4IDC0200) will contain detailed information abouttable scans performed on all tables listed in TABLES_FOR_DETAILS (seereference structure DB4TABLST).

Example
Exapmles on how to call the function module is to found inRSDB4IDC.