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
Product Lifecycle Management :: PLM Web User Interface :: Recipe Development
1	ERP EHP7	6.0	/PLMB/RCP_RECIPE	28	7	Recipes	Recipe Development

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RCP_GUID	Common Recipe GUID	varbinary	16	0
3	SUBRECN	Specification Key	nvarchar	20	0	Allow NULL?
4	ALT_NO	Alternative Recipe Identifier	nvarchar	3	0	Allow NULL?
5	VERS_NO	Recipe Version	nvarchar	3	0	Allow NULL?
6	RCP_TYPE_ID	Recipe Type	nvarchar	20	0	Allow NULL?
7	CREATED_BY	User Who Created Object (Item)	nvarchar	12	0	Allow NULL?
8	CREATED_TIMESTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
9	CHANGED_BY	User Who Last Changed Object	nvarchar	12	0	Allow NULL?
10	CHANGED_TIMESTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
11	COPIED_FROM	Recipe Copied From	varbinary	16	0
12	STATUS_SCHEMA	Status Scheme	nvarchar	20	0	Allow NULL?
13	STATUS	Status	nvarchar	20	0	Allow NULL?
14	RCP_USAGE	Recipe Purpose	nvarchar	5	0	Allow NULL?
15	DEL_IND	Marked for Deletion	char	1	0	Allow NULL?
16	RFO_GUID	Formula GUID	varbinary	16	0
17	RPR_GUID	Process GUID	varbinary	16	0
18	ARCHIVE_IND	Marked for Archiving	char	1	0	Allow NULL?
19	SEARCH_TERM	Search Term Generated from Single-Field Recipe Input	nvarchar	20	0	Allow NULL?
20	ECN	Change Number	nvarchar	12	0	Allow NULL?
21	VALID_FROM	Valid-From Date of a Recipe	nvarchar	8	0	Allow NULL?
22	VALID_TO	Valid-To Date of a Recipe	nvarchar	8	0	Allow NULL?
23	QTY_FROM	Quantity From	decimal	18	6
24	QTY_TO	Quantity To	decimal	18	6
25	UOM	Unit of Measure	nvarchar	3	0	Allow NULL?
26	DUMMY1		char	1	0	Allow NULL?
27	AUTHGRP	Authorization Group for Recipes	nvarchar	10	0	Allow NULL?
28	RCP_PROP_SUBRECN	Specification Key	nvarchar	20	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/PLMB/RCP_RECIPE00	No	No	NONCLUSTERED	VERS_NO, ALT_NO, SUBRECN, MANDT
/PLMB/RCP_RECIPE02	No	No	NONCLUSTERED	RFO_GUID, MANDT
/PLMB/RCP_RECIPE03	No	No	NONCLUSTERED	ECN, MANDT
/PLMB/RCP_RECIPE04	No	No	NONCLUSTERED	RPR_GUID, MANDT
/PLMB/RCP_RECIPE05	No	No	NONCLUSTERED	DEL_IND, MANDT
/PLMB/RCP_RECIPE06	No	No	NONCLUSTERED	RCP_PROP_SUBRECN, MANDT
/PLMB/RCP_RECIPE~0	Yes	Yes	CLUSTERED	RCP_GUID, MANDT