	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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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

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

150 columns | B1 9.2 | CODE