	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

36 columns | ERP 6.0 | FROMYEAR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMD/MD_____001V	SID-Tabelle fuer Starting Year	3	FROMYEAR	Starting Year	nvarchar	4	0
2	CNV_20201_RNMB	Conversion rules for number ranges	6	FROMYEAR	From fiscal year for conversion rule	nvarchar	4	0
3	UCS01AC	Tasks: Data Transfer	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
4	UCS01AD1	Tasks: Sign-Off	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
5	UCS01AE	Tasks: Reconciliations	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
TOPBusiness Consolidation
6	UCF2110	C/T: E/R Indicators: E/R Type Assignments	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
7	UCF9010	Balance Carryforward: Items to be Carried	5	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
8	UCF9020	Balance Carryforward: Document Type Assignment	5	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
9	UCFC010	Consolidation Group Change: Document Type Assignment	5	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
10	UCFI200	IPI Customizing: Inventory Items	5	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
11	UCM6100	Organizational Change: Top Nodes	5	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
12	UCMA100	Type of Assets/Liabilities: Posting Items	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
13	UCMA101	Type of Asset/Liability: Consolidation Frequency	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
14	UCMI200	Selected Items: Cross-Functional	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
15	UCMI201	Selected Items: Document Type-dependent	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
16	UCMI210	Selected Items: Consolidation of Investments	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
17	UCMI220	Selected Items: Elimination of IU Profit/Loss in Inventory	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
18	UCS0100	Tasks: Method	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
19	UCS0101	Tasks: Document Type	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
20	UCS0103	Tasks: Elimination of IU P/L in Inventory	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
21	UCS0104	Tasks: Validation	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
22	UCS0105	Tasks: Cons Frequency	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
23	UCS0106	Tasks: Posting Levels	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
24	UCS0110	Tasks: Preceding Tasks	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
25	UCS0120	Tasks: Status-bearing Cons Groups	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
26	UCS01A2	Tasks: Log Layout: Sequence, Active/Inactive	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
27	UCS01A3	Tasks: IPA or CVA	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
28	UCS01A4	Tasks: Cons Group Selection	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
29	UCS01A5	Tasks: Balance Carryforward Task	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
30	UCS01A6	Tasks: Workflow Variant	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
31	UCS01A7	Measures: Workflow_variant for Sign-Off Task	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
32	UCS01A8	Measures: Selection ID for repunit and repgroup	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
33	UCS01A9	Measures: Query	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
34	UCS01AA	Tasks: Reclassification	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
35	UCS01AB	Tasks: Consolidation Group Change	6	FROMYEAR	Effective from Fiscal Year	nvarchar	4	0
36	UCS0400	Statusbearing Rep.Groups for Interunit Level 10	6	FROMYEAR	Effective from Fiscal Year	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

36 columns | ERP 6.0 | FROMYEAR