	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

90 columns | ERP 6.0 | BETPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	P2AR_ARCIMP	Tax results	10	BETPE	Payroll: Amount per unit	decimal	15	2
2	P2BG_BG_CUX	Difference table of payroll results	14	BETPE	Payroll: Amount per unit	decimal	15	2
3	P2BG_BG_DIF	Difference table of payroll results	14	BETPE	Payroll: Amount per unit	decimal	15	2
4	P2BR_BRAVERAGE	Frozen averages	9	BETPE	Payroll: Amount per unit	decimal	15	2
5	P2CN_CNREI	Payroll result: structure for retro difference details	21	BETPE	Payroll: Amount per unit	decimal	15	2
6	P2CN_CNREO	Payroll result: structure for retro difference details	21	BETPE	Payroll: Amount per unit	decimal	15	2
7	P2CO_COAVA	PC2CO_AVA	35	BETPE	Payroll: Amount per unit	decimal	15	2
8	P2FI_SCRT	Tax result table for Finland, cumulated wage type level	8	BETPE	Payroll: Amount per unit	decimal	15	2
9	P2FI_SIRT	SI result table for Finland, cumulated wage type level	8	BETPE	Payroll: Amount per unit	decimal	15	2
10	P2HK_RETI	Payroll structure for retroactive accounting	23	BETPE	Payroll: Amount per unit	decimal	15	2
11	P2HK_RETO	Payroll structure for retroactive accounting	23	BETPE	Payroll: Amount per unit	decimal	15	2
12	P2HR_CUF	Structure of difference table Croatia	8	BETPE	Payroll: Amount per unit	decimal	15	2
13	P2HR_CUP	Structure of difference table Croatia	8	BETPE	Payroll: Amount per unit	decimal	15	2
14	P2HR_DTF	Structure of difference table Croatia	8	BETPE	Payroll: Amount per unit	decimal	15	2
15	P2HR_DTP	Structure of difference table Croatia	8	BETPE	Payroll: Amount per unit	decimal	15	2
16	P2HR_HR_CUX	Structure of difference table for tax calculation	7	BETPE	Payroll: Amount per unit	decimal	15	2
17	P2HR_HR_DPA	Structure of difference table for tax calculation	7	BETPE	Payroll: Amount per unit	decimal	15	2
18	P2IS_RETI	Payroll structure for retroactive accounting	23	BETPE	Payroll: Amount per unit	decimal	15	2
19	P2IS_RETO	Payroll structure for retroactive accounting	23	BETPE	Payroll: Amount per unit	decimal	15	2
20	P2KZ_FUP	Structure for Table FUP - Future Periods	18	BETPE	Payroll: Amount per unit	decimal	15	2
21	P2KZ_KZAV	Cumulations for Calculation of Averages	14	BETPE	Payroll: Amount per unit	decimal	15	2
22	P2NZ_SALSAC	Salary Sacrifice Details	20	BETPE	Payroll: Amount per unit	decimal	15	2
23	P2RA_DFRT	Payroll Result for Other Payroll Periods	21	BETPE	Payroll: Amount per unit	decimal	15	2
24	P2RB_DAYDET	Daydetails for payroll outsourcing (B)	11	BETPE	Payroll: Amount per unit	decimal	15	2
25	P2RC_WHTP	PC2CH02	10	BETPE	Payroll: Amount per unit	decimal	15	2
26	P2RD_XIT	Payroll Results: Extended IT	17	BETPE	Payroll: Amount per unit	decimal	15	2
27	P2RH_HU_HKIF	P21PB	18	BETPE	Payroll: Amount per unit	decimal	15	2
28	P2RI_IPCUM	RI cluster structure for cumulations (IPCUM)	18	BETPE	Payroll: Amount per unit	decimal	15	2
29	P2RI_ITIOT	RI cluster structure for retroactive accounting	20	BETPE	Payroll: Amount per unit	decimal	15	2
30	P2RJ_HEIT	Payroll Results: Hei Ran Results Table	7	BETPE	Payroll: Amount per unit	decimal	15	2
31	P2RK_WTDT	Payroll Results - Wage type processing information	9	BETPE	Payroll: Amount per unit	decimal	15	2
32	P2RO_RO_CUX	Difference table of payroll results	14	BETPE	Payroll: Amount per unit	decimal	15	2
33	P2RO_RO_DIF	Difference table of payroll results	14	BETPE	Payroll: Amount per unit	decimal	15	2
34	P2RP_MF	HR-PT: Payroll Results: Membership fees	13	BETPE	Payroll: Amount per unit	decimal	15	2
35	P2RQ_HT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
36	P2RQ_NT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
37	P2RQ_SMTH	SMTH and SQTR for Superannuation (Australia)	18	BETPE	Payroll: Amount per unit	decimal	15	2
38	P2RQ_SQTR	SMTH and SQTR for Superannuation (Australia)	18	BETPE	Payroll: Amount per unit	decimal	15	2
39	P2RR_CAW	Payroll Results: Table for CPF on AW/SG	9	BETPE	Payroll: Amount per unit	decimal	15	2
40	P2RR_SRT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
41	P2RX_AVERAGE	Frozen Average Values in Payroll Result	8	BETPE	Payroll: Amount per unit	decimal	15	2
42	P2RX_DFT	Payroll Results: Differences for Gross/Net Payroll	9	BETPE	Payroll: Amount per unit	decimal	15	2
43	P2RX_GRT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
44	P2RX_LS	Payroll Results: Subsequent Time Tickets	13	BETPE	Payroll: Amount per unit	decimal	15	2
45	P2RX_RT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
46	P2RX_RT_GP	Payroll Result: Payroll for Global Employees	9	BETPE	Payroll: Amount per unit	decimal	15	2
47	P2RX_RT_PERSON	Results Table (Person)	22	BETPE	Payroll: Amount per unit	decimal	15	2
48	P2SI_CUF	Difference table of payroll results	8	BETPE	Payroll: Amount per unit	decimal	15	2
49	P2SI_CUP	Difference table of payroll results	8	BETPE	Payroll: Amount per unit	decimal	15	2
50	P2SI_DTF	Difference table of payroll results	8	BETPE	Payroll: Amount per unit	decimal	15	2
51	P2SI_DTP	Difference table of payroll results	8	BETPE	Payroll: Amount per unit	decimal	15	2
52	P2TN_TWOT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
53	P2UA_FUP	table FUP - future periods	18	BETPE	Payroll: Amount per unit	decimal	15	2
54	P2UA_UAAV	HR-PAY: Cumulations for calculation of averages	12	BETPE	Payroll: Amount per unit	decimal	15	2
55	P2UA_UAILL	struc.UAILL - information about sick-list compensation calc.	14	BETPE	Payroll: Amount per unit	decimal	15	2
56	P2UA_UARF	Structure for Ukrainian social insurance(PF) calculation	21	BETPE	Payroll: Amount per unit	decimal	15	2
57	P2UA_UART	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
58	P2UA_UATI	Structure for Ukrainian social insurance(PF) calculation	22	BETPE	Payroll: Amount per unit	decimal	15	2
59	P2UA_UATR	Structure for Ukrainian social insurance(PF) calculation	22	BETPE	Payroll: Amount per unit	decimal	15	2
60	P2UA_UATS	Structure for Ukrainian social insurance(PF) calculation	22	BETPE	Payroll: Amount per unit	decimal	15	2
61	P2UN_HT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
62	P2UN_NT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
63	P2UR_FUP	table FUP - future periods	18	BETPE	Payroll: Amount per unit	decimal	15	2
64	P2UR_RUAVE	Cumulations for calculation of averages	12	BETPE	Payroll: Amount per unit	decimal	15	2
65	P2UR_RURT	Payroll Results: Results Table	18	BETPE	Payroll: Amount per unit	decimal	15	2
66	T5H85	Bérszámfejtés elozmények	7	BETPE	Bérszámfejtés: egységenkénti összeg	decimal	15	2
TOPAustria
67	HRPAYAT_PAYRSRES	Saves Wage Types from Simulated Payroll Results	19	BETPE	Payroll: Amount per unit	decimal	15	2
TOPBelgium
68	PA3207	Personal-Stammsatz Infotyp 3207	35	BETPE	Rate for external data	decimal	15	2
TOPCanada
69	T5K8C	Transfer ext. payroll results into Canadian specific tables	9	BETPE	Payroll: Amount per unit	decimal	15	2
70	T5U8C	Transfer external payroll results (USA)	9	BETPE	Payroll: Amount per unit	decimal	15	2
TOPChina
71	T7CNST	CN: Last Result of Simulate Termination Payment for Labor WB	5	BETPE	Payroll: Amount per unit	decimal	15	2
TOPDenmark
72	T5M58	SAP-PBS Interface: Transfer Payroll Account (DK)	11	BETPE	Payroll: Amount per unit	decimal	15	2
73	T5M58_OLD	!!Do Not Use (Copy of T5M58)	8	BETPE	Payroll: Amount per unit	decimal	15	2
74	T5M8P	SAP-PBS interface: Transfer year-end values	7	BETPE	Payroll: Amount per unit	decimal	15	2
75	T5M9A	SAP-PBS Interface: Transfer of New Year Values	7	BETPE	Payroll: Amount per unit	decimal	15	2
76	T5M9B	SAP-PBS: Year End Values (Revision)	8	BETPE	Payroll: Amount per unit	decimal	15	2
77	T5M9C	SAP-PBS Interface: New Year Values (Revision)	8	BETPE	Payroll: Amount per unit	decimal	15	2
TOPPayroll
78	T7ROA3	Insurance result table - Person 1:1 with RGDIR	5	BETPE	Payroll: Amount per unit	decimal	15	2
79	T7SKA4	Pomocná tabulka HRSK	6	BETPE	Zúctov.miezd a platov: Ciastka na jednotku	decimal	15	2
TOPPayroll General Parts
80	T558A	Old Payroll Account Transfer	7	BETPE	Payroll: Amount per unit	decimal	15	2
81	T558C	Payroll Account Transfer: Old Wage Types	7	BETPE	Payroll: Amount per unit	decimal	15	2
82	T558D	Transfer Wage Types with Split Indicator	18	BETPE	Payroll: Amount per unit	decimal	15	2
TOPPersonnel Administration
83	T7COT8	Payroll external results transfer: COAVA	35	BETPE	Payroll: Amount per unit	decimal	15	2
TOPPersonnel Management
84	/BKC/S21_EV	Sol21: Vergleich von Abrechnungsergebnissen	7	BETPE	Personalabrechnung: Betrag pro Einheit	decimal	15	2
85	/BKC/S21_EV1	Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.	6	BETPE	Personalabrechnung: Betrag pro Einheit	decimal	15	2
86	/BKC/S21_RT	C&T! - Table RT for the payroll comparison programs	8	BETPE	Payroll: Amount per unit	decimal	15	2
87	/BKC/S21_RT_NEU	C&T! - Table RT for the payroll comparison programs	10	BETPE	Payroll: Amount per unit	decimal	15	2
88	/BKC/S21_RT_NOPN	C&T! - Table RT for the payroll comparison programs	7	BETPE	Payroll: Amount per unit	decimal	15	2
TOPTools
89	PA0579	HR Master Record Infotype 0579 (Ext. Wage Components)	30	BETPE	Payroll: Amount per unit	decimal	15	2
90	T532B	HR: Connection to Third-Party Payroll: Choice of Wage Types	19	BETPE	Component 709: Entry field for field selection in PC207	nvarchar	1	0

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

90 columns | ERP 6.0 | BETPE