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 :: Italy
1	ERP EHP7	6.0	T5ITII	59	1	Sickness handling c/INPS table	Italy

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	TRFAR	Pay scale type	nvarchar	2	Allow NULL?
3	TRFGB	Pay Scale Area	nvarchar	2	Allow NULL?
4	TRFKZ	ES grouping for collective agreement provision	char	1	Allow NULL?
5	TPTRA	Absence treatment type	char	1	Allow NULL?
6	ENDDA	End Date	nvarchar	8	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	Allow NULL?
8	GGLM1	INPS sickness category: max no. of days	nvarchar	3	Allow NULL?
9	ABY1	Percentage type	nvarchar	2	Allow NULL?
10	WTMA1	Wage type: reimbursement / INPS sickness category	nvarchar	4	Allow NULL?
11	ABS1	Absence/attendance category	char	1	Allow NULL?
12	GGLM2	INPS sickness category: max no. of days	nvarchar	3	Allow NULL?
13	ABY2	Percentage type	nvarchar	2	Allow NULL?
14	WTMA2	Wage type: reimbursement / INPS sickness category	nvarchar	4	Allow NULL?
15	ABS2	Absence/attendance category	char	1	Allow NULL?
16	GGLM3	INPS sickness category: max no. of days	nvarchar	3	Allow NULL?
17	ABY3	Percentage type	nvarchar	2	Allow NULL?
18	WTMA3	Wage type: reimbursement / INPS sickness category	nvarchar	4	Allow NULL?
19	ABS3	Absence/attendance category	char	1	Allow NULL?
20	GGLM4	INPS sickness category: max no. of days	nvarchar	3	Allow NULL?
21	ABY4	Percentage type	nvarchar	2	Allow NULL?
22	WTMA4	Wage type: reimbursement / INPS sickness category	nvarchar	4	Allow NULL?
23	ABS4	Absence/attendance category	char	1	Allow NULL?
24	GGLM5	INPS sickness category: max no. of days	nvarchar	3	Allow NULL?
25	ABY5	Percentage type	nvarchar	2	Allow NULL?
26	WTMA5	Wage type: reimbursement / INPS sickness category	nvarchar	4	Allow NULL?
27	ABS5	Absence/attendance category	char	1	Allow NULL?
28	GGCAR	INPS grace days	nvarchar	2	Allow NULL?
29	WTGGC	Wage type: grace days	nvarchar	4	Allow NULL?
30	ABS6	Absence/attendance category	char	1	Allow NULL?
31	GGLMA	Max no. of paid sick days per year	nvarchar	3	Allow NULL?
32	WTGLM	Wage type: maximum number of days in the year	nvarchar	4	Allow NULL?
33	ABS7	Absence/attendance category	char	1	Allow NULL?
34	GGSN1	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
35	GGSN2	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
36	TPF1	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
37	TPF2	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
38	TPF3	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
39	TPF4	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
40	TPF5	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
41	TPF6	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
42	TPF7	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
43	TPF8	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
44	TPF9	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
45	TPF10	Public holiday type not reimbursed by INPS	char	1	Allow NULL?
46	TPGD1	Public holiday type - Sunday - not reimbursed by INPS	char	1	Allow NULL?
47	TPGD2	Public holiday type - Sunday - not reimbursed by INPS	char	1	Allow NULL?
48	TPGD3	Public holiday type - Sunday - not reimbursed by INPS	char	1	Allow NULL?
49	TPGD4	Public holiday type - Sunday - not reimbursed by INPS	char	1	Allow NULL?
50	WTGNI	Wage type: unpaid days	nvarchar	4	Allow NULL?
51	ABS8	Absence/attendance category	char	1	Allow NULL?
52	RIDO1	Hospitalization reduction coefficient	char	1	Allow NULL?
53	RIDO2	Hospitalization reduction coefficient	char	1	Allow NULL?
54	WTAMI	Wage-type sickness c/INPS advance payment	nvarchar	4	Allow NULL?
55	GGSN3	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
56	GGSN4	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
57	GGSN5	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
58	GGSN6	Sickness: weekday not reimbursed by INPS	nvarchar	2	Allow NULL?
59	GGSN7	Sickness: weekday not reimbursed by INPS	nvarchar	2	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

59 COLUMNS | 1 INDEXES | ERP 6.0 | T5ITII TABLE

TOP ERP 6.0 | T5ITII COLUMNS

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

59 COLUMNS | 1 INDEXES | ERP 6.0 | T5ITII TABLE

TOPERP 6.0 | T5ITII COLUMNS

TOPERP 6.0 | T5ITII INDEXES

TOP ERP 6.0 | T5ITII COLUMNS

TOP ERP 6.0 | T5ITII INDEXES