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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	CARRID	Airline Code	nvarchar	3	0	CHAR	(N' ')	No	/SAPQUERY/TA00	/SAPQUERY/S_CARR_ID	Allow NULL?
3	CONNID	Flight Connection Number	nvarchar	4	0	NUMC	(N'0000')	No		/SAPQUERY/S_CONN_ID	Allow NULL?
4	COUNTRYFR	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	/SAPQUERY/TA03	LAND1	Allow NULL?
5	CITYFROM	City	nvarchar	20	0	CHAR	(N' ')	No	/SAPQUERY/TA03	/SAPQUERY/S_CITY	Allow NULL?
6	AIRPFROM	Departure airport	nvarchar	3	0	CHAR	(N' ')	No	/SAPQUERY/TA01	/SAPQUERY/S_FROMAIRP	Allow NULL?
7	COUNTRYTO	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	/SAPQUERY/TA03	LAND1	Allow NULL?
8	CITYTO	Arrival city	nvarchar	20	0	CHAR	(N' ')	No	/SAPQUERY/TA03	/SAPQUERY/S_TO_CITY	Allow NULL?
9	AIRPTO	Destination airport	nvarchar	3	0	CHAR	(N' ')	No	/SAPQUERY/TA01	/SAPQUERY/S_TOAIRP	Allow NULL?
10	FLTIME	Flight time	int	10	0	INT4	((0))	No		/SAPQUERY/S_FLTIME	Allow NULL?
11	DEPTIME	Departure time	nvarchar	6	0	TIMS	(N'000000')	No		/SAPQUERY/S_DEP_TIME	Allow NULL?
12	ARRTIME	Arrival time	nvarchar	6	0	TIMS	(N'000000')	No		/SAPQUERY/S_ARR_TIME	Allow NULL?
13	DISTANCE	Distance	decimal	9	4	QUAN	((0))	No		/SAPQUERY/S_DISTANCE
14	DISTID	Mass unit of distance (kms, miles)	nvarchar	3	0	UNIT	(N' ')	No	*	/SAPQUERY/S_DISTID	Allow NULL?
15	FLTYPE	Flight type	char	1	0	CHAR	(N' ')	No		/SAPQUERY/S_FLTYPE	Allow NULL?
16	PERIOD	Arrival n day(s) later	tinyint	3	0	INT1	((0))	No		/SAPQUERY/S_PERIOD

Name	Primary	Unique	Type	Columns
/SAPQUERY/T000~0	Yes	Yes	CLUSTERED	CONNID, CARRID, MANDT
/SAPQUERY/T000~001	No	No	NONCLUSTERED	CITYTO, CITYFROM, MANDT
/SAPQUERY/T000~A	No	No	NONCLUSTERED	DEPTIME
/SAPQUERY/T000~ARP	No	No	NONCLUSTERED	AIRPTO, AIRPFROM, MANDT