	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

43 columns | ERP 6.0 | DATABASIS

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAccounting Engine
1	/EACA/TBTPROCONF	Configurations in Component BTA Profit	2	DATABASIS	Data Basis	nvarchar	5	0
2	/EACA/TBTPROFLDS	Active Configuration in Component BTA Profit	2	DATABASIS	Data Basis	nvarchar	5	0
3	/EACC/TBTA3000	Characteristic Assignment Table Entry Data Temp 0001	2	DATABASIS	Data Basis	nvarchar	5	0
4	/EACC/TBTA3001	Characteristics to Log. Structure Names w/o Log Obj. Refrnce	2	DATABASIS	Data Basis	nvarchar	5	0
5	/EACC/TBTA3002	Logical Process Steps for BTA Processing by Groups	2	DATABASIS	Data Basis	nvarchar	5	0
6	/EACC/TBTA4000	Configuration Status of the Generic BTA per Data Basis	2	DATABASIS	Data Basis	nvarchar	5	0
7	/EACC/TBTA4001	Activation Status of Generated BTA w. Ref. to Assd BTA Cats	2	DATABASIS	Data Basis	nvarchar	5	0
8	/EACC/TBTA4002	Assignment of Generated Structures to Log. Object Types	2	DATABASIS	Data Basis	nvarchar	5	0
9	/EACC/TBTA4003	Information for Process Control of Derivations	2	DATABASIS	Data Basis	nvarchar	5	0
10	/EACC/TBTA4004	Source Characteristics for Filling Derivation Tables	2	DATABASIS	Data Basis	nvarchar	5	0
11	/EACC/TBTA4005	Assignment of Generated Structures for Derivations	2	DATABASIS	Data Basis	nvarchar	5	0
12	/EACC/TDR_STEPS	Derivation Steps	5	DATABASIS	Data Basis	nvarchar	5	0
13	/EACC/T_BTA	Registered Business Transactions	2	DATABASIS	Data Basis	nvarchar	5	0
14	UAINVT3020	Aspect for Mapping Table New Accounting <-> R/3 Functions	2	DATABASIS	Data Basis	nvarchar	5	0
TOPBusiness Accounting
15	/EACC/TCATA_USED	Data Basis: Catalogs Used	2	DATABASIS	Data Basis	nvarchar	5	0
16	URREALIGNER	Realigner Entity Table	5	DATABASIS	Data Basis	nvarchar	5	0
TOPBusiness Analytics
17	UAB_FUNC_FIELD	Fields for Use in Formula Functions (PDCE)	2	DATABASIS	Data Basis	nvarchar	5	0
18	UADYNVA	Store the Dynamic Variant for Batch Processing	6	DATABASIS	Data Basis	nvarchar	5	0
19	UAMDF4CHE	Exception Table for Field Checks and F4	2	DATABASIS	Data Basis	nvarchar	5	0
20	UASTAVA	Store the Static Variant for Batch Processing	7	DATABASIS	Data Basis	nvarchar	5	0
TOPBusiness Consolidation
21	UCI1101	Data Basis, BW-specific Definition	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
22	UCM0010	Data Streams of the Data Basis	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
23	UCM0011	Data Basis: Subassignments, Fixed in Breakdown Category	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
24	UCM0012	Data Basis: Allocation Characteristics	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
25	UCM0013	Data Basis: Optional Fields, Contained in Data Stream	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
26	UCM0014	Data Basis: Display and Selection Attributes	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
27	UCM0015	Additional Data Streams of Data Basis	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
28	UCM0016	Data Basis: Source Data Bases	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
29	UCM0017	Data Basis: Restatement Characteristics	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
30	UCM001C	Data Basis of Consolidation	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
31	UCM001S	Data Basis of Consolidation: Surrogate ID	3	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
32	UCM001T	Data Basis Name	3	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
33	UCM003C	Consolidation Area	3	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
34	UCSSCR35	Assignment of Data Basis to Generated Programs/Screens	2	DATABASIS	Data Basis of Consolidation	nvarchar	2	0
TOPFinancials Basis
35	ACCLOGOBJCAT01	Assignment of Attributes as Chars and Log. Obj. Category	2	DATABASIS	Data Basis	nvarchar	5	0
36	ACCLOGOBJCAT02	Activation Status of a Logistical Object Type	2	DATABASIS	Data Basis	nvarchar	5	0
TOPGeneral Ledger
37	/EACA/TGLPRIMANC	Configuration Information for Source Document - PLIMA GUID	2	DATABASIS	Data Basis	nvarchar	5	0
38	/EACA/TGLPRIMANO	Configuration Information for the Source Document	2	DATABASIS	Data Basis	nvarchar	5	0
TOPInventory Accounting
39	UAINVDEBCRH	Document for Revaluation Through Material Debit/Credit	11	DATABASIS	Data Basis	nvarchar	5	0
40	UAINVREVALH	Document for INV Price Change and Inventory Revaluation	13	DATABASIS	Data Basis	nvarchar	5	0
41	UAINVTMAPPING	Mapping Table New Accounting <-> R/3 Functions	2	DATABASIS	Data Basis	nvarchar	5	0
TOPPersonnel Cost Planning and Simulation
42	PA0666	HR Master Record Infotype 0666	24	DATABASIS	Data Basis (Subtype)	nvarchar	4	0
TOPProfitability Analysis
43	/EACA/TPMINSTANC	Profitability Analysis Instance	4	DATABASIS	Data Basis	nvarchar	5	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

43 columns | ERP 6.0 | DATABASIS