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
Payroll :: Germany :: Construction Industry
1	ERP EHP7	6.0	T5DBF	91	1	Construction Industry Leave	Construction Industry

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	MOLGA	Country Grouping	nvarchar	2	0	Allow NULL?
3	MOURA	Personnel Subarea Grouping for Leave Types	nvarchar	2	0	Allow NULL?
4	TGG01	Pay Scale Area Group for Leave in Construction Industry	nvarchar	2	0	Allow NULL?
5	BAUTY	Employee Subgroup Grouping for Construction Pay	char	1	0	Allow NULL?
6	BAUTU	Employee Subgroup Subgrouping for Construction Ind. Leave	char	1	0	Allow NULL?
7	URALT	Minimum Age for Leave Entitlement	nvarchar	2	0	Allow NULL?
8	URBTZ	Minimum Length of Service for Leave Entitlement	nvarchar	2	0	Allow NULL?
9	BEHGR	Challenge Group for Leave Entitlement	nvarchar	2	0	Allow NULL?
10	ENDDA	End Date	nvarchar	8	0	Allow NULL?
11	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
12	URKAS	Leave Fund for Construction Industry	nvarchar	2	0	Allow NULL?
13	ERBTG	Determine Employment Days	char	1	0	Allow NULL?
14	ERAGL	Determine Adjustment Amounts	char	1	0	Allow NULL?
15	URAR1	Leave Type	nvarchar	2	0	Allow NULL?
16	VORL1	Propose Leave Type?	char	1	0	Allow NULL?
17	UTAG1	Leave Entitlement in Days	decimal	5	2
18	UDIV1	Leave Entitlement Divisor	decimal	6	4
19	GRGL1	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
20	GPRZ1	Vacation Bonus Percentage Rate	decimal	4	2
21	GBTR1	Vacation Bonus Amount	decimal	6	2
22	GLGA1	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
23	ERGL1	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
24	EPRZ1	Percentage Rate for Vacation Pay	decimal	4	2
25	ELGA1	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
26	URAR2	Leave Type	nvarchar	2	0	Allow NULL?
27	VORL2	Propose Leave Type?	char	1	0	Allow NULL?
28	UTAG2	Leave Entitlement in Days	decimal	5	2
29	UDIV2	Leave Entitlement Divisor	decimal	6	4
30	GRGL2	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
31	GPRZ2	Vacation Bonus Percentage Rate	decimal	4	2
32	GBTR2	Vacation Bonus Amount	decimal	6	2
33	GLGA2	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
34	ERGL2	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
35	EPRZ2	Percentage Rate for Vacation Pay	decimal	4	2
36	ELGA2	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
37	URAR3	Leave Type	nvarchar	2	0	Allow NULL?
38	VORL3	Propose Leave Type?	char	1	0	Allow NULL?
39	UTAG3	Leave Entitlement in Days	decimal	5	2
40	UDIV3	Leave Entitlement Divisor	decimal	6	4
41	GRGL3	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
42	GPRZ3	Vacation Bonus Percentage Rate	decimal	4	2
43	GBTR3	Vacation Bonus Amount	decimal	6	2
44	GLGA3	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
45	ERGL3	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
46	EPRZ3	Percentage Rate for Vacation Pay	decimal	4	2
47	ELGA3	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
48	URAR4	Leave Type	nvarchar	2	0	Allow NULL?
49	VORL4	Propose Leave Type?	char	1	0	Allow NULL?
50	UTAG4	Leave Entitlement in Days	decimal	5	2
51	UDIV4	Leave Entitlement Divisor	decimal	6	4
52	GRGL4	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
53	GPRZ4	Vacation Bonus Percentage Rate	decimal	4	2
54	GBTR4	Vacation Bonus Amount	decimal	6	2
55	GLGA4	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
56	ERGL4	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
57	EPRZ4	Percentage Rate for Vacation Pay	decimal	4	2
58	ELGA4	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
59	URAR5	Leave Type	nvarchar	2	0	Allow NULL?
60	VORL5	Propose Leave Type?	char	1	0	Allow NULL?
61	UTAG5	Leave Entitlement in Days	decimal	5	2
62	UDIV5	Leave Entitlement Divisor	decimal	6	4
63	GRGL5	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
64	GPRZ5	Vacation Bonus Percentage Rate	decimal	4	2
65	GBTR5	Vacation Bonus Amount	decimal	6	2
66	GLGA5	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
67	ERGL5	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
68	EPRZ5	Percentage Rate for Vacation Pay	decimal	4	2
69	ELGA5	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
70	URAR6	Leave Type	nvarchar	2	0	Allow NULL?
71	VORL6	Propose Leave Type?	char	1	0	Allow NULL?
72	UTAG6	Leave Entitlement in Days	decimal	5	2
73	UDIV6	Leave Entitlement Divisor	decimal	6	4
74	GRGL6	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
75	GPRZ6	Vacation Bonus Percentage Rate	decimal	4	2
76	GBTR6	Vacation Bonus Amount	decimal	6	2
77	GLGA6	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
78	ERGL6	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
79	EPRZ6	Percentage Rate for Vacation Pay	decimal	4	2
80	ELGA6	Wage Type for Vacation Pay	nvarchar	4	0	Allow NULL?
81	URAR7	Leave Type	nvarchar	2	0	Allow NULL?
82	VORL7	Propose Leave Type?	char	1	0	Allow NULL?
83	UTAG7	Leave Entitlement in Days	decimal	5	2
84	UDIV7	Leave Entitlement Divisor	decimal	6	4
85	GRGL7	Vacation Bonus Rule	nvarchar	2	0	Allow NULL?
86	GPRZ7	Vacation Bonus Percentage Rate	decimal	4	2
87	GBTR7	Vacation Bonus Amount	decimal	6	2
88	GLGA7	Wage Type Vacation Bonus	nvarchar	4	0	Allow NULL?
89	ERGL7	Vacation Pay Rule	nvarchar	2	0	Allow NULL?
90	EPRZ7	Percentage Rate for Vacation Pay	decimal	4	2
91	ELGA7	Wage Type for Vacation Pay	nvarchar	4	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

91 COLUMNS | 1 INDEXES | ERP 6.0 | T5DBF TABLE

TOP ERP 6.0 | T5DBF COLUMNS

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

91 COLUMNS | 1 INDEXES | ERP 6.0 | T5DBF TABLE

TOPERP 6.0 | T5DBF COLUMNS

TOPERP 6.0 | T5DBF INDEXES

TOP ERP 6.0 | T5DBF COLUMNS

TOP ERP 6.0 | T5DBF INDEXES