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
Plant Maintenance :: Maintenance Processing :: Capacity and Resource Planning
1	ERP EHP7	6.0	/MRSS/D_RM_CAND	29	4	Candidates for Demands	Capacity and Resource Planning

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	GUID	GUID	varbinary	16	0
3	ROLE_TYPE	Abstract Partner Role	nvarchar	10	0	Allow NULL?
4	PARTNER_ID	Partner ID	nvarchar	20	0	Allow NULL?
5	PARTNER_ROLE	Partner Function	nvarchar	8	0	Allow NULL?
6	STATUS	Candidate Status	nvarchar	5	0	Allow NULL?
7	REJ_CODE	Candidate Rejection Code	nvarchar	2	0	Allow NULL?
8	COMMENTS	Comments for Partner	nvarchar	255	0	Allow NULL?
9	CREATEDON	Time Stamp - Long Format	nvarchar	21	0	Allow NULL?
10	CREATED_BY	Entered by	nvarchar	12	0	Allow NULL?
11	CHANGEDON	Time Stamp - Long Format	nvarchar	21	0	Allow NULL?
12	CHANGEDBY	Last changed by	nvarchar	12	0	Allow NULL?
13	VERSION_NO	Version Number	nvarchar	10	0	Allow NULL?
14	STATUS_OBJ_KEY	Object number	nvarchar	22	0	Allow NULL?
15	START_DATE	Proposed Start Date	nvarchar	8	0	Allow NULL?
16	END_DATE	Proposed End Date	nvarchar	8	0	Allow NULL?
17	STAFFED_DAYS	Staffed Days	decimal	4	1
18	SOFT_BOOK_EXP	Soft Booking Expiry Date	nvarchar	8	0	Allow NULL?
19	VENDOR_CONS_NAME	Partner Consultant name	nvarchar	40	0	Allow NULL?
20	VENDOR_COST_RATE	Vendor Cost Rate	decimal	13	2
21	VENDOR_RATE_CURR	Currency Key	nvarchar	5	0	Allow NULL?
22	FOUR_BY_TEN_IND	Boolean Variable	char	1	0	Allow NULL?
23	ASSGN_EXIST	Boolean Variable	char	1	0	Allow NULL?
24	BOOK_TYPE	Booking Type	nvarchar	10	0	Allow NULL?
25	BOOK_TYPE_DESC	Booking type text	nvarchar	60	0	Allow NULL?
26	SP_GROUP	Searching Party Group	nvarchar	8	0	Allow NULL?
27	SP_ID	Searching Party Name	nvarchar	8	0	Allow NULL?
28	ORIGIN_TYPE	RM Origin Type	char	1	0	Allow NULL?
29	ORIGIN_ID	GUID	varbinary	16	0

Name	Primary	Unique	Type	Columns
/MRSS/D_RM_CAND~0	Yes	Yes	CLUSTERED	PARTNER_ROLE, PARTNER_ID, ROLE_TYPE, GUID, CLIENT
/MRSS/D_RM_CAND~DE	No	No	NONCLUSTERED	PARTNER_ID, GUID
/MRSS/D_RM_CAND~PA	No	No	NONCLUSTERED	PARTNER_ID
/MRSS/D_RM_CAND~ST	No	No	NONCLUSTERED	STATUS_OBJ_KEY