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

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Singapore
1	ERP EHP7	6.0	T5RSOP_SCH_ESOW	58	1	Stock Option Scheme for ESOW	Singapore

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	SCHEME_ID	Stock Option Plan for ESOW	nvarchar	4	0	CHAR	(N' ')	No		P25SOP_SCHEME_ID_ESOW	Allow NULL?
3	VALID_TO	Validity To Date	nvarchar	8	0	DATS	(N'00000000')	No		P25SOP_VALID_TO	Allow NULL?
4	VALID_FROM	Validity From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		P25SOP_VALID_FROM	Allow NULL?
5	AWARD	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	CHAR	(N' ')	Yes		CHAR4	Allow NULL?
6	GRANT_CURR	Currency key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	P25SOP_WAERS	Allow NULL?
7	GRANT_PRICE	Stock Option Grant Price	decimal	12	5	DEC	((0))	Yes		P25SOP_GRANT_PRICE
8	NO_PERCENTAGE	Stocks given in number or in percentage	char	1	0	CHAR	(N' ')	Yes		P25SOP_NO_PERCT	Allow NULL?
9	NO_OF_STOCKS1	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
10	VESTING_PRD1	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
11	VESTING_PD_UNT1	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
12	MORATORIUM_PRD1	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
13	MORATOR_PD_UNT1	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
14	NO_OF_STOCKS2	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
15	VESTING_PRD2	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
16	VESTING_PD_UNT2	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
17	MORATORIUM_PRD2	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
18	MORATOR_PD_UNT2	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
19	NO_OF_STOCKS3	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
20	VESTING_PRD3	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
21	VESTING_PD_UNT3	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
22	MORATORIUM_PRD3	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
23	MORATOR_PD_UNT3	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
24	NO_OF_STOCKS4	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
25	VESTING_PRD4	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
26	VESTING_PD_UNT4	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
27	MORATORIUM_PRD4	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
28	MORATOR_PD_UNT4	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
29	NO_OF_STOCKS5	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
30	VESTING_PRD5	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
31	VESTING_PD_UNT5	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
32	MORATORIUM_PRD5	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
33	MORATOR_PD_UNT5	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
34	NO_OF_STOCKS6	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
35	VESTING_PRD6	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
36	VESTING_PD_UNT6	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
37	MORATORIUM_PRD6	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
38	MORATOR_PD_UNT6	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
39	NO_OF_STOCKS7	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
40	VESTING_PRD7	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
41	VESTING_PD_UNT7	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
42	MORATORIUM_PRD7	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
43	MORATOR_PD_UNT7	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
44	NO_OF_STOCKS8	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
45	VESTING_PRD8	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
46	VESTING_PD_UNT8	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
47	MORATORIUM_PRD8	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
48	MORATOR_PD_UNT8	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
49	NO_OF_STOCKS9	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
50	VESTING_PRD9	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
51	VESTING_PD_UNT9	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
52	MORATORIUM_PRD9	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
53	MORATOR_PD_UNT9	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?
54	NO_OF_STOCKS10	Number of Stocks	decimal	18	3	DEC	((0))	Yes		P25SOP_NO_OF_STK
55	VESTING_PRD10	Vesting Period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_VEST_PRD	Allow NULL?
56	VESTING_PD_UNT10	Vesting Period Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_VEST_UNIT	Allow NULL?
57	MORATORIUM_PRD10	Moratorium period	nvarchar	4	0	NUMC	(N'0000')	Yes		P25SOP_MORT_PRD	Allow NULL?
58	MORATOR_PD_UNT10	Moratorium period unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	P25SOP_MORT_UNIT	Allow NULL?

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

58 COLUMNS | 1 INDEXES | ERP 6.0 | T5RSOP_SCH_ESOW TABLE

TOP ERP 6.0 | T5RSOP_SCH_ESOW COLUMNS

TOP ERP 6.0 | T5RSOP_SCH_ESOW INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

58 COLUMNS | 1 INDEXES | ERP 6.0 | T5RSOP_SCH_ESOW TABLE

TOPERP 6.0 | T5RSOP_SCH_ESOW COLUMNS

TOPERP 6.0 | T5RSOP_SCH_ESOW INDEXES

TOP ERP 6.0 | T5RSOP_SCH_ESOW COLUMNS

TOP ERP 6.0 | T5RSOP_SCH_ESOW INDEXES