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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Product	Version	Table	Columns	Indexes	Description	Module
Project System
1	ERP EHP7	6.0	PSHLP_CACHE_DB_N	20	4	Maintains Project Cache Information	Project System

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client ID	nvarchar	3	CLNT	(N'000')	No	*	SYMANDT	Allow NULL?
2	OBJNR	Object number	nvarchar	22	CHAR	(N' ')	No	*	J_OBJNR	Allow NULL?
3	PROJECT	Project Definition	nvarchar	24	CHAR	(N' ')	Yes		PS_PSPID	Allow NULL?
4	IND_NTWK	Order Number	nvarchar	12	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
5	OBJECT_TYPE		char	1		(N' ')	Yes			Allow NULL?
6	NTWK	Order Number	nvarchar	12	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
7	WBS	Work Breakdown Structure Element (WBS Element)	nvarchar	24	CHAR	(N' ')	Yes		PS_POSID	Allow NULL?
8	ACTY	Operation/Activity Number	nvarchar	4	CHAR	(N' ')	Yes		VORNR	Allow NULL?
9	MLST	Milestone number	nvarchar	12	NUMC	(N'000000000000')	Yes		MLST_ZAEHL	Allow NULL?
10	LOAD_DATE	Cache Load Date	nvarchar	8	DATS	(N'00000000')	Yes		CACHE_LOAD_DATE	Allow NULL?
11	EXPIRY_DATE	Cache Expiry Date	nvarchar	8	DATS	(N'00000000')	Yes		CACHE_EXPIRY_DATE	Allow NULL?
12	CHANGE_TYPE		char	1		(N' ')	Yes			Allow NULL?
13	USERNAME	User Name	nvarchar	12	CHAR	(N' ')	Yes		SYUNAME	Allow NULL?
14	HIERARCHY		image	2147483647			Yes
15	MASTERDATA		image	2147483647			Yes
16	STATUS		image	2147483647			Yes
17	STATUS_PROFILE		image	2147483647			Yes
18	ACL		image	2147483647			Yes
19	SHORTTEXT		image	2147483647			Yes
20	ACTY_RELATIONS		image	2147483647			Yes

Name	Primary	Unique	Type	Columns
PSHLP_CACHE_DB_NI1	No	No	NONCLUSTERED	PROJECT, MANDT
PSHLP_CACHE_DB_NI2	No	No	NONCLUSTERED	IND_NTWK, MANDT
PSHLP_CACHE_DB_NI3	No	No	NONCLUSTERED	WBS
PSHLP_CACHE_DB_N~0	Yes	Yes	CLUSTERED	OBJNR, MANDT