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

	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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DCT_PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
3	DCT_SEQNR	Sequence Number	nvarchar	5	0	Allow NULL?
4	DCT_ROWID	Unique Row Number	nvarchar	5	0	Allow NULL?
5	SEPDT	Separation Date	nvarchar	8	0	Allow NULL?
6	CRPAY	Correction Pay	decimal	11	2
7	ADPAY	Additional pay	decimal	11	2
8	EXPAY	Extra Pay	decimal	11	2
9	NAPPR	National pension separation pay convertible amount	decimal	11	2
10	HPY00	Honorary Separation Pay	decimal	11	2
11	IPY00	Insurance Separation Pay	decimal	11	2
12	SVRPR	Service Period in Previous Companies	nvarchar	3	0	Allow NULL?
13	DUPPR	Duplicated Service Period in Previous Company	nvarchar	3	0	Allow NULL?
14	CURR1	Currency Key	nvarchar	5	0	Allow NULL?
15	BUS01	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
16	SPY01	Previous separation pay	decimal	11	2
17	HPY01	Previous honorary separation pay	decimal	11	2
18	IPY01	Previous insurance separation pay	decimal	11	2
19	INT01	Income tax paid in the previous company	decimal	9	2
20	RET01	Resident tax paid in the previous company	decimal	9	2
21	SET01	Previous special tax	decimal	11	2
22	EDT01	Entry date of previous company	nvarchar	8	0	Allow NULL?
23	LDT01	Previous company leave date	nvarchar	8	0	Allow NULL?
24	BUS02	Previous Company / Taxpayer Association Business Number	nvarchar	12	0	Allow NULL?
25	SPY02	Previous separation pay	decimal	11	2
26	HPY02	Previous honorary separation pay	decimal	11	2
27	IPY02	Previous insurance separation pay	decimal	11	2
28	INT02	Income tax paid in the previous company	decimal	9	2
29	RET02	Resident tax paid in the previous company	decimal	9	2
30	SET02	Previous special tax	decimal	11	2
31	EDT02	Entry date of previous company	nvarchar	8	0	Allow NULL?
32	LDT02	Previous company leave date	nvarchar	8	0	Allow NULL?
33	CURR2	Currency Key	nvarchar	5	0	Allow NULL?
34	LSPDT	Separation pay base date	nvarchar	8	0	Allow NULL?
35	ASVRY	Actual service years	nvarchar	2	0	Allow NULL?
36	ASVRM	Actual service months	nvarchar	2	0	Allow NULL?
37	ASVRD	Actual service days	nvarchar	2	0	Allow NULL?
38	ACSVR	Actual service period	decimal	10	5
39	RDSVR	Adjusted service period	decimal	10	5
40	WESVR	Weighted service period	decimal	10	5
41	TXSVR	Service perid for tax calculation	nvarchar	2	0	Allow NULL?
42	SVRHO	Service period for tax calculation of honorary payment	nvarchar	2	0	Allow NULL?
43	VALDT	Valuation Date of Monthly Average Income for Separation Pay	nvarchar	8	0	Allow NULL?
44	AGPDT	Agreed Payment Date in case of Mid-separation	nvarchar	8	0	Allow NULL?
45	TXEMP	Exemption of Calculated Separation Tax	char	1	0	Allow NULL?
46	EXMLS	Excluded Months for Final Separation	nvarchar	3	0	Allow NULL?
47	EXMHO	Excluded Months for Total Separation Payment	nvarchar	3	0	Allow NULL?
48	EXMPC	Excluded Months for Mid-Separation	nvarchar	3	0	Allow NULL?
49	OVSCT	Tax Credit for Oversea	decimal	9	2
50	OSCHO	Tax Credit for Oversea Honorable	decimal	9	2
51	TEP01	Tax Exemption in Previous Separation Payment	char	1	0	Allow NULL?
52	TEP02	Tax Exemption in Previous Separation Payment	char	1	0	Allow NULL?
53	RETID	Retirement Reason	nvarchar	2	0	Allow NULL?
54	PSPAD	Adjusted Previous Service Period	nvarchar	3	0	Allow NULL?
55	DUPAD	Adjusted Duplicated Service Period	nvarchar	3	0	Allow NULL?
56	ADJST	Infotype Subtype	char	1	0	Allow NULL?
57	DPA01	Contribution Amount	decimal	11	2
58	DPA02	Contribution Amount	decimal	11	2
59	ADDPC	Added Months Before 2013	nvarchar	3	0	Allow NULL?
60	EXMBF	Excluded Months Before 2013	nvarchar	3	0	Allow NULL?
61	EXMAF	Excluded Months After 2013	nvarchar	3	0	Allow NULL?
62	ADDAF	Added Months After 2013	nvarchar	3	0	Allow NULL?
63	PAYRP	Applicable to Retirement Pension	char	1	0	Allow NULL?
64	TSVRD	Total Service Days	nvarchar	5	0	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

64 COLUMNS | 1 INDEXES | ERP 6.0 | P2KR_KRSP1 TABLE

TOP ERP 6.0 | P2KR_KRSP1 COLUMNS

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

64 COLUMNS | 1 INDEXES | ERP 6.0 | P2KR_KRSP1 TABLE

TOPERP 6.0 | P2KR_KRSP1 COLUMNS

TOPERP 6.0 | P2KR_KRSP1 INDEXES

TOP ERP 6.0 | P2KR_KRSP1 COLUMNS

TOP ERP 6.0 | P2KR_KRSP1 INDEXES