	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

91 columns | ERP 6.0 | ITEMID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	4	ITEMID	Document Item Id	nvarchar	5	0
2	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	4	ITEMID	Document Item Id	nvarchar	5	0
3	/OPT/VIM_1ITEM_S	Document Item	3	ITEMID	Document Item Id	nvarchar	5	0
4	/OPT/VIM_1PROC	Workflow Information for VIM Processes	5	ITEMID	Document Item in Invoice Document	nvarchar	6	0
5	/OPT/VIM_CUSTOMS	Customs data for imported goods	3	ITEMID	Document Item Id	nvarchar	5	0
6	/OPT/VIM_TITEM	Document Item	3	ITEMID	Document Item Id	nvarchar	5	0
7	/ORS/PS_ITEM	Profitability Segment Fields and Values	3	ITEMID	Document Item Id	nvarchar	5	0
8	PPHMRPLOGITEM	MRP Live Log Item	3	ITEMID	Natural Number	int	10	0
9	PPHMRPPPLOGITEM	MRP Live Postprocessing Log Item	3	ITEMID	Natural Number	int	10	0
10	YVIM_1ITEM	Document Item	3	ITEMID	Document Item Id	nvarchar	5	0
TOPCollectionsDisbursements
11	VVSCPOSICDR	Payment Plan Item: Data for ICDR Service	7	ITEMID	Item ID of an InsuranceCollectionDisbursementRequest	nvarchar	15	0
TOPEnd User Technology
12	RSZW30ITEMSREUSE	Conversion of Chart Settings from BW 3.0 to BW 3.5	1	ITEMID	Technical Name of an Item	nvarchar	30	0
13	RSZWITEM	Header Table for BW Web Items	1	ITEMID	Technical Name of an Item	nvarchar	30	0
14	RSZWITEMATTR	Attribute Table of the Items (Contains Search Attributes)	1	ITEMID	Technical Name of an Item	nvarchar	30	0
15	RSZWITEMDATA	BW Web Item Data (7.0)+	1	ITEMID	Technical Name of an Item	nvarchar	30	0
16	RSZW_WBITEMS	Table of Deleted BDS Items and Views	4	ITEMID	Short description	nvarchar	20	0
TOPFinancial Accounting
17	/OPT/VIM_1ITEM	Document Item	3	ITEMID	Document Item Id	nvarchar	5	0
TOPLease Accounting
18	/LSIERP/TRIG_NA	Leases Not Set to Non-Accrual	2	ITEMID	GUID of Item of CRM Contract	varbinary	16	0
19	FILA_MIG_SYNC	Synchronization of CRM and LAE Legacy Data	6	ITEMID	GUID of Item of CRM Contract	varbinary	16	0
20	LAE_BILLING_DAT	Payment Schedule	4	ITEMID	Object Number	varbinary	16	0
21	LAE_CRM_LNK	Link between LAE and CRM Contract Items	3	ITEMID	GUID of Item of CRM Contract	varbinary	16	0
TOPNetwork Operations
22	GHO_NETVER_ITM	Items of a Production Network Version	4	ITEMID	GHO Production Network Version Item Identification	nvarchar	8	0
TOPPerformance Assessment Workbench
23	SLS_CRITEM	PAW - Comments for an item from a participant	3	ITEMID	PAW identifier	nvarchar	8	0
24	SLS_IESS1	PAW - Item Essay 1	2	ITEMID	PAW identifier	nvarchar	8	0
25	SLS_IESS2	PAW - Item Essay 2	2	ITEMID	PAW identifier	nvarchar	8	0
26	SLS_IEVAL	PAW - Item Evaluation	2	ITEMID	PAW identifier	nvarchar	8	0
27	SLS_IFILL	PAW - Item Fillin	2	ITEMID	PAW identifier	nvarchar	8	0
28	SLS_ILC1	PAW - Item LC1	2	ITEMID	PAW identifier	nvarchar	8	0
29	SLS_ILC2	PAW - Item LC2	2	ITEMID	PAW identifier	nvarchar	8	0
30	SLS_IMC	PAW - Item Multiple Choice	2	ITEMID	PAW identifier	nvarchar	8	0
31	SLS_IRATE	PAW - Item Rate	2	ITEMID	PAW identifier	nvarchar	8	0
32	SLS_ITEM	PAW - Item Description	2	ITEMID	PAW identifier	nvarchar	8	0
33	SLS_RESS1	PAW - Result for Item Essay 1	3	ITEMID	PAW identifier	nvarchar	8	0
34	SLS_RESS2	PAW - Result for Item Essay 2	3	ITEMID	PAW identifier	nvarchar	8	0
35	SLS_RFILL	PAW - Result Item Fillin	3	ITEMID	PAW identifier	nvarchar	8	0
36	SLS_RITEM	PAW - Result on Item	3	ITEMID	PAW identifier	nvarchar	8	0
37	SLS_RLC	PAW - Result for Item Listchoice	3	ITEMID	PAW identifier	nvarchar	8	0
38	SLS_RMC	PAW - Result for Item Multiple Choice	3	ITEMID	PAW identifier	nvarchar	8	0
39	SLS_RRATE	PAW - Result for Item RATE	3	ITEMID	PAW identifier	nvarchar	8	0
40	SLS_TSTRU	PAW - Test Structure	6	ITEMID	PAW identifier	nvarchar	8	0
41	SLS_YESS1	PAW - Result for Item Essay 1	3	ITEMID	PAW identifier	nvarchar	8	0
42	SLS_YESS2	PAW - Result for Item Essay 2	3	ITEMID	PAW identifier	nvarchar	8	0
43	SLS_YFILL	PAW - Result Item Fillin	3	ITEMID	PAW identifier	nvarchar	8	0
44	SLS_YITEM	PAW - Result on Item	3	ITEMID	PAW identifier	nvarchar	8	0
45	SLS_YLC	PAW - Result for Item Listchoice	3	ITEMID	PAW identifier	nvarchar	8	0
46	SLS_YMC	PAW - Result for Item Multiple Choice	3	ITEMID	PAW identifier	nvarchar	8	0
47	SLS_YRATE	PAW - Result for Item RATE	3	ITEMID	PAW identifier	nvarchar	8	0
TOPProcess Management
48	TCOOPC_ITEM	OPC: Plant-Specific Custom. Table for OPC Item Definition	5	ITEMID	OPC: Fully Qualified OPC Item ID	nvarchar	255	0
TOPSocial Services and Social Security
49	PSSCD_GEDITEM	Gross Entitlement Determination Item Data	3	ITEMID	Social Services Business Object Item ID	nvarchar	32	0
50	PSSCD_GPDITEM	Gross Payment Docment Item Data	3	ITEMID	Social Services Business Object Item ID	nvarchar	32	0
51	PSSCD_NCDITEM	Net Calculation Document Item	3	ITEMID	Social Services Business Object Item ID	nvarchar	32	0
52	PSSCD_SXPITEM	SXP Item Data	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
53	PSSCD_SXP_APPT	SXP Appointment	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
54	PSSCD_SXP_CUST_I	SXP Customer Include (Item)	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
55	PSSCD_SXP_PARTNR	SXP Partner	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
56	PSSCD_SXP_PAYM_R	SXP Additional Payment Recipients	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
57	PSSCD_SXP_STATUS	SXP Status	3	ITEMID	Social Services Business Object Item ID	varbinary	16	0
TOPTransaction Tax Engine
58	TTED_ANALYS_COM	Output Trace	4	ITEMID	Item Identifier	nvarchar	32	0
59	TTED_INITEM_COM	Input item	5	ITEMID	Item Identifier	nvarchar	32	0
60	TTED_OUTITEM_COM	Output Item	5	ITEMID	Item Identifier	nvarchar	32	0
61	TTEPD3_ITEM	Item	5	ITEMID	Item Identifier	nvarchar	32	0
62	TTEPD3_USITEM	Persistency TTE Document UsItem	3	ITEMID	Item Identifier	nvarchar	32	0
63	TTEPDT_ITEM	Persistency TTE Document Item	3	ITEMID	Item Identifier	nvarchar	32	0
64	TTEPDT_ITEMPART	Persistency TTE Document item partner	3	ITEMID	Item Identifier	nvarchar	32	0
65	TTEPDT_ORGUNIT	Persistency TTE Document org unit	3	ITEMID	Item Identifier	nvarchar	32	0
66	TTEPDT_PRICEL	Persistency TTE Document / Item pricing element	3	ITEMID	Item Identifier	nvarchar	32	0
67	TTEPDT_TAXCODVA	Document / Item TaxCode Value	4	ITEMID	Item Identifier	nvarchar	32	0
68	TTEPDT_TAXDATE	Persistemcy TTE Document tax date	3	ITEMID	Item Identifier	nvarchar	32	0
69	TTEPDT_TAXEL	Persistency TTE Document / Item tax element	4	ITEMID	Item Identifier	nvarchar	32	0
70	TTEPDT_TAXEVENT	Persistency TTE Document / Item tax event	4	ITEMID	Item Identifier	nvarchar	32	0
71	TTEPDT_TAXVALUE	Persistency TTE Document / Item tax value	4	ITEMID	Item Identifier	nvarchar	32	0
72	TTEPDT_TRANPROP	Persistency TTE Document transaction property	3	ITEMID	Item Identifier	nvarchar	32	0
73	TTEPDT_USITEM	Persistency TTE Document UsItem	3	ITEMID	Item Identifier	nvarchar	32	0
74	TTESDT_ANALYSYS	Pricing Trace from Tax Calculation	3	ITEMID	Item Identifier	nvarchar	32	0
75	TTESDT_ITEM	Item	3	ITEMID	Item Identifier	varbinary	16	0
76	TTESDT_ITEMPART	Document item partner	3	ITEMID	Item Identifier	varbinary	16	0
77	TTESDT_ORGUNIT	Document org unit	3	ITEMID	Item Identifier	varbinary	16	0
78	TTESDT_PRICEL	Document / Item pricing element	3	ITEMID	Item Identifier	varbinary	16	0
79	TTESDT_TAXCODVA	Document / Item pricing element	4	ITEMID	Item Identifier	varbinary	16	0
80	TTESDT_TAXDATE	Document tax date	3	ITEMID	Item Identifier	varbinary	16	0
81	TTESDT_TAXEL	Document / Item tax element	4	ITEMID	Item Identifier	varbinary	16	0
82	TTESDT_TAXEVENT	Document / Item tax event	4	ITEMID	Item Identifier	varbinary	16	0
83	TTESDT_TAXVALUE	Document / Item tax value	4	ITEMID	Item Identifier	varbinary	16	0
84	TTESDT_TRANPROP	Document transaction property	3	ITEMID	Item Identifier	varbinary	16	0
85	TTESDT_USITEM	Output Exemptions	3	ITEMID	Item Identifier	nvarchar	32	0
TOPWorkplace Server
86	TCBRCUSTOM	Customer Branding Parameter Table	2	ITEMID	ParameterID	nvarchar	40	0
87	TWPCUSTMCT	Text Table for Customer System Settings for Workplace	4	ITEMID	Entry ID for System Settings	nvarchar	10	0
88	TWPCUSTOM	System Setting for the Workplace	2	ITEMID	Entry ID for System Settings	nvarchar	10	0
89	TWPCUSTOMC	Customer-Defined System Setting for the Workplace	3	ITEMID	Entry ID for System Settings	nvarchar	10	0
90	TWPCUSTOMT	Text Table for System Settings for the Workplace	3	ITEMID	Entry ID for System Settings	nvarchar	10	0
91	USRGENPRS	Table for General Workplace Personalization Data	4	ITEMID	Entry ID for System Settings	nvarchar	10	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

91 columns | ERP 6.0 | ITEMID