ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Database Interface, Database Platforms :: DB2 for AS4
1	ERP EHP7	6.0	DB4TABLE_HIST	25	3	History of Table Sizes in the Database	DB2 for AS4

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	DBHOST	Application Server	nvarchar	32	Allow NULL?
2	SCHEMANAME		nvarchar	10	Allow NULL?
3	TABNAME	Table name	nvarchar	30	Allow NULL?
4	ANDAT	Analysis date (yyyymmddhhmm)	nvarchar	12	Allow NULL?
5	TABNAME_LONG	Table name	nvarchar	30	Allow NULL?
6	VWTYP	Single-Character Indicator	char	1	Allow NULL?
7	TABSIZE	Used blocks of a table in KB	decimal	11
8	CURROWS	Number of rows in a table	decimal	15
9	INDBS	Used blocks of an index-Btree (kb)	decimal	15
10	DLTROWS	iSeries: Number of rows / object size	decimal	15
11	NUMOPEN	iSeries: Number of rows / object size	decimal	15
12	NUMCLOSE	iSeries: Number of rows / object size	decimal	15
13	NUMINSERT	iSeries: Number of rows / object size	decimal	15
14	NUMUPDATE	iSeries: Number of rows / object size	decimal	15
15	NUMDELETE	iSeries: Number of rows / object size	decimal	15
16	NUMLREAD	iSeries: Number of rows / object size	decimal	15
17	NUMPREAD	iSeries: Number of rows / object size	decimal	15
18	NUMCST	iSeries: Number of rows / object size	decimal	15
19	CSTSIZE	iSeries: Number of rows / object size	decimal	15
20	CRTDATE	Date	nvarchar	8	Allow NULL?
21	CRTTIME	Character field of length 6	nvarchar	6	Allow NULL?
22	SAVDATE	Date	nvarchar	8	Allow NULL?
23	SAVTIME	Character field of length 6	nvarchar	6	Allow NULL?
24	RSTDATE	Date	nvarchar	8	Allow NULL?
25	RSTIME	Character field of length 6	nvarchar	6	Allow NULL?

Name	Primary	Unique	Type	Columns
DB4TABLE_HIST~0	Yes	Yes	CLUSTERED	ANDAT, TABNAME, SCHEMANAME, DBHOST
DB4TABLE_HIST~1	No	No	NONCLUSTERED	ANDAT, SAVTIME, SAVDATE, SCHEMANAME, DBHOST
DB4TABLE_HIST~DAM	No	No	NONCLUSTERED	VWTYP, ANDAT