	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

154 columns | ERP 6.0 | PAYTY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GSINS/INH_CD2_C	CD Posting: GL item settings	3	PAYTY	Type of Posting for Collections/Disbursements Document	nvarchar	1	0
2	/GSINS/INH_CD3_C	CD Posting: BP item settings	3	PAYTY	Type of Posting for Collections/Disbursements Document	nvarchar	1	0
3	/GSINS/INH_CD4_C	CD Posting: Variant-Type of Posting	3	PAYTY	Type of Posting for Collections/Disbursements Document	nvarchar	1	0
4	/GSINS/INH_RIDI	HCM-FSCD: List of HCM Pernr Items to be posted	9	PAYTY	Type of Posting for Collections/Disbursements Document	nvarchar	1	0
5	HRDCT_TPY_RGDIR	Declustering - Directory for Test Payroll Results	16	PAYTY	Payroll type	nvarchar	1	0
6	P2BG_BG_CUX	Difference table of payroll results	8	PAYTY	Payroll type	nvarchar	1	0
7	P2BG_BG_DIF	Difference table of payroll results	8	PAYTY	Payroll type	nvarchar	1	0
8	P2CO_COAVA	PC2CO_AVA	41	PAYTY	Payroll type	nvarchar	1	0
9	P2CO_COSEV	PC2CO_SEV	14	PAYTY	Payroll type	nvarchar	1	0
10	P2HK_RETI	Payroll structure for retroactive accounting	8	PAYTY	Payroll type	nvarchar	1	0
11	P2HK_RETO	Payroll structure for retroactive accounting	8	PAYTY	Payroll type	nvarchar	1	0
12	P2IS_RETI	Payroll structure for retroactive accounting	8	PAYTY	Payroll type	nvarchar	1	0
13	P2IS_RETO	Payroll structure for retroactive accounting	8	PAYTY	Payroll type	nvarchar	1	0
14	P2KR_KRSP2	Payroll Results Korea: Separation payroll II	6	PAYTY	Payment type	nvarchar	2	0
15	P2MX_GRORD	Maintenance payment order	10	PAYTY	Payroll type	nvarchar	1	0
16	P2NZ_NZHPI	Payroll Result: Holiday Payment Information NZHPI - NZ	7	PAYTY	Payroll type	nvarchar	1	0
17	P2RH_HU_NREN	P21PA	23	PAYTY	Payroll type	nvarchar	1	0
18	P2RK_GRORD	Payroll results Canada: Garnishment order	11	PAYTY	Payroll type	nvarchar	1	0
19	P2RM_MVAC	Payroll Structure MVAC: Leave Handling (DK)	121	PAYTY	Payroll type	nvarchar	1	0
20	P2RO_RO_CUX	Difference table of payroll results	8	PAYTY	Payroll type	nvarchar	1	0
21	P2RO_RO_DIF	Difference table of payroll results	8	PAYTY	Payroll type	nvarchar	1	0
22	P2RR_RM	Payroll Results: Table for Master data (SG)	49	PAYTY	Payroll type	nvarchar	1	0
23	P2RU_BAL	Payroll Results: Tax Retro Differences -(USA)	16	PAYTY	Payroll type	nvarchar	1	0
24	P2RU_CLM	Overpayments Processing structure	14	PAYTY	Payroll type	nvarchar	1	0
25	P2RU_CLM_PERSON	Overpayments Processing structure	16	PAYTY	Payroll type	nvarchar	1	0
26	P2RU_DFRT	Payroll Results: Retroaccounting Differences -DFRT- (USA)	12	PAYTY	Payroll type	nvarchar	1	0
27	P2RU_GRDOC	Payroll Results: Garnishment for US Document	21	PAYTY	Payroll type	nvarchar	1	0
28	P2RU_UNB	Payroll Results: Tax Retro Differences -(USA)	16	PAYTY	Payroll type	nvarchar	1	0
29	P2RU_XDFRT	Payroll Results: Tax Retro Differences -(USA)	16	PAYTY	Payroll type	nvarchar	1	0
30	P2RX_EVAL_PERIOD	Index for Payroll Results Periods	13	PAYTY	Payroll type	nvarchar	1	0
31	P2RX_VERSC	Payroll Status Information	17	PAYTY	Payroll type	nvarchar	1	0
32	P2UA_UATI	Structure for Ukrainian social insurance(PF) calculation	7	PAYTY	Payroll type	nvarchar	1	0
33	P2UA_UATR	Structure for Ukrainian social insurance(PF) calculation	7	PAYTY	Payroll type	nvarchar	1	0
34	P2UA_UATS	Structure for Ukrainian social insurance(PF) calculation	7	PAYTY	Payroll type	nvarchar	1	0
35	PA0556	HR Master Record: Infotype 0556	31	PAYTY	Payment type	nvarchar	4	0
36	PA3273	HR Master Record: Infotype 3273	51	PAYTY	Payroll type	nvarchar	1	0
37	PA9220	HR Master Record: Infotype 9220	29	PAYTY	Payroll type	nvarchar	1	0
38	PA9390	Personal-Stammsatz Infotyp 9390	29	PAYTY	Abrechnungstyp	nvarchar	1	0
39	PA9429	Registro maestro de personal Infotipo 9429	29	PAYTY	Tipo de nómina	nvarchar	1	0
40	PA9640	Personal-Stammsatz Infotyp 9640	29	PAYTY	Abrechnungstyp	nvarchar	1	0
41	PA9701	Personal-Stammsatz Infotyp 9701	29	PAYTY	Abrechnungstyp	nvarchar	1	0
42	PA9725	HR Master Record: Infotype 9725	29	PAYTY	Payroll type	nvarchar	1	0
43	PA9741	HR Master Record: Infotype 9741	29	PAYTY	Payroll type	nvarchar	1	0
44	PA9742	HR Master Record: Infotype 9742	29	PAYTY	Payroll type	nvarchar	1	0
45	PA9825	HR Master Record: Infotype 9825	29	PAYTY	Payroll type	nvarchar	1	0
46	PA9990	HR Master Record: Infotype 9990	29	PAYTY	Payroll type	nvarchar	1	0
47	PA9991	HR Master Record: Infotype 9991	29	PAYTY	Payroll type	nvarchar	1	0
48	PA9992	HR Master Record: Infotype 9992	29	PAYTY	Payroll type	nvarchar	1	0
49	PA9993	HR Master Record: Infotype 9993	29	PAYTY	Payroll type	nvarchar	1	0
50	PA9995	HR Master Record: Infotype 9995	29	PAYTY	Payroll type	nvarchar	1	0
51	PA9996	HR Master Record: Infotype 9996	29	PAYTY	Payroll type	nvarchar	1	0
52	PA9997	HR Master Record: Infotype 9997	29	PAYTY	Payroll type	nvarchar	1	0
53	PA9998	HR Master Record: Infotype 9998	29	PAYTY	Payroll type	nvarchar	1	0
54	PYC_D_PY_MSG	PYC: payroll message	15	PAYTY	Payroll type	nvarchar	1	0
55	T5FDSNPAYM	Temp table for PAYFR_RESULT-PAYM	15	PAYTY	Paie : Code type groupe rubriques	nvarchar	5	0
56	T5Q_SUPERSTREAM	Super Stream Master Table	10	PAYTY	Payroll type	nvarchar	1	0
57	T5UTLAVK	Additional Attributes of Tax Company on Tax Authority Level	4	PAYTY	Payroll type	nvarchar	1	0
58	T77PAYKZBT	Bank Transfer Table Image (BTKZ)	12	PAYTY	Payroll type	nvarchar	1	0
59	TFKKBRINRETCOD	Brazil: Receivables Return Codes Conversion	2	PAYTY	Receivables: Payment Type	nvarchar	12	0
TOPArgentina
60	PA0551	Termination of contract: General data	92	PAYTY	Payroll type	nvarchar	1	0
61	T7AR28	Assignment of SIJP periods to settled payrolls	11	PAYTY	Payroll type	nvarchar	1	0
62	T7AR75	Annual Extra Payment (SAC): Off-cycle payroll run data	3	PAYTY	Payroll type	nvarchar	1	0
TOPBenefit Integration
63	PA0496	Payroll Infotype: US Benefits Data - Per Pay Period	29	PAYTY	Payroll type	nvarchar	1	0
64	PA0497	Payroll Infotype: US Benefits Data - MTD	29	PAYTY	Payroll type	nvarchar	1	0
65	PA0498	Payroll Infotype: US Benefits Data - QTD	29	PAYTY	Payroll type	nvarchar	1	0
66	PA0499	Payroll Infotype: US Benefits Data - YTD	29	PAYTY	Payroll type	nvarchar	1	0
67	PA0500	Payroll Infotype: US Benefits Data in Arrears (ARRRS)	29	PAYTY	Payroll type	nvarchar	1	0
68	PA0501	Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)	29	PAYTY	Payroll type	nvarchar	1	0
TOPBrazil
69	PA0738	Alimony adjustment for Brazil	33	PAYTY	Payroll type	nvarchar	1	0
70	T7BRG1	Alimony: calculation models	5	PAYTY	Payroll type	nvarchar	1	0
TOPCanada
71	PA0221	HR Master Record: Infotype 0221 (Manual Checks)	145	PAYTY	Payroll type	nvarchar	1	0
TOPDenmark
72	PA0074	HR Master Record: Infotype 0074 (Leave Processing - DK)	146	PAYTY	Payroll type	nvarchar	1	0
73	PA0578	HR Master Record: Infotype 0578	27	PAYTY	Payroll type	nvarchar	1	0
74	T5M49	Date Identifiers for Special Payroll	7	PAYTY	Payroll type	nvarchar	1	0
75	T5M58	SAP-PBS Interface: Transfer Payroll Account (DK)	4	PAYTY	Payroll type	nvarchar	1	0
76	T5M5Y	Assignment of Year and PBS Track to an Original Payroll	5	PAYTY	Payroll type	nvarchar	1	0
77	T5M6P	Default Values for Leave Accumulation	127	PAYTY	Payroll type	nvarchar	1	0
78	T5M7D	Status Line for Payroll Run	33	PAYTY	Payroll type	nvarchar	1	0
79	T5M7W	File Entries Assignment from T5M7V	8	PAYTY	Payroll type	nvarchar	1	0
80	T5M8G	Matchcode W Specifically for Payroll Step (DK)	5	PAYTY	Payroll type	nvarchar	1	0
81	T5M8H	PBS error table for importing error file	5	PAYTY	Payroll type	nvarchar	1	0
82	T5M8J	File entries for PBS file	5	PAYTY	Payroll type	nvarchar	1	0
83	T5M8Z	Employer Assignment in Original Period	4	PAYTY	Payroll type	nvarchar	1	0
84	T5M9H	Split Indicators for Wage Types Sent to PBS	4	PAYTY	Payroll type	nvarchar	1	0
85	T5MFD	Retrieval of Official Statistics for DA/DS and FA	8	PAYTY	Payroll type	nvarchar	1	0
86	T5MFH	Special Transfer Days for Wage Types	8	PAYTY	Payroll type	nvarchar	1	0
87	T5MFJ	Correct FA Absence Statistics	8	PAYTY	Payroll type	nvarchar	1	0
88	T5MP1	General Messages for the PBS Remuneration Statement	6	PAYTY	Payroll type	nvarchar	1	0
TOPHong Kong
89	T7HK04	Control table for EOY Payment	6	PAYTY	Payroll type	nvarchar	1	0
90	T7HK4A	Events & reasons for LSP/Severance payments	4	PAYTY	Payment type for long services and severance	nvarchar	1	0
91	T7HK4B	Factor & constants for LSP/severance payments	3	PAYTY	Payment type for long services and severance	nvarchar	1	0
TOPIndia
92	T7INTE	Form 24Q - TAN number lock	4	PAYTY	Payroll type	nvarchar	1	0
TOPInterface to External Payroll Systems
93	T5UOT	Tax Services: Terminations and Inactives	4	PAYTY	Payroll type	nvarchar	1	0
TOPJapan
94	PA3239	HR Master Record: Infotype 3239	29	PAYTY	Payroll type	nvarchar	1	0
95	T5J69	HR Attributes to SYOYO payroll run JP	3	PAYTY	Payroll type	nvarchar	1	0
TOPKorea
96	T7KRS2	Separation payment average calculation period	2	PAYTY	Payment type	nvarchar	2	0
97	T7KRS6	Cumulation method	2	PAYTY	Payment type	nvarchar	2	0
TOPNew Zealand
98	PT2001	HR Time Record: Infotype 2001 (Absences)	72	PAYTY	Payroll type	nvarchar	1	0
99	T7NZLP	Leave Payment Rule Table - NZ	7	PAYTY	Leave Pay Type.	nvarchar	1	0
TOPOff-Cycle
100	T52OCC	Categories for Off-Cycle Reasons	3	PAYTY	Payroll type	nvarchar	1	0
101	T52OCG	Off-Cycle: Indicators for Batch: Payroll, Subsequent Program	7	PAYTY	Payroll type	nvarchar	1	0
TOPPayroll
102	PA3234	HR master record, infotype 3234	38	PAYTY	Payroll type	nvarchar	1	0
103	T5H84	Payroll log	5	PAYTY	Payroll type	nvarchar	1	0
104	T5HNR	HU_NREN payroll table data of the "current month"	5	PAYTY	Payroll type	nvarchar	1	0
105	T7SKEC0009	Logovacia tabulka pre EURO konverziu - IT 0009	54	PAYTY	Typ zúctovania	nvarchar	1	0
TOPPayroll General Parts
106	HRPY_RGDIR	Directory for Payroll Results	14	PAYTY	Payroll type	nvarchar	1	0
107	HRPY_RGDIR_TEMP	Internal TEMPORARY Directory for Payroll Results	14	PAYTY	Payroll type	nvarchar	1	0
108	PA0128	HR Master Record: Infotype 0128 (Notifications)	28	PAYTY	Payroll type	nvarchar	1	0
109	PA0267	HR Master Record: Infotype 0267 (One time Payment off-cycle)	36	PAYTY	Payroll type	nvarchar	1	0
110	PA0815	HR Master Record for Infotype 0815	42	PAYTY	Payroll type	nvarchar	1	0
111	PYNOSCREEN	Selection Screen Fields (Only as Interface)	1	PAYTY	Payroll type	nvarchar	1	0
112	PYTIMESCREEN	PNP900: Fields For Time Selection	1	PAYTY	Payroll type	nvarchar	1	0
113	T51G1	Off-Cycle Batch Table	14	PAYTY	Payroll type	nvarchar	1	0
114	T52BX	Valid Special Payroll Runs for Countries	2	PAYTY	Payroll type	nvarchar	1	0
115	T52RIC	Retroactive Changes to Off-Cycle Infotypes	4	PAYTY	Payroll type	nvarchar	1	0
116	T558B	Payroll Account Transfer: Payroll Periods	4	PAYTY	Payroll type	nvarchar	1	0
TOPPersonnel Administration
117	PA0009	HR Master Record: Infotype 0009 (Bank Details)	51	PAYTY	Payroll type	nvarchar	1	0
118	PA0402	HR Master Data Infotype 0402	29	PAYTY	Payroll type	nvarchar	1	0
119	PA0403	HR Master Record for Infotype 0403	29	PAYTY	Payroll type	nvarchar	1	0
120	PA0657	HR Master Record: Infotype 0657	42	PAYTY	Payroll type	nvarchar	1	0
121	PA0829	HR master record for infotypes 0829	30	PAYTY	Payroll type	nvarchar	1	0
122	PA0831	HR master record for infotypes 0831	92	PAYTY	Payroll type	nvarchar	1	0
123	PA0834	HR master record for infotypes 0834	30	PAYTY	Payroll type	nvarchar	1	0
124	T7COT3	Payroll external results transfer: COSEV	14	PAYTY	Payroll type	nvarchar	1	0
125	T7COT8	Payroll external results transfer: COAVA	41	PAYTY	Payroll type	nvarchar	1	0
TOPPersonnel Management
126	T7HR1R	R-Sm ID	4	PAYTY	Payroll type	nvarchar	1	0
127	T7HR1S	R-Sm ID	5	PAYTY	Payroll type	nvarchar	1	0
128	T7HRA0	Datum uplate - Napomene - GOD obrazac	4	PAYTY	Tip obracuna placa	nvarchar	1	0
129	T7HRA3	IP Form - Earnings	8	PAYTY	Payroll type	nvarchar	1	0
130	T7HRA3N	IP Form - Earnings - New (w. OIB)	8	PAYTY	Payroll type	nvarchar	1	0
131	T7HRA3O	IP Form - Earnings - with IDENT in key	9	PAYTY	Payroll type	nvarchar	1	0
TOPPersonnel Time Management
132	PA2001	HR Time Record: Infotype 2001 (Absences)	72	PAYTY	Payroll type	nvarchar	1	0
TOPPublic Sector
133	T5QPBS4A	Payment Type for terminations & redundancies	2	PAYTY	Payment Type for Terminations & Redundancies	nvarchar	4	0
134	T5QPBS4AT	Text for Payment Type for terminations & redundancies	3	PAYTY	Payment Type for Terminations & Redundancies	nvarchar	4	0
135	T5QPBS4B	Termination Payment Type	3	PAYTY	Payment Type for Terminations & Redundancies	nvarchar	4	0
TOPRecruitment
136	PB0009	HR Master Record: Infotype 0009 (Bank Details)	51	PAYTY	Payroll type	nvarchar	1	0
TOPReuse Services for Country Development
137	PA0262	HR Master Record: Infotype 0262	29	PAYTY	Payroll type	nvarchar	1	0
TOPUnited Kingdom
138	T5G_DTONI	National Insurance Data Take-on	6	PAYTY	Payroll type	nvarchar	1	0
TOPUSA
139	PA0446		29	PAYTY		nvarchar	1	0
140	PA0447	US Federal Tax MTD	29	PAYTY	Payroll type	nvarchar	1	0
141	PA0448	US Federal Tax QTD	29	PAYTY	Payroll type	nvarchar	1	0
142	PA0449	HR Master Record: Infotype 0449	29	PAYTY	Payroll type	nvarchar	1	0
143	PA0450	HR Master Record: Infotype 0450	29	PAYTY	Payroll type	nvarchar	1	0
144	PA0451	HR Master Record: Infotype 0451	29	PAYTY	Payroll type	nvarchar	1	0
145	PA0452	HR Master Record: Infotype 0452	29	PAYTY	Payroll type	nvarchar	1	0
146	PA0453	HR Master Record: Infotype 0453	29	PAYTY	Payroll type	nvarchar	1	0
147	PA0454	HR Master Record: Infotype 0454	29	PAYTY	Payroll type	nvarchar	1	0
148	PA0455	HR Master Record: Infotype 0455	29	PAYTY	Payroll type	nvarchar	1	0
149	PA0456	HR Master Record: Infotype 0456	29	PAYTY	Payroll type	nvarchar	1	0
150	PA0457	HR Master Record: Infotype 0457	29	PAYTY	Payroll type	nvarchar	1	0
151	PA0458	HR Master Record for Infotype 0458	29	PAYTY	Payroll type	nvarchar	1	0
152	PA0459	HR Master Record for Infotype 0459	29	PAYTY	Payroll type	nvarchar	1	0
153	PA0460	HR Master Record for Infotype 0460	29	PAYTY	Payroll type	nvarchar	1	0
154	PA0909	HR Master Record: Infotype 0909	31	PAYTY	Payroll type	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

154 columns | ERP 6.0 | PAYTY