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	T5A71	131	3	L16 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	TTL16	Total Number of Annual Payslips L16 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	LOHNB	Employer Assignment Unit	nvarchar	4	0	Allow NULL?
47	AGNUM	Employer Tax Number	nvarchar	7	0	Allow NULL?
48	AGFZA	Tax office number	nvarchar	4	0	Allow NULL?
49	AGDVR	Employer's Data Processing Number	nvarchar	7	0	Allow NULL?
50	AGNAM	Name of Employer	nvarchar	80	0	Allow NULL?
51	AGTIT	Title of Employer	nvarchar	30	0	Allow NULL?
52	AGADR	Address of Employer/Contracting Party/Benefits Provider	nvarchar	60	0	Allow NULL?
53	AGLKZ	Vehicle Country Key for Company Address of Empl./Contr.Party	nvarchar	3	0	Allow NULL?
54	AGZIP	Postal Code in Company Address of Employer, Contractng Party	nvarchar	10	0	Allow NULL?
55	AGORT	City in Company Address of Employer	nvarchar	40	0	Allow NULL?
56	LVNUM	Tax Number of Payroll Service Provider	nvarchar	7	0	Allow NULL?
57	LVFZA	Tax Office Number of Payroll Service Provider	nvarchar	4	0	Allow NULL?
58	LVDVR	Data Processing Number of Payroll Service Provider	nvarchar	7	0	Allow NULL?
59	ARTL0	Type of Payslip L16	nvarchar	2	0	Allow NULL?
60	UDV16	Interruption of Work Relationship According to L16	char	1	0	Allow NULL?
61	SOZSL	Social Status (Last Status in Payslip Period)	nvarchar	2	0	Allow NULL?
62	SOZSA	Social Status for Last Salary in Payslip Period	nvarchar	2	0	Allow NULL?
63	SOZS2	Social Status (If Worker w/ Tax-Free Amt for Agric. Laborer)	nvarchar	2	0	Allow NULL?
64	SOZS0	Social Status	nvarchar	2	0	Allow NULL?
65	TVOLL	No. of Days with Full-Time Employment in Payslip Period	decimal	15	2
66	TTEIL	No. of Days with Part-Time Employment in Payslip Period	decimal	15	2
67	KVOLL	Indicator: Employee Mainly in Full Employment	char	1	0	Allow NULL?
68	KAVAB	Indicator: Tax Reduction for Single Earners Included	char	1	0	Allow NULL?
69	KAEAB	Indicator: Tax Reduction for Single Parents Included	char	1	0	Allow NULL?
70	STAKD	Number of Children of Employee (Tax)	decimal	2	0
71	PASVL	SI Number of Spouse/Partner (Sequential Number)	nvarchar	4	0	Allow NULL?
72	PASVG	SI Number of Spouse/Partner (Date of Birth)	nvarchar	8	0	Allow NULL?
73	STBDT	Death Date	nvarchar	8	0	Allow NULL?
74	PGVON	Date as of Which Nursing Allowance Is Received	nvarchar	8	0	Allow NULL?
75	PGBIS	Date Until Which Nursing Allowance Is Received	nvarchar	8	0	Allow NULL?
76	SEUVR	Increased Accident Annuity Exists (Checkbox)	decimal	15	2
77	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
78	KZ210	210: Gross Pay Sec. 25 (W/o Sec. 26, W/o Family Allowance)	decimal	15	2
79	KZ215	215: Tax-Exempt Payments According to Section 68	decimal	15	2
80	KZ220	220: Pmnts Acc. to Sec.67 Para.1+2 (Within Y/6 Before SI)	decimal	15	2
81	KZIEB	IEB: Total SI Contributions Deducted, CC, HS	decimal	15	2
82	KZ225	225: SI Contribs for Payments Acc. to Key Fig. 220	decimal	15	2
83	KZ226	226: SI Contrib. f. Pmnts Acc. to Sec. 67 Par. 3-8	decimal	15	2
84	KZ230	230: Adjusted SI Contributions	decimal	15	2
85	KZ240	240: Tax-Free Amt for Agricultural Laborer Acc. to Sec. 104	decimal	15	2
86	KZAUS	AUS: Emplymnt Abroad Acc. to Sec. 3 Par. 1, Lines 10 and 11	decimal	15	2
87	KZPEN	PEN: Commuter Rate Acc. to Sec. 16 Para. 1, Line 6	decimal	15	2
88	KZEFB	EFB: Deducted Voluntary Amounts Acc. to Sec. 16 Par. 1 L 3b	decimal	15	2
89	KZSTF	STF: Tax-Free or Flat-Rate-Taxed Pmnts Acc.to Sec.67 (3-8)	decimal	15	2
90	KZSSB	SSB: Other Tax-Exempt Payments	decimal	15	2
91	KZ243	243: Total Remaining Deductions	decimal	15	2
92	KZ245	245: Taxable Payments	decimal	15	2
93	KZIEL	IEL: Total Employment Tax Deducted	decimal	15	2
94	KZABL	ABL: Deducted Empl.Tax w/ Fixed Rates Acc.to Sec.67 Par.3-8	decimal	15	2
95	KZ260	260: Imputable Employment Tax	decimal	15	2
96	KZSOB	SOB: Other Payments Acc.to Sec.67 (2,6,19) Acc.to EmpTxRate	decimal	15	2
97	KZFB1	FB1: Exemption Included According to Sec. 105	decimal	15	2
98	KZVSV	VSV: SI Assessment Basis Used for Special Payments	decimal	15	2
99	KZFB2	FB2: Exemption Included Acc. to Notification Acc. to Sec. 63	decimal	15	2
100	KZAUF	AUF: Church/OeGB Contributions Included in Recalculation	decimal	15	2
101	KZFB3	FB3: Exemption Included According to Sec. 35	decimal	15	2
102	KZNEB	NEB: Pmnts Not to Be Entered Acc.to Sec.25 Par.1 Line 2a+3a	decimal	15	2
103	KZPFG	KZPFG Nursing Allowance Paid	decimal	15	2
104	KZSFB	SFB: Tax-Exempt Payments Acc. to Sec. 26 Line 4	decimal	15	2
105	KZHA1	KZHA1 Hardship Compensation KZ245 Accident Pension	decimal	15	2
106	KZHA2	KZHA2 Hardshp Comp. KZ220 Accdnt Pens.(Sec.67 Par1+2 Bef.SI)	decimal	15	2
107	KZHA3	KZHA3 Hardship Cmpsn KZ225 Accident Pens. (Withheld SI Con.)	decimal	15	2
108	KZUEB	UEB: Paid Transfer Amount to BV	decimal	15	2
109	KFB01	Family Allowance, Amount Paid from Own Funds (January)	char	1	0	Allow NULL?
110	KFB02	Family Allowance, Amount Paid from Own Funds (February)	char	1	0	Allow NULL?
111	KFB03	Family Allowance, Amount Paid from Own Funds (March)	char	1	0	Allow NULL?
112	KFB04	Family Allowance, Amount Paid from Own Funds (April)	char	1	0	Allow NULL?
113	KFB05	Family Allowance, Amount Paid from Own Funds (May)	char	1	0	Allow NULL?
114	KFB06	Family Allowance, Amount Paid from Own Funds (June)	char	1	0	Allow NULL?
115	KFB07	Family Allowance, Amount Paid from Own Funds (July)	char	1	0	Allow NULL?
116	KFB08	Family Allowance, Amount Paid from Own Funds (August)	char	1	0	Allow NULL?
117	KFB09	Family Allowance, Amount Paid from Own Funds (September)	char	1	0	Allow NULL?
118	KFB10	Family Allowance, Amount Paid from Own Funds (October)	char	1	0	Allow NULL?
119	KFB11	Family Allowance, Amount Paid from Own Funds (November)	char	1	0	Allow NULL?
120	KFB12	Family Allowance, Amount Paid from Own Funds (December)	char	1	0	Allow NULL?
121	KZAPK	KZAPK Employer's Contributions to Foreign Pension Funds	decimal	15	2
122	INPER	Last In-Period of Payroll in the Record	nvarchar	6	0	Allow NULL?
123	KEPAB	Increased Deductible Amount for Pensioners Included	char	1	0	Allow NULL?
124	KZENT	KZENT Income for Aid Workers	decimal	15	2
125	KZPRE	KZPRE Lump Sum Travel Expense Allowance	decimal	15	2
126	KWERK	KWERK Company Transportation (No. of Calendar Months)	nvarchar	2	0	Allow NULL?
127	REFN0	Reference Number	nvarchar	30	0	Allow NULL?
128	KZPEND	KZPEND Commuter Deduction	decimal	15	2
129	KUEBMO	KUEBMO Use of Car (Number of Calendar Months)	nvarchar	2	0	Allow NULL?
130	KZSROL	KZSROL Extraordinary Costs Recalculation	decimal	15	2
131	ALAND	ISO Code of Country or DTC	nvarchar	2	0	Allow NULL?

Name	Primary	Unique	Type	Columns
T5A71~0	Yes	Yes	CLUSTERED	SEQNR, ENDDA, BEGDA, REVTY, PERNR, MANDT
T5A71~REF	No	No	NONCLUSTERED	REFN0, MANDT
T5A71~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

131 COLUMNS | 3 INDEXES | ERP 6.0 | T5A71 TABLE

TOP ERP 6.0 | T5A71 COLUMNS

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

131 COLUMNS | 3 INDEXES | ERP 6.0 | T5A71 TABLE

TOPERP 6.0 | T5A71 COLUMNS

TOPERP 6.0 | T5A71 INDEXES

TOP ERP 6.0 | T5A71 COLUMNS

TOP ERP 6.0 | T5A71 INDEXES