	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

152 columns | ERP 6.0 | PAYID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	DFKKEXC_B	Appendix to External Payment Information	4	PAYID	ID of External Payment	nvarchar	35	0
2	HRDCT_TPY_RGDIR	Declustering - Directory for Test Payroll Results	17	PAYID	Payroll Identifier	nvarchar	1	0
3	P2BG_BG_CUX	Difference table of payroll results	9	PAYID	Payroll Identifier	nvarchar	1	0
4	P2BG_BG_DIF	Difference table of payroll results	9	PAYID	Payroll Identifier	nvarchar	1	0
5	P2CO_COAVA	PC2CO_AVA	42	PAYID	Payroll Identifier	nvarchar	1	0
6	P2CO_COSEV	PC2CO_SEV	15	PAYID	Payroll Identifier	nvarchar	1	0
7	P2FI_ST	Tax result structure for Finland	23	PAYID	Payer identification for bank transfer file	nvarchar	9	0
8	P2HK_RETI	Payroll structure for retroactive accounting	9	PAYID	Payroll Identifier	nvarchar	1	0
9	P2HK_RETO	Payroll structure for retroactive accounting	9	PAYID	Payroll Identifier	nvarchar	1	0
10	P2IS_RETI	Payroll structure for retroactive accounting	9	PAYID	Payroll Identifier	nvarchar	1	0
11	P2IS_RETO	Payroll structure for retroactive accounting	9	PAYID	Payroll Identifier	nvarchar	1	0
12	P2NZ_EMS	Payroll Result: Employer Monthly Schedule - NZ	10	PAYID	Payroll Identifier	nvarchar	1	0
13	P2NZ_LVACC	Payroll Result: Leave Accruals LVACC - NZ	25	PAYID	Parental Lve Flag - NZ	nvarchar	1	0
14	P2NZ_NZHPI	Payroll Result: Holiday Payment Information NZHPI - NZ	8	PAYID	Payroll Identifier	nvarchar	1	0
15	P2RH_HU_NREN	P21PA	24	PAYID	Payroll Identifier	nvarchar	1	0
16	P2RM_MVAC	Payroll Structure MVAC: Leave Handling (DK)	122	PAYID	Payroll Identifier	nvarchar	1	0
17	P2RO_RO_CUX	Difference table of payroll results	9	PAYID	Payroll Identifier	nvarchar	1	0
18	P2RO_RO_DIF	Difference table of payroll results	9	PAYID	Payroll Identifier	nvarchar	1	0
19	P2RR_RM	Payroll Results: Table for Master data (SG)	50	PAYID	Payroll Identifier	nvarchar	1	0
20	P2RU_BAL	Payroll Results: Tax Retro Differences -(USA)	17	PAYID	Payroll Identifier	nvarchar	1	0
21	P2RU_CLM	Overpayments Processing structure	15	PAYID	Payroll Identifier	nvarchar	1	0
22	P2RU_CLM_PERSON	Overpayments Processing structure	17	PAYID	Payroll Identifier	nvarchar	1	0
23	P2RU_DFRT	Payroll Results: Retroaccounting Differences -DFRT- (USA)	13	PAYID	Payroll Identifier	nvarchar	1	0
24	P2RU_UNB	Payroll Results: Tax Retro Differences -(USA)	17	PAYID	Payroll Identifier	nvarchar	1	0
25	P2RU_XDFRT	Payroll Results: Tax Retro Differences -(USA)	17	PAYID	Payroll Identifier	nvarchar	1	0
26	P2RX_EVAL_PERIOD	Index for Payroll Results Periods	14	PAYID	Payroll Identifier	nvarchar	1	0
27	P2RX_VERSC	Payroll Status Information	18	PAYID	Payroll Identifier	nvarchar	1	0
28	P2UA_UATI	Structure for Ukrainian social insurance(PF) calculation	8	PAYID	Payroll Identifier	nvarchar	1	0
29	P2UA_UATR	Structure for Ukrainian social insurance(PF) calculation	8	PAYID	Payroll Identifier	nvarchar	1	0
30	P2UA_UATS	Structure for Ukrainian social insurance(PF) calculation	8	PAYID	Payroll Identifier	nvarchar	1	0
31	PA3273	HR Master Record: Infotype 3273	52	PAYID	Payroll Identifier	nvarchar	1	0
32	PA9220	HR Master Record: Infotype 9220	30	PAYID	Payroll Identifier	nvarchar	1	0
33	PA9390	Personal-Stammsatz Infotyp 9390	30	PAYID	Abrechnungsidentifikator	nvarchar	1	0
34	PA9429	Registro maestro de personal Infotipo 9429	30	PAYID	Identificador de nómina	nvarchar	1	0
35	PA9640	Personal-Stammsatz Infotyp 9640	30	PAYID	Abrechnungsidentifikator	nvarchar	1	0
36	PA9701	Personal-Stammsatz Infotyp 9701	30	PAYID	Abrechnungsidentifikator	nvarchar	1	0
37	PA9725	HR Master Record: Infotype 9725	30	PAYID	Payroll Identifier	nvarchar	1	0
38	PA9741	HR Master Record: Infotype 9741	30	PAYID	Payroll Identifier	nvarchar	1	0
39	PA9742	HR Master Record: Infotype 9742	30	PAYID	Payroll Identifier	nvarchar	1	0
40	PA9825	HR Master Record: Infotype 9825	30	PAYID	Payroll Identifier	nvarchar	1	0
41	PA9990	HR Master Record: Infotype 9990	30	PAYID	Payroll Identifier	nvarchar	1	0
42	PA9991	HR Master Record: Infotype 9991	30	PAYID	Payroll Identifier	nvarchar	1	0
43	PA9992	HR Master Record: Infotype 9992	30	PAYID	Payroll Identifier	nvarchar	1	0
44	PA9993	HR Master Record: Infotype 9993	30	PAYID	Payroll Identifier	nvarchar	1	0
45	PA9995	HR Master Record: Infotype 9995	30	PAYID	Payroll Identifier	nvarchar	1	0
46	PA9996	HR Master Record: Infotype 9996	30	PAYID	Payroll Identifier	nvarchar	1	0
47	PA9997	HR Master Record: Infotype 9997	30	PAYID	Payroll Identifier	nvarchar	1	0
48	PA9998	HR Master Record: Infotype 9998	30	PAYID	Payroll Identifier	nvarchar	1	0
49	PYC_D_PY_MSG	PYC: payroll message	16	PAYID	Payroll Identifier	nvarchar	1	0
50	T5Q_SUPERSTREAM	Super Stream Master Table	11	PAYID	Payroll Identifier	nvarchar	1	0
51	T77PAYKZBT	Bank Transfer Table Image (BTKZ)	13	PAYID	Payroll Identifier	nvarchar	1	0
52	T7CNREW_APRPARS	Payroll result master table	10	PAYID	Payroll Identifier	nvarchar	1	0
TOPArgentina
53	PA0551	Termination of contract: General data	93	PAYID	Payroll Identifier	nvarchar	1	0
54	T7AR28	Assignment of SIJP periods to settled payrolls	4	PAYID	Payroll Identifier	nvarchar	1	0
55	T7AR75	Annual Extra Payment (SAC): Off-cycle payroll run data	4	PAYID	Payroll Identifier	nvarchar	1	0
TOPAustralia
56	PA0701	HR Terminations Data Container : Infotype 0701	32	PAYID	Payroll Identifier	nvarchar	1	0
TOPBenefit Integration
57	PA0496	Payroll Infotype: US Benefits Data - Per Pay Period	30	PAYID	Payroll Identifier	nvarchar	1	0
58	PA0497	Payroll Infotype: US Benefits Data - MTD	30	PAYID	Payroll Identifier	nvarchar	1	0
59	PA0498	Payroll Infotype: US Benefits Data - QTD	30	PAYID	Payroll Identifier	nvarchar	1	0
60	PA0499	Payroll Infotype: US Benefits Data - YTD	30	PAYID	Payroll Identifier	nvarchar	1	0
61	PA0500	Payroll Infotype: US Benefits Data in Arrears (ARRRS)	30	PAYID	Payroll Identifier	nvarchar	1	0
62	PA0501	Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)	30	PAYID	Payroll Identifier	nvarchar	1	0
TOPBrazil
63	PA0738	Alimony adjustment for Brazil	34	PAYID	Payroll Identifier	nvarchar	1	0
TOPCanada
64	PA0221	HR Master Record: Infotype 0221 (Manual Checks)	146	PAYID	Payroll Identifier	nvarchar	1	0
TOPChina
65	T7CN29	Social insurance	7	PAYID	Payment id for social insurance	nvarchar	1	0
TOPCollectionsDisbursements
66	ITAGCYDEPDIFF	Additional Information About Deposits and Differences	2	PAYID	Payment ID	varbinary	16	0
67	ITAGCYPAY	Payment Information	2	PAYID	Payment ID	varbinary	16	0
68	ITAGCYPM_ADD	Agency Collections: Payt Method Info. Addtl Payt Methods	2	PAYID	Payment ID	varbinary	16	0
69	ITAGCYPM_BANK	Payment Methods: Bank	2	PAYID	Payment ID	varbinary	16	0
70	ITAGCYPM_CC	Payment Methods: Credit Card	2	PAYID	Payment ID	varbinary	16	0
71	ITAGCYPM_CHECK	Payment Methods: Check	2	PAYID	Payment ID	varbinary	16	0
72	ITAGCYWD	Table for Withdrawal Information	2	PAYID	Payment ID	varbinary	16	0
TOPContract Accounts Receivable and Payable
73	DFKKEXC	External Payment Information	4	PAYID	ID of External Payment	nvarchar	35	0
74	DFKKEXC_CL	External Payment Information - Clearing Proposals	4	PAYID	ID of External Payment	nvarchar	35	0
75	DFKKEXC_PAYINFO	Information for Payment Medium	4	PAYID	ID of External Payment	nvarchar	35	0
TOPDenmark
76	PA0074	HR Master Record: Infotype 0074 (Leave Processing - DK)	147	PAYID	Payroll Identifier	nvarchar	1	0
77	PA0578	HR Master Record: Infotype 0578	28	PAYID	Payroll Identifier	nvarchar	1	0
78	T5M49	Date Identifiers for Special Payroll	8	PAYID	Payroll Identifier	nvarchar	1	0
79	T5M58	SAP-PBS Interface: Transfer Payroll Account (DK)	5	PAYID	Payroll Identifier	nvarchar	1	0
80	T5M5Y	Assignment of Year and PBS Track to an Original Payroll	6	PAYID	Payroll Identifier	nvarchar	1	0
81	T5M6P	Default Values for Leave Accumulation	128	PAYID	Payroll Identifier	nvarchar	1	0
82	T5M7D	Status Line for Payroll Run	34	PAYID	Payroll Identifier	nvarchar	1	0
83	T5M7W	File Entries Assignment from T5M7V	9	PAYID	Payroll Identifier	nvarchar	1	0
84	T5M8G	Matchcode W Specifically for Payroll Step (DK)	6	PAYID	Payroll Identifier	nvarchar	1	0
85	T5M8H	PBS error table for importing error file	6	PAYID	Payroll Identifier	nvarchar	1	0
86	T5M8J	File entries for PBS file	6	PAYID	Payroll Identifier	nvarchar	1	0
87	T5M8Z	Employer Assignment in Original Period	5	PAYID	Payroll Identifier	nvarchar	1	0
88	T5M9H	Split Indicators for Wage Types Sent to PBS	5	PAYID	Payroll Identifier	nvarchar	1	0
89	T5MFD	Retrieval of Official Statistics for DA/DS and FA	7	PAYID	Payroll Identifier	nvarchar	1	0
90	T5MFH	Special Transfer Days for Wage Types	7	PAYID	Payroll Identifier	nvarchar	1	0
91	T5MFJ	Correct FA Absence Statistics	7	PAYID	Payroll Identifier	nvarchar	1	0
92	T5MP1	General Messages for the PBS Remuneration Statement	7	PAYID	Payroll Identifier	nvarchar	1	0
TOPFinland
93	T7FI1P	Time-dependent information for personnel area/subarea	10	PAYID	Payer identification for bank transfer file	nvarchar	9	0
TOPIndia
94	T7INTE	Form 24Q - TAN number lock	5	PAYID	Payroll Identifier	nvarchar	1	0
TOPInterface to External Payroll Systems
95	T5UOT	Tax Services: Terminations and Inactives	5	PAYID	Payroll Identifier	nvarchar	1	0
TOPJapan
96	PA3239	HR Master Record: Infotype 3239	30	PAYID	Payroll Identifier	nvarchar	1	0
97	T5J69	HR Attributes to SYOYO payroll run JP	4	PAYID	Payroll Identifier	nvarchar	1	0
TOPLong-Term Incentives
98	PA0762	HR Master Record: Infotype 0762 (LTI Exercising)	35	PAYID	Payroll Identifier	nvarchar	1	0
TOPNew Zealand
99	PA0312	Leave History Adjustments NZ	35	PAYID	Parental Lve Flag - NZ	nvarchar	1	0
100	PT2001	HR Time Record: Infotype 2001 (Absences)	73	PAYID	Payroll Identifier	nvarchar	1	0
TOPOff-Cycle
101	T52OCG	Off-Cycle: Indicators for Batch: Payroll, Subsequent Program	8	PAYID	Payroll Identifier	nvarchar	1	0
102	T52OCMP	Off-Cycle Flag for Mass Processing	6	PAYID	Payroll Identifier	nvarchar	1	0
TOPPayroll
103	PA3234	HR master record, infotype 3234	39	PAYID	Payroll Identifier	nvarchar	1	0
104	T5H84	Payroll log	6	PAYID	Payroll Identifier	nvarchar	1	0
105	T5HNR	HU_NREN payroll table data of the "current month"	6	PAYID	Payroll Identifier	nvarchar	1	0
106	T7SKEC0009	Logovacia tabulka pre EURO konverziu - IT 0009	55	PAYID	Identifikátor zúctovania	nvarchar	1	0
TOPPayroll General Parts
107	HRPY_RGDIR	Directory for Payroll Results	15	PAYID	Payroll Identifier	nvarchar	1	0
108	HRPY_RGDIR_TEMP	Internal TEMPORARY Directory for Payroll Results	15	PAYID	Payroll Identifier	nvarchar	1	0
109	PA0128	HR Master Record: Infotype 0128 (Notifications)	31	PAYID	Payroll Identifier	nvarchar	1	0
110	PA0267	HR Master Record: Infotype 0267 (One time Payment off-cycle)	37	PAYID	Payroll Identifier	nvarchar	1	0
111	PA0815	HR Master Record for Infotype 0815	43	PAYID	Payroll Identifier	nvarchar	1	0
112	PYNOSCREEN	Selection Screen Fields (Only as Interface)	6	PAYID	Payroll Identifier	nvarchar	1	0
113	PYTIMESCREEN	PNP900: Fields For Time Selection	2	PAYID	Payroll Identifier	nvarchar	1	0
114	T51G1	Off-Cycle Batch Table	15	PAYID	Payroll Identifier	nvarchar	1	0
115	T52RIC	Retroactive Changes to Off-Cycle Infotypes	5	PAYID	Payroll Identifier	nvarchar	1	0
116	T558B	Payroll Account Transfer: Payroll Periods	5	PAYID	Payroll Identifier	nvarchar	1	0
TOPPersonnel Administration
117	PA0009	HR Master Record: Infotype 0009 (Bank Details)	52	PAYID	Payroll Identifier	nvarchar	1	0
118	PA0402	HR Master Data Infotype 0402	30	PAYID	Payroll Identifier	nvarchar	1	0
119	PA0403	HR Master Record for Infotype 0403	30	PAYID	Payroll Identifier	nvarchar	1	0
120	PA0657	HR Master Record: Infotype 0657	43	PAYID	Payroll Identifier	nvarchar	1	0
121	PA0829	HR master record for infotypes 0829	31	PAYID	Payroll Identifier	nvarchar	1	0
122	PA0831	HR master record for infotypes 0831	93	PAYID	Payroll Identifier	nvarchar	1	0
123	PA0834	HR master record for infotypes 0834	31	PAYID	Payroll Identifier	nvarchar	1	0
124	T7COT3	Payroll external results transfer: COSEV	15	PAYID	Payroll Identifier	nvarchar	1	0
125	T7COT8	Payroll external results transfer: COAVA	42	PAYID	Payroll Identifier	nvarchar	1	0
TOPPersonnel Management
126	T7HR1R	R-Sm ID	5	PAYID	Payroll Identifier	nvarchar	1	0
127	T7HR1S	R-Sm ID	6	PAYID	Payroll Identifier	nvarchar	1	0
128	T7HRA0	Datum uplate - Napomene - GOD obrazac	5	PAYID	Identifikator obracuna placa	nvarchar	1	0
129	T7HRA3	IP Form - Earnings	9	PAYID	Payroll Identifier	nvarchar	1	0
130	T7HRA3N	IP Form - Earnings - New (w. OIB)	9	PAYID	Payroll Identifier	nvarchar	1	0
131	T7HRA3O	IP Form - Earnings - with IDENT in key	10	PAYID	Payroll Identifier	nvarchar	1	0
TOPPersonnel Time Management
132	PA2001	HR Time Record: Infotype 2001 (Absences)	73	PAYID	Payroll Identifier	nvarchar	1	0
TOPRecruitment
133	PB0009	HR Master Record: Infotype 0009 (Bank Details)	52	PAYID	Payroll Identifier	nvarchar	1	0
TOPReuse Services for Country Development
134	PA0262	HR Master Record: Infotype 0262	30	PAYID	Payroll Identifier	nvarchar	1	0
135	T5JOCC	Payroll Category for Payroll Reason	2	PAYID	Payroll Identifier	nvarchar	1	0
TOPUnited Kingdom
136	T5G_DTONI	National Insurance Data Take-on	7	PAYID	Payroll Identifier	nvarchar	1	0
TOPUSA
137	PA0446		30	PAYID		nvarchar	1	0
138	PA0447	US Federal Tax MTD	30	PAYID	Payroll Identifier	nvarchar	1	0
139	PA0448	US Federal Tax QTD	30	PAYID	Payroll Identifier	nvarchar	1	0
140	PA0449	HR Master Record: Infotype 0449	30	PAYID	Payroll Identifier	nvarchar	1	0
141	PA0450	HR Master Record: Infotype 0450	30	PAYID	Payroll Identifier	nvarchar	1	0
142	PA0451	HR Master Record: Infotype 0451	30	PAYID	Payroll Identifier	nvarchar	1	0
143	PA0452	HR Master Record: Infotype 0452	30	PAYID	Payroll Identifier	nvarchar	1	0
144	PA0453	HR Master Record: Infotype 0453	30	PAYID	Payroll Identifier	nvarchar	1	0
145	PA0454	HR Master Record: Infotype 0454	30	PAYID	Payroll Identifier	nvarchar	1	0
146	PA0455	HR Master Record: Infotype 0455	30	PAYID	Payroll Identifier	nvarchar	1	0
147	PA0456	HR Master Record: Infotype 0456	30	PAYID	Payroll Identifier	nvarchar	1	0
148	PA0457	HR Master Record: Infotype 0457	30	PAYID	Payroll Identifier	nvarchar	1	0
149	PA0458	HR Master Record for Infotype 0458	30	PAYID	Payroll Identifier	nvarchar	1	0
150	PA0459	HR Master Record for Infotype 0459	30	PAYID	Payroll Identifier	nvarchar	1	0
151	PA0460	HR Master Record for Infotype 0460	30	PAYID	Payroll Identifier	nvarchar	1	0
152	PA0909	HR Master Record: Infotype 0909	32	PAYID	Payroll Identifier	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

152 columns | ERP 6.0 | PAYID