	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

90 columns | ERP 6.0 | ACC_SYSTEM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAccounting Engine
1	/EACC/ACCRMETH0C	Configured Methods for Accrual	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
2	/EACC/ACCRMETH0T	Description of an Accrual Method	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
3	/EACC/CHARNAMES	Characteristic Names for Fixed Fields	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
4	/EACC/JOURNALS	Journals in E-Accounting	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
5	/EACC/JRNL_TRANS	Transported Master Objects	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
6	/EACC/TAR_OBJ	Archiving Objects	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
7	/EACC/TAR_SEL	Selection Characteristics for Archiving	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
8	/EACC/TBTA3003	Transient Journal Characteristics for Generic BTA	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
9	/EACC/TBTA3004	Characteristics to Display Simulated Documents	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
10	/EACC/T_DCCHECK	Characteristics to Display Simulated Documents	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
11	/EACC/T_DCSEQ	Process Step Sequences per Accounting System	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
12	/EACC/V_COND	Derivation Steps Condition	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
13	/EACC/V_CUR	Currency Types	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
14	/EACC/V_CUR_SUB	Names of Views for Currency Types	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
15	/EACC/V_DERIV	Derivation Steps	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
16	/EACC/V_DER_NAME	Derivation Steps - Name	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
17	/EACC/V_HEAD_C	Header Data	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
18	/EACC/V_HEAD_N	Header Data - View Name	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
19	/EACC/V_JOURN_C	Journals	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
20	/EACC/V_JOURN_N	Journals	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
21	/EACC/V_QUANT_N	Quantity Types	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
22	/EACC/V_QUANT_T	Quantity Types	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
23	/EACC/V_TABLES_I	Journal Tables - Indexes	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
24	/EACC/V_TABLES_J	Journal Tables	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
25	/EACC/V_TABLES_T	Journal Tables - Tables	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
26	/EACC/V_TAB_I_I	Journal Tables - Indexes - Index	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
27	/EACC/V_TOTALS_F	Journal Totals - Field List	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
28	/EACC/V_TOTALS_I	Journal Totals - Database Indexes	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
29	/EACC/V_TOTALS_J	Journal Totals	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
30	/EACC/V_TOTALS_T	Journal Totals - Texts	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
31	/EACC/V_TOTAL_II	Journal Totals - Database Indexes - Index	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
32	/EACC/V_TOTAL_IT	Journal Totals - Database Indexes - Texts	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
33	FINACHD	Accounting Document Header	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
34	FINB_TNOASS_NRO	Assignment of Accounting System to Number Range Object	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPBusiness Accounting
35	UAV0PRICE001	Price Table with Period Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
36	UAV0PRICE001H	Price History Table with Period Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
37	UAV0PRICE002	Price Table with Date Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
38	UAV0PRICE002H	Price History Table with Date Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
39	UAV0PRICE003	Price Table with Period Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
40	UAV0PRICE003H	Price History Table with Period Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
41	UAV0PRICE004	Price Table with Date Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
42	UAV0PRICE004H	Price History Table with Date Dependency	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPFinancials
43	ACCSYSTEM01	Settings for Company on Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
44	ACCSYSTEM02	Number Range Object for Accounting System and Company	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
45	ACCSYSTEM03	Derivations for Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
46	ACCSYSTEM0C	Accounting Systems	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
47	ACCSYSTEM0T	Texts of Accounting Systems	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
48	FINGLACCTCOMP0C	G/L Account on Accounting System/Company Level	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
49	FINVALSTRATDERIV	Derivation Table: Valuation Strategy for Business Transactio	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
50	FINXCOSTCTR0C	Local Values for FIN_COSTCTR (Not Used in Live System)	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
51	FINXPROFITCTR0C	Local Values for FIN_PROFITCTR (Not Used in Live System)	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
52	FINXPROFITCTR0T	Local Texts for FIN_PROFITCTR (Not Used in Live System)	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPFinancials Basis
53	ACCACCOUNT11	G/L account	4	ACC_SYSTEM	Accounting System	nvarchar	8	0
54	ACCACCTGROUP00	Account Group	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
55	ACCAREAIDCOMP	Area ID of a Technical Component	4	ACC_SYSTEM	Accounting System	nvarchar	8	0
56	ACCCLSSTEP_ASGN	Assignment of Period Rules for the Closing Phases	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
57	ACCCLSSTPPER	Setting for Period Lock	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
58	ACCCLSSTPPERLE	Period Lock Setting Depending on Legal Unit	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
59	ACCPERSEL2	Specify Selction Conditions for the Period Lock	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
60	ACCROLE21	Application Role Registration: FieldNames and FinObjectTypes	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
61	ACCSYS02	Accounting System: Assignment to Selection Condition	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
62	ACCSYS04	Customizing for Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
63	ACCSYS05	Setting for Currency Translation	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
64	ACCSYS08	Currency IDs per Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
65	ACCSYS09	Cust. of fiscal year variant per legal entity and acc system	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
66	ACCSYS0C	Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
67	ACCSYS0T	Name of Accounting System	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
68	FINB_TPRFL_A	Table for Result Elements (Amounts Only)	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
69	FINB_TPRFL_Q	Table for Result Elements (Quantities Only)	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
70	FINB_TPROFEL	Table for Result Elements	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPGeneral Ledger
71	/EACA/GL_DOCNR_T	Inverse Value Table for GL Number Range Subobject	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
72	/EACA/TGLBALREP	Configuration for G/L Balance Reporting	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
73	/EACA/TGLBAS_B	Settings for Balance Tool	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
74	/EACA/TGLBWINFO	Information for BW Objects	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
75	/EACA/TGLCONTROL	Posting Logic Control for Account Determination Fields	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
76	/EACA/TGLMPCONAS	Configuration of Manual Posting Transaction for Acc. System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
77	/EACA/TGLREADER	Administration of the GUIDs for the Reader Modules	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
78	/EACA/TGLSYS01	General Ledger Configuration in Accounting System	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPIndustry Solution Catch Weight Management
79	CON_FIN_CKOMPU	Allowance for Price Update	6	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPInventory Accounting
80	FAIBSV01	Incoming/Outgoing Invoices	8	ACC_SYSTEM	Accounting System	nvarchar	8	0
81	FAIBSV01C	Rule for Balance Sheet Valuation	3	ACC_SYSTEM	Accounting System	nvarchar	8	0
82	FAIBSV02	Valuated Receipts	6	ACC_SYSTEM	Accounting System	nvarchar	8	0
83	FAIBSV03	Logistical Goods Movements	6	ACC_SYSTEM	Accounting System	nvarchar	8	0
84	UAINVDEBCRH	Document for Revaluation Through Material Debit/Credit	12	ACC_SYSTEM	Accounting System	nvarchar	8	0
85	UAINVREVALH	Document for INV Price Change and Inventory Revaluation	14	ACC_SYSTEM	Accounting System	nvarchar	8	0
86	UAINVT4000	Configuration Status of Inventory/WIP for Accounting Systems	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
87	UAIQS_BALANCE	Quantity Structure: Beginning/Ending Inventories and Values	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
88	UAIQS_SNDRCV	Quantity Structure: Valuated Quantity Structure	2	ACC_SYSTEM	Accounting System	nvarchar	8	0
TOPLoans Management
89	/FSIH/LINK	Table of Links Between Loan and Insurance Policy	3	ACC_SYSTEM	Account System	nvarchar	2	0
TOPProfitability Analysis
90	/EACA/TPMACCSYS	Assignment of Accounting Systems	4	ACC_SYSTEM	Accounting System	nvarchar	8	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 | ACC_SYSTEM