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
Production Planning and Control :: Basic Data :: Routing
1	ERP EHP7	6.0	MAPL	25	3	Assignment of Task Lists to Materials	Routing

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	MATNR	Material Number	nvarchar	18	Allow NULL?
3	WERKS	Plant	nvarchar	4	Allow NULL?
4	PLNTY	Task List Type	char	1	Allow NULL?
5	PLNNR	Key for Task List Group	nvarchar	8	Allow NULL?
6	PLNAL	Group Counter	nvarchar	2	Allow NULL?
7	ZKRIZ	Counter for additional criteria	nvarchar	7	Allow NULL?
8	ZAEHL	Internal counter	nvarchar	8	Allow NULL?
9	DATUV	Valid-From Date	nvarchar	8	Allow NULL?
10	TECHV	Technical status from	nvarchar	12	Allow NULL?
11	AENNR	Change Number	nvarchar	12	Allow NULL?
12	LOEKZ	Deletion Indicator	char	1	Allow NULL?
13	PARKZ	Indicator: inactive changes	char	1	Allow NULL?
14	ANDAT	Date record created on	nvarchar	8	Allow NULL?
15	ANNAM	User who created record	nvarchar	12	Allow NULL?
16	AEDAT	Changed On	nvarchar	8	Allow NULL?
17	AENAM	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
18	LIFNR	Vendor Account Number	nvarchar	10	Allow NULL?
19	KUNR	Account number of customer	nvarchar	10	Allow NULL?
20	SUCHFELD	Search Field for Customer-Specific Task List Selection	nvarchar	20	Allow NULL?
21	VBELN	Sales Document	nvarchar	10	Allow NULL?
22	POSNR	Sales Document Item	nvarchar	6	Allow NULL?
23	PSPNR	Work breakdown structure element (WBS element)	nvarchar	8	Allow NULL?
24	MS_OBJECT	Object for Multiple Specifications	nvarchar	30	Allow NULL?
25	MS_OBJTYPE	Type of Object for Multiple Specifications	nvarchar	2	Allow NULL?

Name	Primary	Unique	Type	Columns
MAPL~0	Yes	Yes	CLUSTERED	ZAEHL, ZKRIZ, PLNAL, PLNNR, PLNTY, WERKS, MATNR, MANDT
MAPL~A	No	No	NONCLUSTERED	PLNNR
MAPL~B	No	No	NONCLUSTERED	AENNR, MANDT