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

	Product	Version	Table	Columns	Indexes	Description	Module
Payroll :: Austria
1	ERP EHP7	6.0	T5A74	70	3	E18 Consolidation File	Austria

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	REVTY	Revision Type	char	1	0	Allow NULL?
4	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
5	ENDDA	End Date	nvarchar	8	0	Allow NULL?
6	SEQNR	Sequence Document Number	nvarchar	6	0	Allow NULL?
7	SETYP	Record Type for Electronic Notification	char	1	0	Allow NULL?
8	READY	Release Status for Electronic Transfer	char	1	0	Allow NULL?
9	SRTZA	Process Status for Consolidation and Notification Creation	nvarchar	3	0	Allow NULL?
10	EMETH	Electronic Notification Procedure	char	1	0	Allow NULL?
11	LZTYP	Payslip Data Category	char	1	0	Allow NULL?
12	UNAME	User Name	nvarchar	12	0	Allow NULL?
13	DATUM	Date	nvarchar	8	0	Allow NULL?
14	UZEIT	Time	nvarchar	6	0	Allow NULL?
15	PGMID	ABAP Program Name	nvarchar	40	0	Allow NULL?
16	EPRO2	ELDA Project	char	1	0	Allow NULL?
17	ESVGR	SI Group Transferring Data	char	1	0	Allow NULL?
18	EUSVA	ELDA: Insurance Agency as Data Recipient	nvarchar	2	0	Allow NULL?
19	WOBD0	Additional Classification Key for Employer	nvarchar	12	0	Allow NULL?
20	ZOBD0	Additional Classification Key for Employer	nvarchar	15	0	Allow NULL?
21	EDTNR	ELDA: Data Medium Number	nvarchar	6	0	Allow NULL?
22	ESANR	ELDA: Sequence Record Number for Each Data Medium	nvarchar	7	0	Allow NULL?
23	ESANI	ELDA: Number of the Corresponding Information Record	nvarchar	7	0	Allow NULL?
24	LFVER	Payslip Tax: Structure Version	nvarchar	2	0	Allow NULL?
25	TFDAT	Date of Transfer	nvarchar	8	0	Allow NULL?
26	TFTIM	Time of Transfer	nvarchar	6	0	Allow NULL?
27	FEHL1	Error ID for Electronic Notification Record	nvarchar	5	0	Allow NULL?
28	FEHL2	Error ID for Electronic Notification Record	nvarchar	5	0	Allow NULL?
29	FEHL3	Error ID for Electronic Notification Record	nvarchar	5	0	Allow NULL?
30	FEHL4	Error ID for Electronic Notification Record	nvarchar	5	0	Allow NULL?
31	FEHL5	Error ID for Electronic Notification Record	nvarchar	5	0	Allow NULL?
32	ESTAT	External Process Status	char	1	0	Allow NULL?
33	ANZA0	Payslip Tax: Number of Notifications (Current)	nvarchar	7	0	Allow NULL?
34	TTE18	Total Number of Annual E18 Payslips for DME	nvarchar	7	0	Allow NULL?
35	REFNR	Reference Number	nvarchar	30	0	Allow NULL?
36	AUSVL	1st Part of SI Number (Sequential Number)	nvarchar	4	0	Allow NULL?
37	AUSVG	2nd Part of SI Number (Birth Date)	nvarchar	8	0	Allow NULL?
38	ANNNA	Last Name	nvarchar	40	0	Allow NULL?
39	ANVNA	First Name	nvarchar	40	0	Allow NULL?
40	ANTIT	Title	nvarchar	15	0	Allow NULL?
41	GESCH	Gender Key	char	1	0	Allow NULL?
42	ANADR	Employee's Residential Address	nvarchar	60	0	Allow NULL?
43	ANLKZ	Vehicle Country Key for Home Address	nvarchar	3	0	Allow NULL?
44	ANPLZ	Postal Code of Residential Address	nvarchar	10	0	Allow NULL?
45	ANORT	Type of Residence	nvarchar	40	0	Allow NULL?
46	ANNUM	Tax Number - Employee	nvarchar	7	0	Allow NULL?
47	ANFZA	Tax Office Number of Employee (4-Digit)	nvarchar	4	0	Allow NULL?
48	LOHNB	Employer Assignment Unit	nvarchar	4	0	Allow NULL?
49	AGNUM	Employer Tax Number	nvarchar	7	0	Allow NULL?
50	AGFZA	Tax office number	nvarchar	4	0	Allow NULL?
51	AGDVR	Employer's Data Processing Number	nvarchar	7	0	Allow NULL?
52	AGNAM	Name of Employer	nvarchar	80	0	Allow NULL?
53	AGTIT	Title of Employer	nvarchar	30	0	Allow NULL?
54	AGADR	Address of Employer/Contracting Party/Benefits Provider	nvarchar	60	0	Allow NULL?
55	AGLKZ	Vehicle Country Key for Company Address of Empl./Contr.Party	nvarchar	3	0	Allow NULL?
56	AGZIP	Postal Code in Company Address of Employer, Contractng Party	nvarchar	10	0	Allow NULL?
57	AGORT	City in Company Address of Employer	nvarchar	40	0	Allow NULL?
58	LBTEL	Addresses: telephone no.	nvarchar	30	0	Allow NULL?
59	LBFAX	Fax number	nvarchar	31	0	Allow NULL?
60	LVNUM	Tax Number of Payroll Service Provider	nvarchar	7	0	Allow NULL?
61	LVFZA	Tax Office Number of Payroll Service Provider	nvarchar	4	0	Allow NULL?
62	LVDVR	Data Processing Number of Payroll Service Provider	nvarchar	7	0	Allow NULL?
63	ARTE0	Type of Payslip E18 (Service Provided)	nvarchar	2	0	Allow NULL?
64	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
65	KZ341	Remuneration (Without Sales Tax, Incl. Cost Reimb., P/K)	decimal	15	2
66	KZ344	Invoiced Sales Tax (KZ344)	decimal	15	2
67	KZ270	Employee's Contribution to Social Insurance	decimal	15	2
68	KZ271	Paid Contribution to Company Pension Fund (BV)	decimal	15	2
69	INPER	Last In-Period of Payroll in the Record	nvarchar	6	0	Allow NULL?
70	REFN0	Reference Number	nvarchar	30	0	Allow NULL?

Name	Primary	Unique	Type	Columns
T5A74~0	Yes	Yes	CLUSTERED	SEQNR, ENDDA, BEGDA, REVTY, PERNR, MANDT
T5A74~REF	No	No	NONCLUSTERED	REFN0, MANDT
T5A74~STA	No	No	NONCLUSTERED	SRTZA, MANDT

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

70 COLUMNS | 3 INDEXES | ERP 6.0 | T5A74 TABLE

TOP ERP 6.0 | T5A74 COLUMNS

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

70 COLUMNS | 3 INDEXES | ERP 6.0 | T5A74 TABLE

TOPERP 6.0 | T5A74 COLUMNS

TOPERP 6.0 | T5A74 INDEXES

TOP ERP 6.0 | T5A74 COLUMNS

TOP ERP 6.0 | T5A74 INDEXES