	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

60 columns | ERP 6.0 | BTZNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	HRPADNLP_LOGIMME	NL Pens: Immediate Payments - log for Payroll Process	7	BTZNR	Assignment of Transfers	varbinary	1	0
2	P2BR_GRREC	Alimony record	12	BTZNR	Assignment of Transfers	varbinary	1	0
3	P2CN_CNREI	Payroll result: structure for retro difference details	16	BTZNR	Assignment of Bank Transfers	varbinary	1	0
4	P2CN_CNREO	Payroll result: structure for retro difference details	16	BTZNR	Assignment of Bank Transfers	varbinary	1	0
5	P2CO_COAVA	PC2CO_AVA	30	BTZNR	Assignment of Bank Transfers	varbinary	1	0
6	P2HK_RETI	Payroll structure for retroactive accounting	18	BTZNR	Assignment of Bank Transfers	varbinary	1	0
7	P2HK_RETO	Payroll structure for retroactive accounting	18	BTZNR	Assignment of Bank Transfers	varbinary	1	0
8	P2IS_RETI	Payroll structure for retroactive accounting	18	BTZNR	Assignment of Bank Transfers	varbinary	1	0
9	P2IS_RETO	Payroll structure for retroactive accounting	18	BTZNR	Assignment of Bank Transfers	varbinary	1	0
10	P2MX_GRREC	Maintenance Payment payroll results	16	BTZNR	Assignment of Transfers	varbinary	1	0
11	P2NZ_SALSAC	Salary Sacrifice Details	15	BTZNR	Assignment of Bank Transfers	varbinary	1	0
12	P2RA_DFRT	Payroll Result for Other Payroll Periods	16	BTZNR	Assignment of Bank Transfers	varbinary	1	0
13	P2RB_BEEVL	Payroll Results: Belgium table for Evaluation	14	BTZNR	Assignment of Bank Transfers	varbinary	1	0
14	P2RE_GARNT	Payroll result: Garnishments (Spain)	17	BTZNR	Assignment of Transfers	varbinary	1	0
15	P2RH_HU_HKIF	P21PB	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
16	P2RI_IPCUM	RI cluster structure for cumulations (IPCUM)	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
17	P2RI_ITIOT	RI cluster structure for retroactive accounting	15	BTZNR	Assignment of Bank Transfers	varbinary	1	0
18	P2RQ_HT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
19	P2RQ_NT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
20	P2RQ_SMTH	SMTH and SQTR for Superannuation (Australia)	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
21	P2RQ_SQTR	SMTH and SQTR for Superannuation (Australia)	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
22	P2RR_SRT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
23	P2RX_BT	Payroll Results: Bank Transfers	5	BTZNR	Assignment of Transfers	varbinary	1	0
24	P2RX_BT_PERSON	Payment-Related Information (Person)	7	BTZNR	Assignment of Transfers	varbinary	1	0
25	P2RX_CODIST	Distribution opf Liabilities	15	BTZNR	Assignment of Bank Transfers	varbinary	1	0
26	P2RX_GRT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
27	P2RX_RT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
28	P2RX_RT_PERSON	Results Table (Person)	17	BTZNR	Assignment of Bank Transfers	varbinary	1	0
29	P2TN_TWOT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
30	P2UA_UARF	Structure for Ukrainian social insurance(PF) calculation	16	BTZNR	Assignment of Bank Transfers	varbinary	1	0
31	P2UA_UART	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
32	P2UA_UATI	Structure for Ukrainian social insurance(PF) calculation	17	BTZNR	Assignment of Bank Transfers	varbinary	1	0
33	P2UA_UATR	Structure for Ukrainian social insurance(PF) calculation	17	BTZNR	Assignment of Bank Transfers	varbinary	1	0
34	P2UA_UATS	Structure for Ukrainian social insurance(PF) calculation	17	BTZNR	Assignment of Bank Transfers	varbinary	1	0
35	P2UN_HT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
36	P2UN_NT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
37	P2UR_RURT	Payroll Results: Results Table	13	BTZNR	Assignment of Bank Transfers	varbinary	1	0
38	T5FDSNPAYM	Temp table for PAYFR_RESULT-PAYM	12	BTZNR	Affectation virements	varbinary	1	0
39	T77PAYKZBT	Bank Transfer Table Image (BTKZ)	22	BTZNR	Assignment of Transfers	varbinary	1	0
TOPAustria
40	HRPAYAT_PAYRSRES	Saves Wage Types from Simulated Payroll Results	14	BTZNR	Assignment of Bank Transfers	varbinary	1	0
TOPCompany Pension Scheme Germany
41	P01CBE	Active CPS Contributions	14	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
42	P01CBT	Transfer Records for Reimbursement of Contributions CPS	4	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
43	P01CKA	Funded Pension Rights CPS	14	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
44	P01CRP	Reimbursement Amounts CPS	4	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
45	P01VA_BE	Actual Contributions CPS for Pension Equalization Payment	15	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
46	P01VA_CBE	Reduction Amounts for Actual Contributions CPS	15	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
47	P01VA_CKA	Reduction Amounts for Funded Pension Rights CPS	17	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
48	P01VA_KA	Funded Pension Rights CPS for Pension Equalization Payment	17	BTZNR	Assignment of Reimbursement Transfers	nvarchar	4	0
TOPData Transfer
49	PPMIX	Index Payroll Results Lines -> Posting Lines for Payment	8	BTZNR	Assignment of Transfers	varbinary	1	0
TOPDenmark
50	T5M9H	Split Indicators for Wage Types Sent to PBS	14	BTZNR	Assignment of Bank Transfers	varbinary	1	0
TOPGermany
51	T5D0I	Fictitious Run Control: Wage Type Assignment	18	BTZNR	Delete Indicator for Bank Transfers	nvarchar	1	0
TOPOff-Cycle
52	T52OCL	Off-cycle: Bank Transfer Replaced by Check or Reversed	5	BTZNR	Assignment of Transfers	varbinary	1	0
TOPPayment Transactions
53	PAYR	Payment Medium File	56	BTZNR	Assignment of Transfers	varbinary	1	0
54	REGUH	Settlement data from payment program	111	BTZNR	Assignment of Transfers	varbinary	1	0
TOPPayroll
55	T5TA1	External transfers	5	BTZNR	Sequential number (field)	nvarchar	2	0
56	T7SKA1	External transfers	5	BTZNR	Sequence number (four characters)	nvarchar	4	0
TOPPayroll General Parts
57	T558D	Transfer Wage Types with Split Indicator	12	BTZNR	HR: Outsourcing: Transfer assignment	nvarchar	2	0
TOPPersonnel Administration
58	T7COT8	Payroll external results transfer: COAVA	30	BTZNR	Assignment of Bank Transfers	varbinary	1	0
TOPPersonnel Management
59	/BKC/S21_RT_NEU	C&T! - Table RT for the payroll comparison programs	17	BTZNR	Assignment of Bank Transfers	varbinary	1	0
TOPTools
60	T532B	HR: Connection to Third-Party Payroll: Choice of Wage Types	14	BTZNR	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

60 columns | ERP 6.0 | BTZNR