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

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

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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: France
1	ERP EHP7	6.0	PA0098	158	1	Infotype 0098 (Profit Sharing - France)	France

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	AATTR	Fiscal year	nvarchar	4	0	Allow NULL?
25	PARTI	Gross profit sharing	decimal	9	2
26	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
27	TOTAL	Annual pay	decimal	9	2
28	DOCSG	CSG on accumulated profit sharing	decimal	9	2
29	OPTIO	Profit sharing tax option	nvarchar	2	0	Allow NULL?
30	MOT01	Release reason	nvarchar	2	0	Allow NULL?
31	PAR01	Amount withdrawn	decimal	9	2
32	DAT01	Date of withdrawal	nvarchar	8	0	Allow NULL?
33	CSG01	CSG on interest (profit sharing)	decimal	9	2
34	MOT02	Release reason	nvarchar	2	0	Allow NULL?
35	PAR02	Amount withdrawn	decimal	9	2
36	DAT02	Date of withdrawal	nvarchar	8	0	Allow NULL?
37	CSG02	CSG on interest (profit sharing)	decimal	9	2
38	MOT03	Release reason	nvarchar	2	0	Allow NULL?
39	PAR03	Amount withdrawn	decimal	9	2
40	DAT03	Date of withdrawal	nvarchar	8	0	Allow NULL?
41	CSG03	CSG on interest (profit sharing)	decimal	9	2
42	MOT04	Release reason	nvarchar	2	0	Allow NULL?
43	PAR04	Amount withdrawn	decimal	9	2
44	DAT04	Date of withdrawal	nvarchar	8	0	Allow NULL?
45	CSG04	CSG on interest (profit sharing)	decimal	9	2
46	MOT05	Release reason	nvarchar	2	0	Allow NULL?
47	PAR05	Amount withdrawn	decimal	9	2
48	DAT05	Date of withdrawal	nvarchar	8	0	Allow NULL?
49	CSG05	CSG on interest (profit sharing)	decimal	9	2
50	MOT06	Release reason	nvarchar	2	0	Allow NULL?
51	PAR06	Amount withdrawn	decimal	9	2
52	DAT06	Date of withdrawal	nvarchar	8	0	Allow NULL?
53	CSG06	CSG on interest (profit sharing)	decimal	9	2
54	MOT07	Release reason	nvarchar	2	0	Allow NULL?
55	PAR07	Amount withdrawn	decimal	9	2
56	DAT07	Date of withdrawal	nvarchar	8	0	Allow NULL?
57	CSG07	CSG on interest (profit sharing)	decimal	9	2
58	MOT08	Release reason	nvarchar	2	0	Allow NULL?
59	PAR08	Amount withdrawn	decimal	9	2
60	DAT08	Date of withdrawal	nvarchar	8	0	Allow NULL?
61	CSG08	CSG on interest (profit sharing)	decimal	9	2
62	MOT09	Release reason	nvarchar	2	0	Allow NULL?
63	PAR09	Amount withdrawn	decimal	9	2
64	DAT09	Date of withdrawal	nvarchar	8	0	Allow NULL?
65	CSG09	CSG on interest (profit sharing)	decimal	9	2
66	MOT10	Release reason	nvarchar	2	0	Allow NULL?
67	PAR10	Amount withdrawn	decimal	9	2
68	DAT10	Date of withdrawal	nvarchar	8	0	Allow NULL?
69	CSG10	CSG on interest (profit sharing)	decimal	9	2
70	MOT11	Release reason	nvarchar	2	0	Allow NULL?
71	PAR11	Amount withdrawn	decimal	9	2
72	DAT11	Date of withdrawal	nvarchar	8	0	Allow NULL?
73	CSG11	CSG on interest (profit sharing)	decimal	9	2
74	MOT12	Release reason	nvarchar	2	0	Allow NULL?
75	PAR12	Amount withdrawn	decimal	9	2
76	DAT12	Date of withdrawal	nvarchar	8	0	Allow NULL?
77	CSG12	CSG on interest (profit sharing)	decimal	9	2
78	CRDS01	CRDS on interest (profit sharing)	decimal	9	2
79	CRDS02	CRDS on interest (profit sharing)	decimal	9	2
80	CRDS03	CRDS on interest (profit sharing)	decimal	9	2
81	CRDS04	CRDS on interest (profit sharing)	decimal	9	2
82	CRDS05	CRDS on interest (profit sharing)	decimal	9	2
83	CRDS06	CRDS on interest (profit sharing)	decimal	9	2
84	CRDS07	CRDS on interest (profit sharing)	decimal	9	2
85	CRDS08	CRDS on interest (profit sharing)	decimal	9	2
86	CRDS09	CRDS on interest (profit sharing)	decimal	9	2
87	CRDS10	CRDS on interest (profit sharing)	decimal	9	2
88	CRDS11	CRDS on interest (profit sharing)	decimal	9	2
89	CRDS12	CRDS on interest (profit sharing)	decimal	9	2
90	INT01	Part of interest in profit sharing release	decimal	9	2
91	INT02	Part of interest in profit sharing release	decimal	9	2
92	INT03	Part of interest in profit sharing release	decimal	9	2
93	INT04	Part of interest in profit sharing release	decimal	9	2
94	INT05	Part of interest in profit sharing release	decimal	9	2
95	INT06	Part of interest in profit sharing release	decimal	9	2
96	INT07	Part of interest in profit sharing release	decimal	9	2
97	INT08	Part of interest in profit sharing release	decimal	9	2
98	INT09	Part of interest in profit sharing release	decimal	9	2
99	INT10	Part of interest in profit sharing release	decimal	9	2
100	INT11	Part of interest in profit sharing release	decimal	9	2
101	INT12	Part of interest in profit sharing release	decimal	9	2
102	DOCRDS	CRDS on accumulated profit sharing	decimal	9	2
103	PRE_DAYS	Attendance days in fiscal year (profit sharing)	decimal	3	0
104	MOPAR	Profit sharing modifier	nvarchar	2	0	Allow NULL?
105	CUR01	Currency Key	nvarchar	5	0	Allow NULL?
106	CUR02	Currency Key	nvarchar	5	0	Allow NULL?
107	CUR03	Currency Key	nvarchar	5	0	Allow NULL?
108	CUR04	Currency Key	nvarchar	5	0	Allow NULL?
109	CUR05	Currency Key	nvarchar	5	0	Allow NULL?
110	CUR06	Currency Key	nvarchar	5	0	Allow NULL?
111	CUR07	Currency Key	nvarchar	5	0	Allow NULL?
112	CUR08	Currency Key	nvarchar	5	0	Allow NULL?
113	CUR09	Currency Key	nvarchar	5	0	Allow NULL?
114	CUR10	Currency Key	nvarchar	5	0	Allow NULL?
115	CUR11	Currency Key	nvarchar	5	0	Allow NULL?
116	CUR12	Currency Key	nvarchar	5	0	Allow NULL?
117	NPS01	SS contributions on interest	decimal	9	2
118	NPS02	SS contributions on interest	decimal	9	2
119	NPS03	SS contributions on interest	decimal	9	2
120	NPS04	SS contributions on interest	decimal	9	2
121	NPS05	SS contributions on interest	decimal	9	2
122	NPS06	SS contributions on interest	decimal	9	2
123	NPS07	SS contributions on interest	decimal	9	2
124	NPS08	SS contributions on interest	decimal	9	2
125	NPS09	SS contributions on interest	decimal	9	2
126	NPS10	SS contributions on interest	decimal	9	2
127	NPS11	SS contributions on interest	decimal	9	2
128	NPS12	SS contributions on interest	decimal	9	2
129	PLI01	Levy on interest deducted at source (profit sharing)	decimal	9	2
130	PLI02	Levy on interest deducted at source (profit sharing)	decimal	9	2
131	PLI03	Levy on interest deducted at source (profit sharing)	decimal	9	2
132	PLI04	Levy on interest deducted at source (profit sharing)	decimal	9	2
133	PLI05	Levy on interest deducted at source (profit sharing)	decimal	9	2
134	PLI06	Levy on interest deducted at source (profit sharing)	decimal	9	2
135	PLI07	Levy on interest deducted at source (profit sharing)	decimal	9	2
136	PLI08	Levy on interest deducted at source (profit sharing)	decimal	9	2
137	PLI09	Levy on interest deducted at source (profit sharing)	decimal	9	2
138	PLI10	Levy on interest deducted at source (profit sharing)	decimal	9	2
139	PLI11	Levy on interest deducted at source (profit sharing)	decimal	9	2
140	PLI12	Levy on interest deducted at source (profit sharing)	decimal	9	2
141	BSMOD	Annual pay	decimal	9	2
142	MUSER	User Name	nvarchar	12	0	Allow NULL?
143	DOFOSO	Forfait Social contribution on allocated profit sharing	decimal	9	2
144	RSA01	Other contribution amounts on interest	decimal	9	2
145	RSA02	Other contribution amounts on interest	decimal	9	2
146	RSA03	Other contribution amounts on interest	decimal	9	2
147	RSA04	Other contribution amounts on interest	decimal	9	2
148	RSA05	Other contribution amounts on interest	decimal	9	2
149	RSA06	Other contribution amounts on interest	decimal	9	2
150	RSA07	Other contribution amounts on interest	decimal	9	2
151	RSA08	Other contribution amounts on interest	decimal	9	2
152	RSA09	Other contribution amounts on interest	decimal	9	2
153	RSA10	Other contribution amounts on interest	decimal	9	2
154	RSA11	Other contribution amounts on interest	decimal	9	2
155	RSA12	Other contribution amounts on interest	decimal	9	2
156	PERCO	Including total of the collective pension savings plan	decimal	9	2
157	CCBAM	Including total of blocked current account	decimal	9	2
158	DADAM	Including amount on other devices	decimal	9	2

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

158 COLUMNS | 1 INDEXES | ERP 6.0 | PA0098 TABLE

TOP ERP 6.0 | PA0098 COLUMNS

TOP ERP 6.0 | PA0098 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

158 COLUMNS | 1 INDEXES | ERP 6.0 | PA0098 TABLE

TOPERP 6.0 | PA0098 COLUMNS

TOPERP 6.0 | PA0098 INDEXES

TOP ERP 6.0 | PA0098 COLUMNS

TOP ERP 6.0 | PA0098 INDEXES