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
Logistics - General :: Logistics Information System LIS :: Data Collection
1	ERP EHP7	6.0	S121	23	2	Material aggregation - POS	Data Collection

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	Allow NULL?
8	MATKL	Material Group	nvarchar	9	0	Allow NULL?
9	MATNR	Material Number	nvarchar	18	0	Allow NULL?
10	WERKS	Plant	nvarchar	4	0	Allow NULL?
11	AKTNR	Promotion	nvarchar	10	0	Allow NULL?
12	KSCHL	Condition type, sales	nvarchar	4	0	Allow NULL?
13	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
14	VWDAT	Pointer to administrative data	nvarchar	10	0	Allow NULL?
15	BASME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
16	WAERK	SD Document Currency	nvarchar	5	0	Allow NULL?
17	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
18	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
19	UMSGVO	Rtl price from sales as per receipts/aggreg.sales	decimal	19	2
20	UMSGEO	Sales transactions (till receipts) at cost	decimal	19	2
21	PRSNLS	Price reduction	decimal	19	2
22	PDIFF	Trnsctn price diff. between R/3 -> and sales price at POS	decimal	19	2
23	BZIRK	Sales district	nvarchar	6	0	Allow NULL?

Name	Primary	Unique	Type	Columns
S121~0	Yes	Yes	CLUSTERED	KSCHL, AKTNR, WERKS, MATNR, MATKL, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT
S121~VAB	No	No	NONCLUSTERED	MATNR, MANDT