	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

166 columns | B1 9.3 | CODE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPAdministration
1	AAD1	Administration Extension-Log	15	Code	Code	Int	11	0	1
2	AADM	Administration - Log	270	Code	Code	Int	11	0	1
3	ACFP	CFOP for Nota Fiscal	2	Code	CFOP Code	nVarChar	6	0
4	ADM1	Administration Extension	15	Code	Code	Int	11	0	1
5	ADM2	Administration Electronic Report	1	Code	Code	Int	11	0
6	AFML	Tax Formula Master Table	2	Code	Code	nVarChar	20	0
7	ALR1	Queue of messages to be sent	1	Code	Internal Number	Int	11	0
8	ALR2	Dynamic message data row	1	Code	Internal Number	Int	11	0
9	ALR3	Dynamic message data cells	1	Code	Internal Number	Int	11	0
10	ALT1	Alerts - Users	1	Code	Internal Number	Int	11	0
11	ARST	Route Stages - History	2	Code	Code	nVarChar	50	0
12	ASTC	Sales Tax Codes	1	Code	Code	nVarChar	8	0
13	ATSC	CST Code for Nota Fiscal	2	CODE	CST Code Incoming	nVarChar	20	0
14	CSTN	Workstation ID	1	Code	Code	Int	11	0
15	MAP1	Input and Output of Mapping	2	Code	Code	Int	11	0
16	MLS1	Distribution Lists - Recipients	1	Code	Code	Int	11	0
17	OADF	Address Formats	1	Code	Code	Int	6	0
18	OADM	Administration	270	Code	Code	Int	11	0	1
19	OALR	Alerts	1	Code	Internal Number	Int	11	0
20	OALT	Alerts Template	1	Code	Internal Number	Int	11	0
21	OBDC	B1i DI Configuration	1	Code	Code	Int	11	0
22	OBMI	Brazilian Multi-Indexer	3	Code	Code	nVarChar	10	0
23	OBOI	Count Widget	2	Code	Count Widget Code	nVarChar	15	0
24	OBSI	Brazil String Indexer	2	Code	Code	nVarChar	30	0
25	OCDT	Credit Card Payment	1	Code	Credit Card Payment Code	nVarChar	8	0
26	OCFP	CFOP for Nota Fiscal	2	Code	CFOP Code	nVarChar	6	0
27	OCNT	Counties	2	Code	County Code	nVarChar	7	0
28	OCRY	Countries	1	Code	Code	nVarChar	3	0
29	OCSN	Certificate Series	2	Code	Code	nVarChar	4	0
30	OCST	States	1	Code	Code	nVarChar	3	0
31	ODCI	Intrastat Configuration	3	Code	Code	nVarChar	50	0
32	ODMW	Data Migration	1	Code	Package Code	Int	11	0
33	OFML	Tax Formula Master Table	2	Code	Code	nVarChar	20	0
34	OGPC	Government Payment Code	2	Code	Code	nVarChar	6	0
35	OGSP	Goods Shipment	1	Code	Code	VarChar	1	0
36	OIND	Triangular Deal	1	Code	Code	VarChar	1	0
37	OJPE	Local Era Calendar	1	Code	Local Era Code	VarChar	1	0
38	OLNG	User Language Table	1	Code	Code	Int	11	0
39	OMAO	Mobile Add-On Setting	1	Code	Code	nVarChar	20	0
40	OMLS	Distribution List	1	Code	Code	Int	11	0
41	ONFT	Nota Fiscal Tax Category (Brazil)	2	Code	Tax Category	nVarChar	20	0
42	ONOA	Nature of Assessee	2	Code	Code	nVarChar	4	0
43	OOCC	BoE Occurrence Code	2	Code	Code	nVarChar	10	0
44	OPRO	Property Object	3	Code	Input/Output Code	Int	11	0
45	OPVL	Lender - Pelecard	1	Code	Internal Number	Int	11	0
46	ORIT	Dunning Interest Rate	1	Code	Interest Code	nVarChar	20	0
47	ORMK	Remark 1	2	Code	Code	VarChar	1	0
48	ORST	Route Stages	2	Code	Code	nVarChar	50	0
49	OSEC	Sections	2	Code	Code	nVarChar	15	0
50	OSSP	Service Supply	1	Code	Code	VarChar	1	0
51	OSTA	Sales Tax Authorities	1	Code	Code	nVarChar	8	0
52	OSTC	Sales Tax Codes	1	Code	Code	nVarChar	8	0
53	OTFC	Tax Type Combination	2	Code	Code	nVarChar	20	0
54	OTPA	Tax Parameter Attributes	2	Code	Attribute Code	nVarChar	8	0
55	OTPR	Tax Return Values	2	Code	Return Value Code	nVarChar	7	0
56	OTPS	Tax Parameter	2	Code	Code	nVarChar	5	0
57	OTSC	CST Code for Nota Fiscal	2	CODE	CST Code Incoming	nVarChar	20	0
58	OUDG	User Defaults	1	Code	Code	nVarChar	8	0
59	OUDO	User-Defined Object	1	Code	Code	nVarChar	20	0
60	RIT1	Interest Rates	1	Code	Object Code	nVarChar	20	0
61	SMSG	SMSG	1	Code	Internal Key	Int	11	0	1	1=Unique key
62	UDG1	User Defaults - Documents	1	Code	Code	nVarChar	8	0
63	UDG2	User Defaults - Credit Cards	1	Code	Code	nVarChar	8	0
64	UDG3	User Defaults - POS/Cash Register	1	Code	Code	nVarChar	8	0
65	UDG4	User Defaults - Default POI for Folio Numbering Documents	1	Code	POI Code	nVarChar	8	0
66	UDO1	User-Defined Objects - Child	1	Code	Code	nVarChar	20	0
67	UDO2	User-Defined Objects - Find Columns	1	Code	Code	nVarChar	20	0
68	UDO3	User-Defined Objects - Found Columns	1	Code	Code	nVarChar	20	0
69	UDO4	User-Defined Objects - Child Table Columns	1	Code	Code	nVarChar	20	0
TOPBanking
70	ACH1	Checks for Payment - Rows - History	8	Code	Tax Definition	nVarChar	8	0
71	BOE1	Bill of Exchange for Payment - Rows	8	Code	Tax Definition	nVarChar	8	0
72	CHD1	Checks for Payment Drafts - Rows	8	Code	Tax Definition	nVarChar	8	0
73	CHO1	Checks for Payment - Rows	8	Code	Tax Definition	nVarChar	8	0
74	OBCA	Bank Charges Allocation Codes	1	Code	Code	nVarChar	3	0
75	OPBD	Document Type	1	Code	Code	nVarChar	2	0
76	OPBU	Budget ID	1	Code	Budget ID Code	nVarChar	100	0
77	OPFT	Portfolio Definitions	1	Code	Code	nVarChar	8	0
78	OPPT	Payment Type	1	Code	Code	nVarChar	2	0
79	OPRS	Tax Payer Status	1	Code	Code	nVarChar	2	0
80	OPYD	Payment Run	1	Code	Payment Run Code	nVarChar	20	0
81	OPYR	Payment Reason	1	Code	Code	nVarChar	2	0
82	OUBR	Branches	1	Code	Code	Int	6	0
83	OUDP	Departments	1	Code	Code	Int	6	0
TOPBusiness Partners
84	OCLO	Meetings Location	1	Code	Code	Int	6	0
85	OCLS	Activity Subjects	1	Code	Code	Int	6	0
86	OCLT	Activity Types	1	Code	Code	Int	6	0
TOPFinance
87	AAC1	Asset Classes - Depreciation Areas - History	1	Code	Code	nVarChar	20	0
88	AACS	Asset Classes - History	1	Code	Code	nVarChar	20	0
89	AADT	Fixed Assets Account Determination - History	1	Code	Code	nVarChar	15	0
90	ACS1	Asset Classes - Depreciation Areas	1	Code	Code	nVarChar	20	0
91	ADPA	Fixed Asset Depreciation Areas - History	1	Code	Code	nVarChar	15	0
92	ADT1	Depreciation Types - Rows - History	1	Code	Code	nVarChar	15	0
93	ADTP	Fixed Assets Depreciation Types - History	1	Code	Code	nVarChar	15	0
94	AFPR	Posting Period-Log	2	Code	Period Code	nVarChar	20	0
95	AVT1	Tax Definition	1	Code	Group Code	nVarChar	8	0
96	AVTG	Tax Definition	1	Code	Code	nVarChar	8	0
97	AWH2	WTax Definition - Rows2	2	Code	Tax Code	nVarChar	4	0
98	DTP1	Depreciation Types - Rows	1	Code	Code	nVarChar	15	0
99	FAA1	Asset Attributes - Rows	1	Code	Code	Int	11	0
100	OACR	Accrual Type	1	Code	Accrual Type Code	nVarChar	8	0
101	OACS	Asset Classes	1	Code	Code	nVarChar	20	0
102	OADG	Depreciation Groups	1	Code	Code	nVarChar	15	0
103	OADT	Fixed Assets Account Determination	1	Code	Code	nVarChar	15	0
104	OAGS	Asset Groups	1	Code	Code	nVarChar	15	0
105	OASC	Account Segmentation Categories	2	Code	Code	nVarChar	20	0
106	OCDC	Cash Discount	1	Code	Cash Discount Code	nVarChar	20	0
107	OCFL	Cash Flow Additional Trans.	1	Code	Code	Int	11	0
108	OCIG	CIG Codes	2	Code	Contract Code Identification	nVarChar	10	0
109	OCUP	CUP Codes	2	Code	Unique Code of Project	nVarChar	15	0
110	ODPA	Fixed Asset Depreciation Areas	1	Code	Code	nVarChar	15	0
111	ODPP	Depreciation Type Pools	1	Code	Code	nVarChar	2	0
112	ODTP	Fixed Assets Depreciation Types	1	Code	Code	nVarChar	15	0
113	OFAA	Asset Attributes	1	Code	Code	Int	11	0
114	OFPR	Posting Period	2	Code	Period Code	nVarChar	20	0
115	OFYM	Financial Year Master	2	Code	Code	nVarChar	6	0
116	OIDC	Indicator	1	Code	Indicator Code	nVarChar	2	0
117	OVTG	Tax Definition	1	Code	Code	nVarChar	8	0
118	RCI1	Recipient List - Rows	1	Code	Code	Int	11	0
119	VTG1	Tax Definition	1	Code	Group Code	nVarChar	8	0
120	WHT2	Withholding Tax Definition - Rows2	2	Code	Tax Code	nVarChar	4	0
121	ZRD1	POS Daily Summary - Totals	3	Code	Totalizer Code	nVarChar	8	0
TOPGeneral
122	ALT2	Alerts - Groups	1	Code	Internal Number	Int	11	0
123	APHA	Project Management Subproject - History	8	Code	Subproject No.	Int	11	0
124	OBFI	Brazil Fuel Indexer	1	Code	Fuel Code	nVarChar	10	0
125	OBNI	Brazil Numeric Indexer	2	Code	Code	Int	11	0
126	OCIP	Configuration of Integration Packages	2	Code	Package Code	nVarChar	10	0
127	OCPT	Cockpit Main Table	2	Code	Cockpit Code	Int	6	0
128	OKPI	Key Performance Indicator Package	2	Code	KPI Code	nVarChar	250	0
129	OPHA	Project Management Subproject	8	Code	Subproject No.	Int	11	0
130	OPTI	Point of Issue	1	Code	Code	nVarChar	5	0
131	OSES	OSES	1	Code	SEFAZ Country Code	nVarChar	15	0
132	OSRC	Service App Report Configuration	1	Code	Code	Int	11	0
133	OSSG	Service App Setting groups	1	Code	Code	Int	11	0
134	OSTS	Service App Technician settings	1	Code	Code	Int	11	0
135	RLNG	????	3	Code	Language code	Int	11	0
136	SEWST	SEWST	1	Code	Code	nVarChar	8	0
137	SLSC	Local Settings Components CABs	2	Code	Code	nVarChar	20	0
138	SLSD	Local Settings	1	Code	Code	nVarChar	3	0
139	TYPR	TYPR	1	CODE	Report Type	nVarChar	4	0
TOPInventory and Production
140	AITT	Product Tree - History	1	Code	Parent Item	nVarChar	50	0
141	ATT1	Bill of Materials - Components - History	4	Code	Child Code	nVarChar	50	0
142	ITT1	Bill of Materials - Components	4	Code	Component Code	nVarChar	50	0
143	OCYC	Cycle	1	Code	Cycle Code	Int	6	0
144	OITT	Product Tree	1	Code	Parent Item	nVarChar	50	0
145	OLCT	Location	1	Code	Location Code	Int	11	0
146	OPSC	Product Source Code	1	Code	Source Code	Int	6	0
TOPMarketing Documents
147	ORCP	Recurring Transaction Template	2	Code	Template Code	nVarChar	8	0
TOPMRP
148	OFCT	Sales Forecast	2	Code	Forecast Code	nVarChar	16	0
TOPReports
149	AEC1	Parameters for Various Types of Electronic Communication	1	Code	Code	nVarChar	8	0
150	AEC2	Electronic Transactions	2	Code	Code	nVarChar	8	0
151	AEC4	Import Mapping Determination	2	Code	Code	nVarChar	8	0
152	AEC6	Electronic Protocol DI API Properties	1	Code	Communication Type or Protocol	Int	11	0		0=Invalid, 1=GEN, 2=EET, 3=CFDI, 4=FPA, 5=MTD
153	AECM	Electronic Communication Types or Protocols	1	Code	Communication Type or Protocol	nVarChar	8	0
154	ECM1	Parameters for Various Types of Electronic Communication	1	Code	Code	nVarChar	8	0
155	ECM2	Electronic Transactions	2	Code	Code	nVarChar	8	0
156	ECM4	Import Mapping Determination	2	Code	Code	nVarChar	8	0
157	ECM6	Electronic Protocol DI API Properties	1	Code	Communication Type or Protocol	Int	11	0		0=Invalid, 1=GEN, 2=EET, 3=CFDI, 4=FPA, 5=MTD
158	FLT1	856 Report - Selection Criteria	2	Code	Code	nVarChar	50	0
159	OECM	Electronic Communication Types or Protocols	1	Code	Communication Type or Protocol	nVarChar	8	0
160	OQWZ	Query Wizard	1	Code	Query Code	nVarChar	8	0
161	OTRX	Transformation Documents	2	Code	Code	nVarChar	20	0
162	QWZ1	Query Tables	1	Code	Query Code	nVarChar	8	0
163	QWZ2	Query Result Fields	1	Code	Query Code	nVarChar	8	0
164	QWZ3	Query Condition Fields	1	Code	Query Code	nVarChar	8	0
165	RTYP	Document Type List	1	CODE	Report Type	nVarChar	4	0
TOPService
166	ORCI	Recipient List	1	Code	Code	Int	11	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

166 columns | B1 9.3 | CODE