	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

239 columns | B1 9.2 | CREATEDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAdministration
1	APJT	Project Plan	7	CreateDate	Production Date	Date	8	0
2	AUSR	Archive Users - History	69	createDate	Creation Date	Date	8	0
3	ODAR	Data Archiving	4	CreateDate	Archive Date	Date	8	0
4	ODGP	Document Generation Parameter Sets	4	CreateDate	Creation Date	Date	8	0
5	ODOW	Data Ownership - Objects	7	CreateDate	Creation Date	Date	8	0
6	ODOX	Data Ownership - Exceptions	6	CreateDate	Creation Date	Date	8	0
7	OMDC	Master Data Cleanup	3	CreateDate	Create Date	Date	8	0
8	OPJT	Project Plan	7	CreateDate	Production Date	Date	8	0
9	OPQW	Purchase Quotation Generation: Parameter Sets	4	CreateDate	Creation Date	Date	8	0
10	OTRN	Multilingual Service Table	6	CreateDate	Create Date	Date	8	0
11	OUSR	Users	69	createDate	Creation Date - History	Date	8	0
12	OWFER	Workflow Error Message	4	CreateDate	Create Date - History	Date	8	0
13	OWIN	Workflow Engine Information	9	CreateDate	Create Date	Date	8	0
TOPBanking
14	ABOE	Bill of Exchange for Payment - History	29	CreateDate	Creation Date	Date	8	0
15	ACHO	Checks for Payment - History	32	CreateDate	Creation Date	Date	8	0
16	ARCT	Incoming Payment - History	59	CreateDate	Creation Date	Date	8	0
17	OBOE	Bill of Exchange for Payment	29	CreateDate	Creation Date	Date	8	0
18	OCHD	Checks for Payment Drafts	32	CreateDate	Creation Date	Date	8	0
19	OCHO	Checks for Payment	32	CreateDate	Creation Date	Date	8	0
20	OCRH	Credit Card Management	36	CreateDate	Creation Date	Date	8	0
21	ODPS	Deposit	28	CreateDate	Creation Date	Date	8	0
22	OITR	Internal Reconciliation	12	CreateDate	Creation Date	Date	8	0
23	OMTH	Reconciliation History	12	createDate	Creation Date	Date	8	0
24	OPDF	Payment Draft	59	CreateDate	Creation Date	Date	8	0
25	OPYM	Payment Methods for Payment Wizard	17	CreateDate	Creation Date	Date	8	0
26	ORCT	Incoming Payment	59	CreateDate	Creation Date	Date	8	0
27	OSVR	Saved Reconciliations	6	createDate	Creation Date	Date	8	0
28	OTPW	Tax Payment Wizard	5	CreateDate	Wizard Creation Date	Date	8	0
29	OVPM	Outgoing Payments	59	CreateDate	Creation Date	Date	8	0
TOPBusiness Partners
30	ACPN	Campaign	18	CreateDate	Create Date	Date	8	0
31	ACRD	Business Partners - History	132	CreateDate	Creation Date	Date	8	0
32	AOAT	Blanket Agreement	22	CreateDate	Create Date	Date	8	0
33	OCPN	Campaign	18	CreateDate	Create Date	Date	8	0
34	OCRD	Business Partner	132	CreateDate	Creation Date	Date	8	0
35	OOAT	Blanket Agreement	22	CreateDate	Create Date	Date	8	0
TOPFinance
36	AACS	Asset Classes - History	9	CreateDate	Create Date	Date	8	0
37	AACT	G/L Account - History	38	CreateDate	Creation Date	Date	8	0
38	AADT	Fixed Assets Account Determination - History	22	CreateDate	Creation Date	Date	8	0
39	ADPA	Fixed Asset Depreciation Areas - History	10	CreateDate	Creation Date	Date	8	0
40	ADTP	Fixed Assets Depreciation Types - History	33	CreateDate	Create Date	Date	8	0
41	AFAD	Asset Document - History	23	CreateDate	Create Date	Date	8	0
42	AGAR	G/L Account Advanced Rules - History	26	CreateDate	Creation Date	Date	8	0
43	AJDT	Journal Entry - History	26	CreateDate	Creation Date	Date	8	0
44	CASE	Internal Recon. Upgrade 2007A	2	CreateDate	Creation Date	Date	8	0
45	OACD	Credit Memo	23	CreateDate	Create Date	Date	8	0
46	OACQ	Capitalization	23	CreateDate	Create Date	Date	8	0
47	OACS	Asset Classes	9	CreateDate	Create Date	Date	8	0
48	OACT	G/L Accounts	38	CreateDate	Creation Date	Date	8	0
49	OADT	Fixed Assets Account Determination	22	CreateDate	Creation Date	Date	8	0
50	OBTF	Journal Voucher Entry	26	CreateDate	Recording Date	Date	8	0
51	OCFH	Cash Flow Statement History	5	CreateDate	Recording Date	Date	8	0
52	ODPA	Fixed Asset Depreciation Areas	10	CreateDate	Creation Date	Date	8	0
53	ODTP	Fixed Assets Depreciation Types	33	CreateDate	Create Date	Date	8	0
54	OFAA	Asset Attributes	6	CreateDate	Creation Date	Date	8	0
55	OFAC	Fixed Asset Parameter Change	5	CreateDate	Create Date	Date	8	0
56	OFAM	Fixed Asset Data Migration	3	CreateDate	Migration Run Date	Date	8	0
57	OFTR	Transfer	23	CreateDate	Create Date	Date	8	0
58	OGAR	G/L Account Advanced Rules	26	CreateDate	Creation Date	Date	8	0
59	OGBI	GB Interface: Common Info	7	CreateDate	Report Creation Date	nVarChar	8	0
60	OIWZ	Inflation Wizard	31	CreateDate	Create Date	Date	8	0
61	OJDT	Journal Entry	26	CreateDate	Recording Date	Date	8	0
62	OJST	TDS Adjustment	8	CreateDate	Creation Date	Date	8	0
63	OMDP	Manual Depreciation	23	CreateDate	Create Date	Date	8	0
64	ORTI	Retirement	23	CreateDate	Create Date	Date	8	0
65	OSCM	Special Ledger - Analytical Accounting Configuration Rules: Material	7	CreateDate	Date of Rule Generation	Date	8	0
66	OSCR	Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses	7	CreateDate	Date of Rule Generation	Date	8	0
67	OSHR	Shareholder's Rights and Interests Report History	5	CreateDate	Report Created on	Date	8	0
TOPGeneral
68	AGRS	G/L Account Advanced Rules for Resources - History	26	CreateDate	Creation Date	Date	8	0
69	AHF1	Hide Functions Configuration - Rows History	15	CreateDate	Creation Date	Date	8	0
70	AHF2	Hide Function Configuration - Rows History	11	CreateDate	Creation Date	Date	8	0
71	AHFC	Hide Functions Configuration - History	10	CreateDate	Creation Date	Date	8	0
72	ARSB	Resource Groups - History	8	createDate	Creation Date - History	Date	8	0
73	ARSC	Resource Master Data - Log	101	CreateDate	Date of Creation	Date	8	0
74	HFC1	Hide Functions Configuration - Rows	15	CreateDate	Creation Date	Date	8	0
75	HFC2	Hide Function Configuration - Rows	11	CreateDate	Creation Date	Date	8	0
76	NFN5	NF Skipped Numbers	9	CreateDate	Creation Date	Date	8	0
77	OBTA	Brazil - Tax Adjustment	45	CreateDate	Creation Date	Date	8	0
78	OBVL	Serial Numbers and Batch Valuation Log	9	CreateDate	Generation Date	Date	8	0
79	OGPA	Gross Profit Adjustment	3	CreateDate	Create Date	Date	8	0
80	OGRS	G/L Account Advanced Rules for Resources	26	CreateDate	Creation Date	Date	8	0
81	OHFC	Hide Functions Configuration	10	CreateDate	Creation Date	Date	8	0
82	OHMM	SAP HANA Model Management	10	CreateDate	Created at Date	nVarChar	100	0
83	OKPI	Key Performance Indicator Package	20	CreateDate	Create Date	Date	8	0
84	OKPS	KPI Set	5	CreateDate	Create Date - History	Date	8	0
85	ONCP	New Cockpit Page	5	CreateDate	Create Date	Date	8	0
86	ORSB	Resource Groups	8	createDate	Creation Date - History	Date	8	0
87	ORSC	Resources	101	CreateDate	Date of Creation	Date	8	0
88	OWPK	Dashboard Packages	8	CreateDate	Create Date	Date	8	0
89	RADM	Resource Administration	11	CreateDate	Creation Date of DB	Date	8	0
90	RAMI	RAMI	15	CreateDate	Creation date	Date	8	0
91	UBVL	Serial Numbers and Batch Valuation Log	9	CreateDate	Generation Date	Date	8	0
92	WOBJ	Object Wizard	41	CreateDate	Creation date	Date	8	0
93	WORF	Object Wizard Related Files	11	CreateDate	Creation date	Date	8	0
TOPInventory and Production
94	ABAT	Attribute - History	9	CreateDate	Create Date	Date	8	0
95	ABFC	Bin Field Configuration - History	11	CreateDate	Creation Date	Date	8	0
96	ABIN	Bin Location - History	49	CreateDate	Create Date	Date	8	0
97	ABSL	Warehouse Sublevel - History	10	CreateDate	Creation Date	Date	8	0
98	ABTN	Batch Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
99	AEDG	Discount Groups	13	CreateDate	Creation Date	Date	8	0
100	AIGW	Item Group - Warehouse - History	9	CreateDate	Create Date	Date	8	0
101	AINC	Inventory Counting	18	CreateDate	Create Date - History	Date	8	0
102	AIQI	Inventory Opening Balance	2	CreateDate	Creation Date	Date	8	0
103	AIQR	Inventory Posting	2	CreateDate	Creation Date	Date	8	0
104	AITB	Item Groups - History	49	createDate	Creation Date - History	Date	8	0
105	AITM	Items - History	166	CreateDate	Production Date	Date	8	0
106	AITT	Product Tree - History	6	CreateDate	Creation Date	Date	8	0
107	AITW	Items - Warehouse - History	50	createDate	Creation Date - History	Date	8	0
108	AMRV	Inventory Revaluation - History	12	CreateDate	Creation Date	Date	8	0
109	APKL	Pick List - History	14	CreateDate	Creation Date	Date	8	0
110	APLN	Price Lists	17	CreateDate	Creation Date	Date	8	0
111	ASPP	Special Prices	13	CreateDate	Creation Date	Date	8	0
112	ASRN	Serial Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
113	AUGP	UoM Group	10	CreateDate	Creation Date	Date	8	0
114	AUOM	UoM Master Data	10	CreateDate	Creation Date	Date	8	0
115	AWHS	Warehouses - History	56	createDate	Creation Date - History	Date	8	0
116	AWOR	Production Order - History	26	CreateDate	Creation Date	Date	8	0
117	LIVI1	IVI Log Array File	3	CreateDate	Create Date	Date	8	0
118	OAIM	Archive Inventory Message	24	CreateDate	Creation Date	Date	8	0
119	OBAT	Bin Location Attribute	9	CreateDate	Create Date	Date	8	0
120	OBCD	Bar Code Master Data	11	CreateDate	Creation Date	Date	8	0
121	OBFC	Bin Field Configuration	11	CreateDate	Creation Date	Date	8	0
122	OBIN	Bin Location	49	CreateDate	Create Date	Date	8	0
123	OBSL	Warehouse Sublevel	10	CreateDate	Creation Date	Date	8	0
124	OBTN	Batch Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
125	ODBN	Bat. Nos - Draft - Master Data	11	CreateDate	Creation Date	Date	8	0
126	ODSN	SNs - Draft - Master Data	11	CreateDate	Creation Date	Date	8	0
127	OEDG	Discount Groups	13	CreateDate	Creation Date	Date	8	0
128	OENT	Shipping Types	33	CreateDate	Creation Date	Date	8	0
129	OICD	Inventory Counting Draft	18	CreateDate	Create Date - History	Date	8	0
130	OIGE	Goods Issue	65	CreateDate	Creation Date	Date	8	0
131	OIGN	Goods Receipt	65	CreateDate	Creation Date	Date	8	0
132	OIGW	Item Group - Warehouse	9	CreateDate	Create Date	Date	8	0
133	OILM	Inventory Log Message	34	CreateDate	Creation Date	Date	8	0
134	OINC	Inventory Counting	18	CreateDate	Create Date - History	Date	8	0
135	OIOD	Inventory Opening Balance Draft	2	CreateDate	Creation Date	Date	8	0
136	OIPD	Inventory Posting Draft	2	CreateDate	Creation Date	Date	8	0
137	OIPF	Landed Costs	39	CreateDate	Creation Date	Date	8	0
138	OIQI	Inventory Opening Balance	2	CreateDate	Creation Date	Date	8	0
139	OIQR	Inventory Posting	2	CreateDate	Creation Date	Date	8	0
140	OITB	Item Groups	49	createDate	Creation Date - History	Date	8	0
141	OITL	Inventory Transactions Log	23	CreateDate	Creation Date	Date	8	0
142	OITM	Items	166	CreateDate	Production Date	Date	8	0
143	OITT	Product Tree	6	CreateDate	Creation Date	Date	8	0
144	OITW	Items - Warehouse	50	createDate	Creation Date - History	Date	8	0
145	OIVL	Whse Journal	22	CreateDate	Creation Date	Date	8	0
146	OMRL	Advanced Inventory Revaluation	19	CreateDate	Creation Date	Date	8	0
147	OMRV	Inventory Revaluation	12	CreateDate	Creation Date	Date	8	0
148	OPKL	Pick List	14	CreateDate	Creation Date	Date	8	0
149	OPLN	Price Lists	17	CreateDate	Creation Date	Date	8	0
150	ORTL	Resource Transaction Log	14	CreateDate	Creation Date	Date	8	0
151	OSPP	Special Prices	13	CreateDate	Creation Date	Date	8	0
152	OSRN	Serial Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
153	OUGP	UoM Group	10	CreateDate	Creation Date	Date	8	0
154	OUOM	UoM Master Data	10	CreateDate	Creation Date	Date	8	0
155	OWHS	Warehouses	56	createDate	Creation Date - History	Date	8	0
156	OWKO	Production Instructions	19	CreateDate	Creation Date	Date	8	0
157	OWOR	Production Order	26	CreateDate	Creation Date	Date	8	0
158	OWTQ	Inventory Transfer Request	65	CreateDate	Creation Date	Date	8	0
159	OWTR	Inventory Transfer	65	CreateDate	Creation Date	Date	8	0
160	SITM	Items	166	CreateDate	Production Date	Date	8	0
161	SITW	Items - Warehouse	50	createDate	Creation Date - History	Date	8	0
162	SIVL	Whse Journal	22	CreateDate	Creation Date	Date	8	0
163	UBTN	Batch Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
164	UILM	IVI Inventory Log Message	34	CreateDate	Creation Date	Date	8	0
165	UITM	Items	166	CreateDate	Production Date	Date	8	0
166	UITW	Items - Warehouse	50	createDate	Creation Date - History	Date	8	0
167	UIVL	Whse Journal	22	CreateDate	Creation Date	Date	8	0
168	USRN	Serial Numbers Master Data	11	CreateDate	Creation Date	Date	8	0
169	UWKO	Production Instructions	19	CreateDate	Creation Date	Date	8	0
170	UWOR	Production Order	26	CreateDate	Creation Date	Date	8	0
TOPMarketing Documents
171	ADOC	Invoice - History	65	CreateDate	Creation Date	Date	8	0
172	ATXI	Tax Invoice - History	11	CreateDate	Creation Date	Date	8	0
173	OCIN	A/R Correction Invoice	65	CreateDate	Creation Date	Date	8	0
174	OCPI	A/P Correction Invoice	65	CreateDate	Creation Date	Date	8	0
175	OCPV	A/P Correction Invoice Reversal	65	CreateDate	Creation Date	Date	8	0
176	OCSI	A/R Correction Invoice	65	CreateDate	Creation Date	Date	8	0
177	OCSV	A/R Correction Invoice Reversal	65	CreateDate	Creation Date	Date	8	0
178	ODLN	Delivery	65	CreateDate	Creation Date	Date	8	0
179	ODPI	A/R Down Payment	65	CreateDate	Creation Date	Date	8	0
180	ODPO	A/P Down Payment	65	CreateDate	Creation Date	Date	8	0
181	ODRF	Drafts	65	CreateDate	Creation Date	Date	8	0
182	ODWZ	Dunning Wizard	4	CreateDate	Creation Date	Date	8	0
183	OGTI	GTS Invoice	2	CreateDate	Create Date	Date	8	0
184	OGTM	GTS Mapping Object	2	CreateDate	Create Date	Date	8	0
185	OIEI	Incoming Excise Invoice	65	CreateDate	Creation Date	Date	8	0
186	OINV	A/R Invoice	65	CreateDate	Creation Date	Date	8	0
187	OIVM	GTS Invoice Mapping Object	2	CreateDate	Create Date	Date	8	0
188	OOEI	Outgoing Excise Invoice	65	CreateDate	Creation Date	Date	8	0
189	OPCH	A/P Invoice	65	CreateDate	Creation Date	Date	8	0
190	OPDN	Goods Receipt PO	65	CreateDate	Creation Date	Date	8	0
191	OPOR	Purchase Order	65	CreateDate	Creation Date	Date	8	0
192	OPQT	Purchase Quotation	65	CreateDate	Creation Date	Date	8	0
193	OPRQ	Purchase Request	65	CreateDate	Creation Date	Date	8	0
194	OQUT	Sales Quotation	65	CreateDate	Creation Date	Date	8	0
195	ORCP	Recurring Transaction Template	13	CreateDate	Creation Date	Date	8	0
196	ORDN	Returns	65	CreateDate	Creation Date	Date	8	0
197	ORDR	Sales Order	65	CreateDate	Creation Date	Date	8	0
198	ORIN	A/R Credit Memo	65	CreateDate	Creation Date	Date	8	0
199	ORPC	A/P Credit Memo	65	CreateDate	Creation Date	Date	8	0
200	ORPD	Goods Return	65	CreateDate	Creation Date	Date	8	0
201	OSAL	Outgoing	33	CreateDate	Creation Date	Date	8	0
202	OTPI	Purchase Tax Invoice	11	CreateDate	Creation Date	Date	8	0
203	OTRA	Transition	33	CreateDate	Creation Date	Date	8	0
204	OTSI	Sales Tax Invoice	11	CreateDate	Creation Date	Date	8	0
205	OTXD	Tax Invoice Draft	11	CreateDate	Creation Date	Date	8	0
206	OWDD	Docs. for Confirmation	11	CreateDate	Production Date	Date	8	0
207	WDD1	Documents for Approval - Authorizers	7	CreateDate	Request Date	Date	8	0
TOPReports
208	AEC1	Parameters for Various Types of Electronic Communication	10	CreateDate	Creation Date	Date	8	0
209	AEC2	Electronic Transactions	26	CreateDate	Creation Date	Date	8	0
210	AEC3	Statuses and Logs for Actions in Electronic Communication	5	CreateDate	Creation Date	Date	8	0
211	ATHL	Thresholds	9	CreateDate	Creation Date	Date	8	0
212	ECM1	Parameters for Various Types of Electronic Communication	10	CreateDate	Creation Date	Date	8	0
213	ECM2	Electronic Transactions	26	CreateDate	Creation Date	Date	8	0
214	ECM3	Statuses and Logs for Actions in Electronic Communication	5	CreateDate	Creation Date	Date	8	0
215	OEBL	E-Balance	4	CreateDate	Create Date	Date	8	0
216	OLLR	Electronic Report Generation Result	3	CreateDate	Creation Date	Date	8	0
217	OTHL	Thresholds	9	CreateDate	Creation Date	Date	8	0
218	OTRB	Tax Report Wizard for Brazil	16	CreateDate	Creation Date	Date	8	0
219	RDC1	Multilingual Report	6	CreateDate	Create Date	Date	8	0
220	RDOC	Document	52	CreateDate	Creation Date	Date	8	0
221	XROBJ	XLR Company Report Objects	5	CreateDate	Creation Date	Date	8	0
TOPService
222	AINS	Customer Equipment Card - History	39	createDate	Creation Date	Date	8	0
223	ASC1	Service Call Solutions - History	7	createDate	Creation Date - History	Date	8	0
224	ASC2	Service Call Inventory Expenses - History	15	CreateDate	Creation Date - History	Date	8	0
225	ASC3	Service Call Travel/Labor Expenses - History	15	CreateDate	Creation Date	Date	8	0
226	ASC4	Service Call Travel/Labor Expenses - History	10	CreateDate	Creation Date	Date	8	0
227	ASC5	Service Call Activities - History	7	CreateDate	Creation Date	Date	8	0
228	ASCL	History	27	createDate	Creation Date	Date	8	0
229	OCTR	Service Contracts	45	CreateDate	Creation Date	Date	8	0
230	OCTT	Contract Template	37	CreateDate	Creation Date	Date	8	0
231	OINS	Customer Equipment Card	39	createDate	Creation Date	Date	8	0
232	OREQ	External System Call Request	4	CreateDate	Request Creation Date	Date	8	0
233	OSCL	Service Calls	27	createDate	Creation Date	Date	8	0
234	QUE2	Queue Elements	6	createDate	Creation Date	Date	8	0
235	SCL1	Service Call Solutions - Rows	7	createDate	Creation Date	Date	8	0
236	SCL2	Service Call Inventory Expenses	15	CreateDate	Creation Date	Date	8	0
237	SCL3	Service Call Travel/Labor Expenses	15	CreateDate	Creation Date	Date	8	0
238	SCL4	Expense Documents	10	CreateDate	Creation Date	Date	8	0
239	SCL5	Service Call Activities	7	CreateDate	Creation Date	Date	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

239 columns | B1 9.2 | CREATEDATE