	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

55 columns | ERP 6.0 | FYEAR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	IDCN_ODN_TR	Prenumbered ODN for multiple print pages	8	FYEAR	Fiscal Year	nvarchar	4	0
2	J_3RF_TP_PRICES	Intervals of Market Prices of Controlled Transactions	2	FYEAR	Fiscal Year	nvarchar	4	0
3	P05EIR_AANGIFTE	Electronic Illness Reporting: Data for Wage Information	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
4	P05EIR_ABSENCE	Electronic Illness Reporting: Absence Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
5	P05EIR_ADDRESS	Electronic Illness Reporting: Employee's Address Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
6	P05EIR_ADM_UNIT	Electronic Illness Reporting: Administrative Unit Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
7	P05EIR_CH_PARTY	Electronic Illness Reporting: Chain Party Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
8	P05EIR_IKV	Electronic Illness Reporting. Work Relationship Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
9	P05EIR_ILLNESS	Electronic Illness Reporting: Illness Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
10	P05EIR_MSG_TYPE	Electronic Illness Reporting: Status Table Administration	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
11	P05EIR_MTY_STAT	Electronic Illness Reporting: Status Table	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
12	P05EIR_PERSOON	Electronic Illness Reporting: Natural Person Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
13	P05EIR_TAB_TOEL	Electronic Illness Reporting: Additional Explanations	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
14	P05EIR_WAZO	Electronic Illness Reporting: WAZO Data	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
15	P2IN_S89	Payroll structure for section 89(1)	6	FYEAR	Payroll year for determining time period	nvarchar	4	0
16	P2RV_SCRT	SCRT Norway	12	FYEAR	For period year	nvarchar	4	0
17	PAPBSGB_TPS_ARCH	TPS Archive table for TPS Annual return records of type 1	2	FYEAR	Year	nvarchar	4	0
18	TIVXCESPTTAXRATE	Municipal Property Tax Rate	2	FYEAR	Calendar Year for Property Tax Rate	nvarchar	4	0
19	PIQDB_NL_IBGH	IBG History	13	FYEAR	First Year	nvarchar	4	0
TOPAssortment
20	WRF_APC_PLI	Purchasing List Items	33	FYEAR	Posting Date YYYY	nvarchar	4	0
TOPBasic Functions
21	T850	Company data for Consolidation	14	FYEAR	Year of first consolidation	nvarchar	4	0
22	T870	Consolidation method assignment	8	FYEAR	Year of first consolidation	nvarchar	4	0
23	T874	Elimination of hidden reserves	9	FYEAR	Year of amortization of goodwill/hidden reserves	nvarchar	4	0
TOPBelgium
24	PA3207	Personal-Stammsatz Infotyp 3207	24	FYEAR	Income year	nvarchar	4	0
TOPBudget Management
25	HRP1500	DB Table for Infotype 1500	31	FYEAR	Fiscal Year	nvarchar	4	0
26	HRP1518	DB Table for Infotype 1518	25	FYEAR	Fiscal Year	nvarchar	4	0
27	HRP1519	DB Table for Infotype 1519	25	FYEAR	Fiscal Year	nvarchar	4	0
TOPConsolidation
28	TF189	Assignment of CG/CU, Version- and Period-Dependent	10	FYEAR	Year of first consolidation	nvarchar	4	0
29	TF189A	Inactive Consolidation Units per Consolidation Group	6	FYEAR	From fiscal year	nvarchar	4	0
TOPFunds Management
30	PSBM_EVENT	PS Budget Monitoring Events	5	FYEAR	Fiscal Year	nvarchar	4	0
TOPGreat Britain
31	T5G54	End Of Year Processing Stamp	3	FYEAR	Payroll Year	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
32	JVBX	JV Billing Database (INDX-Table)	8	FYEAR	Fiscal Year	nvarchar	4	0
33	T8J6N	JV EDI Processed Partners/Ventures	3	FYEAR	Fiscal Year	nvarchar	4	0
34	T8JBI_TH	JVA billing thresholds	6	FYEAR	Fiscal Year	nvarchar	4	0
35	T8JBI_THD	JVA billing threshold details	6	FYEAR	Fiscal Year	nvarchar	4	0
36	T8JER	Joint venture error table	4	FYEAR	Fiscal Year	nvarchar	4	0
37	T8JEV	Joint venture event table	4	FYEAR	Fiscal Year	nvarchar	4	0
38	T8JEVP	Joint venture event parameters	4	FYEAR	Fiscal Year	nvarchar	4	0
39	T8JEVS	Joint venture event select options	4	FYEAR	Fiscal Year	nvarchar	4	0
40	T8J_GJCB_REV	Cutback reversal control table	4	FYEAR	Fiscal Year	nvarchar	4	0
41	T8PSA_EVENT	PSA Event table	4	FYEAR	Fiscal Year	nvarchar	4	0
42	T8PSA_EVENT_PARA	Joint venture event parameters	4	FYEAR	Fiscal Year	nvarchar	4	0
43	T8PSA_EVENT_SO	Joint venture event select options	4	FYEAR	Fiscal Year	nvarchar	4	0
TOPLocalization
44	TIVXCPTINSTALLM	Installment dates	3	FYEAR	Fiscal Year	nvarchar	4	0
45	TIVXCPTPROPTYP	Property type (obsolote)	2	FYEAR	Fiscal Year	nvarchar	4	0
46	TIVXCPTPROPTYPT	Property tax category description (obsolete)	3	FYEAR	Fiscal Year	nvarchar	4	0
47	TIVXCPTPTTAXLIM	Municipal Property Tax Limit	3	FYEAR	Calendar Year for Property Tax Limits	nvarchar	4	0
48	TIVXCPTPTTAXRATE	Municipal Property Tax Rate	2	FYEAR	Calendar Year for Municipal Property Tax Rate Definition	nvarchar	4	0
49	TIVXCPTTAXRATE	Municipal Property Tax Rate for Portugal (obsolete)	2	FYEAR	Fiscal Year	nvarchar	4	0
TOPNetherlands
50	P05EIR_MSG_ADM	Electronic Illness Reporting: Status Administration	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
51	P05EIR_MSG_STAT	Electronic Illness Reporting : Status (Obsolete)	2	FYEAR	Year for Which Notification was Created	nvarchar	4	0
TOPPayroll
52	PA0940	HR Master Record: Infotype 0940	24	FYEAR	Fiscal Year	nvarchar	4	0
53	PB0940	Applicant data infotype 0940 (model)	24	FYEAR	Fiscal Year	nvarchar	4	0
TOPSales and Distribution
54	IDCN_EXCP	Errors for Prenumbered Documents	9	FYEAR	Fiscal Year	nvarchar	4	0
TOPSpain
55	PA0090	HR Master Record Infotype 0090 (Additional Income)	29	FYEAR	Fiscal year	nvarchar	4	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

55 columns | ERP 6.0 | FYEAR