	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

71 columns | ERP 6.0 | ACINST

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAccounting Engine
1	/EACC/BT_ACTIV	Activate Configurations of the Business Transactions	2	ACINST	Accounting System	nvarchar	8	0
2	/EACC/BT_CNF_A	All Configurations by the Business Transactions	2	ACINST	Accounting System	nvarchar	8	0
3	/EACC/COND_PR	Conditions for Generated Programs	2	ACINST	Accounting System	nvarchar	8	0
4	/EACC/CONFIGS_LI	Configurations	3	ACINST	Accounting System	nvarchar	8	0
5	/EACC/CONF_DELEG	Delegation of Line Item Processing	2	ACINST	Accounting System	nvarchar	8	0
6	/EACC/DERIVCHARS	Target Characteristics in Derivation Steps	2	ACINST	Accounting System	nvarchar	8	0
7	/EACC/DERIV_COND	Conditions for Derivation Steps	2	ACINST	Accounting System	nvarchar	8	0
8	/EACC/DERIV_EXIT	Methods for Derviation Exits	2	ACINST	Accounting System	nvarchar	8	0
9	/EACC/DM_COUNTER	Counter Readings in Tranche Management	2	ACINST	Data Basis	nvarchar	5	0
10	/EACC/DM_DTRANCH	Default Tranche	2	ACINST	Data Basis	nvarchar	5	0
11	/EACC/DM_FC_REQU	Data Retention - Flow Control: Requests	2	ACINST	Accounting Structure ID	nvarchar	22	0
12	/EACC/DM_SERIMAX	Data Retention - Flow Control: Highest Serial No. of DataSrc	2	ACINST	Accounting Structure ID	nvarchar	22	0
13	/EACC/DM_TRNCH	Tranches	2	ACINST	Data Basis	nvarchar	5	0
14	/EACC/DOC_PROGS	Generated Programs	2	ACINST	Accounting System	nvarchar	8	0
15	/EACC/GEN_PROGS	Generated Programs	2	ACINST	Accounting System	nvarchar	8	0
16	/EACC/HEAD_TBLS	List of Document Header Tables	2	ACINST	Accounting System	nvarchar	8	0
17	/EACC/JRNL_ACTIV	Active Journal Configurations	2	ACINST	Accounting System	nvarchar	8	0
18	/EACC/JRNL_CNF_A	All Journal Configurations	2	ACINST	Accounting System	nvarchar	8	0
19	/EACC/JRNL_CURTP	All Journal Configurations	2	ACINST	Accounting System	nvarchar	8	0
20	/EACC/JRNL_DERIV	Derivation Configuration for the Journal	2	ACINST	Accounting System	nvarchar	8	0
21	/EACC/JRNL_QNTTP	All Journal Configurations	2	ACINST	Accounting System	nvarchar	8	0
22	/EACC/JRNL_TOTLS	Journal Totals	2	ACINST	Accounting System	nvarchar	8	0
23	/EACC/LASTPSTDAT	Lest Posting Date Posted to	2	ACINST	Accounting System	nvarchar	8	0
24	/EACC/PROGCOND	Conditions for Generated Programs	2	ACINST	Accounting System	nvarchar	8	0
25	/EACC/TACCOMP	Components of the Accounting Instance	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
26	/EACC/TDOCJRCONF	Configuration of the Document Journal Component	2	ACINST	Accounting System	nvarchar	8	0
27	/EACC/TOT_DELEG	Delegation of Totals Administration	2	ACINST	Accounting System	nvarchar	8	0
28	/EACC/VIEWDCHARS	Source Characteristics in Derivation Steps	2	ACINST	Accounting System	nvarchar	8	0
29	/EACC/VIEW_ACTIV	Active View Configurations	2	ACINST	Accounting System	nvarchar	8	0
30	/EACC/VIEW_CNF_A	All View Configurations	2	ACINST	Accounting System	nvarchar	8	0
31	/EACC/VIEW_CURTP	All View Configurations	2	ACINST	Accounting System	nvarchar	8	0
32	/EACC/VIEW_DERIV	Derivation Configuration Requirements in a View	2	ACINST	Accounting System	nvarchar	8	0
33	/EACC/VIEW_QNTTP	Quantity Types	2	ACINST	Accounting System	nvarchar	8	0
34	/EACC/VIEW_TOT_A	All View Configurations	2	ACINST	Accounting System	nvarchar	8	0
TOPBusiness Accounting
35	/EACC/DMM_BWINFO	BW System for Transaction Data	2	ACINST	Accounting Structure ID	nvarchar	22	0
36	/EACC/DMM_CHA	Characteristics of the Accounting Views	2	ACINST	Accounting Structure ID	nvarchar	22	0
37	/EACC/DMM_COMPON	Components with Data Retention	2	ACINST	Accounting Structure ID	nvarchar	22	0
38	/EACC/DMM_DIC	Dimension Assignment of the Characteristics of Accntng Views	2	ACINST	Accounting Structure ID	nvarchar	22	0
39	/EACC/DMM_DIM	Dimensions of the Accounting Views	2	ACINST	Accounting Structure ID	nvarchar	22	0
40	/EACC/DMM_DIMT	Test e for Dimensions of Accounting Views	2	ACINST	Accounting Structure ID	nvarchar	22	0
41	/EACC/DMM_KYF	Key Figures in the Accounting Views	2	ACINST	Accounting Structure ID	nvarchar	22	0
42	/EACC/DMM_QUEEX	Technical Info for Extraction	2	ACINST	Accounting Structure ID	nvarchar	22	0
43	/EACC/DMM_QUEUE	BW Objects in the Extraction Lines	2	ACINST	Accounting Structure ID	nvarchar	22	0
TOPFinancials Basis
44	/EACC/TCHAR_OBLI	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
45	/EACC/TIOBJ_CAT	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
46	/EACC/TIOBJ_CUBE	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
47	/EACC/TIOBJ_OBLI	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
48	/EACC/TIOBJ_REGI	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
49	/EACC/TLEAD_BW	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
50	/EACC/TLEAD_ST	Obsolete	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
51	FINB_TACCOMM	Obsolete !!! Accounting Community	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
52	FINB_TACCOMMT	Obsolete !!! Accounting Community: Texts	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
53	FINB_TACCOMM_MB	Obsolete !!! Members of an Accounting Community	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
54	FINB_TACINST	Obsolete - to be deleted	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
55	FINB_TACINSTT	Obsolete - to be deleted	3	ACINST	Obsolete - to be deleted	nvarchar	22	0
56	FINB_TACSYST	Obsolete !!! Valuation System	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
57	FINB_TACSYSTT	Obsolete !!! Valuation System Texts	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
58	FINB_TACSYST_DCR	Obsolete !!! Valuation System: Description in Form of Chars	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
59	FINB_TACSYST_GR	Obsolete !!! Valuation System: Description Groups	2	ACINST	Obsolete - to be deleted	nvarchar	22	0
TOPGeneral Ledger
60	/EACA/TGLDYNCOLS	Layout of the Document Header Screen	2	ACINST	Text string 22 characters	nvarchar	22	0
61	/EACA/TGLDYNFLDS	Position of the Screen Fields	2	ACINST	Text string 22 characters	nvarchar	22	0
62	/EACA/TGLDYNPROS	Screen Numbers for Posting Transactions	2	ACINST	Text string 22 characters	nvarchar	22	0
63	/EACA/TGLDYNTABS	Title Element for the Header of a Document	3	ACINST	Text string 22 characters	nvarchar	22	0
TOPProfitability Analysis
64	/EACA/TPMDTST	Meta Data for Data Retention in Profitability Analysis	3	ACINST	Accounting Structure ID	nvarchar	22	0
65	/EACA/TPMINSTANC	Profitability Analysis Instance	2	ACINST	Accounting Structure ID	nvarchar	22	0
66	/EACA/TPMINSTT	Text Table for Profitability Analysis Instance	2	ACINST	Accounting Structure ID	nvarchar	22	0
67	/EACA/TPMSTRUCT	Structural Configuration for Profitability Analysis	3	ACINST	Accounting Structure ID	nvarchar	22	0
68	/EACA/TPMVARI	Profitabiliy Analysis Variant	2	ACINST	Accounting Structure ID	nvarchar	22	0
69	/EACA/TPMVARIASS	Variant: Assignments	2	ACINST	Accounting Structure ID	nvarchar	22	0
70	/EACA/TPMVARIMET	Assignment of Meta Data Continers to Variant	2	ACINST	Accounting Structure ID	nvarchar	22	0
71	/EACA/TPMVARIT	Text Table for Variant	2	ACINST	Accounting Structure ID	nvarchar	22	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

71 columns | ERP 6.0 | ACINST