	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

139 columns | ERP 6.0 | NOTE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SAPPSSRM/TDPD	Tendering Payment Details of an RFx Responder	13	NOTE	Note Text	nvarchar	255	0
2	BBPC_SUS_BTNDEF	Definition of Displayable Buttons in a View or THTMLB Table	16	NOTE	Button Group to Define Named Toolbars	nvarchar	60	0
3	BPC_FIL_ROLE	Table for Filtering Roles (in Inbound)	3	NOTE	Comment	nvarchar	50	0
4	CMCBD_BRF_HSTRY	Cash Budget Workflow History for BRF+	9	NOTE		ntext	1073741823	0
5	CMCBD_COMMENT_PL	Cash Budgeting Workflow History	6	NOTE		ntext	1073741823	0
6	CMCBD_WF_HISTORY	Cash Budgeting Workflow History	8	NOTE		ntext	1073741823	0
7	CMCBD_WKLIST_NA	Work List: Alert/Notification Table	10	NOTE	Work List: Item Note	nvarchar	255	0
8	CMCBD_WKLIST_TK	Work List: Tasks Table	12	NOTE	Work List: Item Note	nvarchar	255	0
9	DFKKEPRT	Log for Inconsistent FI-CA Documents	61	NOTE	Item text	nvarchar	50	0
10	GRACROLETST	Role Testing Header	7	NOTE	Indicator	nvarchar	1	0
11	IDGT_GTDH	GT Document Header	22	NOTE	GT Note	nvarchar	160	0
12	IDGT_VATH	VAT Invoice Header	17	NOTE	GT Note	nvarchar	160	0
13	LXE_CSN_LOG	Log Data for Notes	1	NOTE	SAP Note Number	nvarchar	10	0
14	MRP_REQ_NOTE	Requests and Notes for MRP Cockpit	21	NOTE	Note for the Change Request	ntext	1073741823	0
15	OBJM_EXT	Extension of OBJM	8	NOTE	Note number	nvarchar	10	0
16	SLAPI	SOBJ: API called by an after import method	6	NOTE	Note number	nvarchar	10	0
17	T77PAODYRULE	Dynamic Processing Rules	11	NOTE	Note	nvarchar	255	0
18	T7CNTPM_PROCREC	TPM: Process Record	7	NOTE	Note Text	nvarchar	100	0
19	ZTRL_PEXPT	Ausnahmen Übersetzung (Kopie LANG_PEXPT)	8	NOTE	Textfeld	nvarchar	50	0
20	ZTRL_PEXPT1	Ausnahmen Übersetzung (Kopie LANG_PEXPT)	8	NOTE	Textfeld	nvarchar	50	0
21	PIQPROC_ED_GRP	ED Activity Document: Transferred Work Grouping	5	NOTE	GUID - Unique Note Identifier	nvarchar	32	0
22	PIQPROC_ED_H	ED Activity Document: Header Data	6	NOTE	GUID - Unique Note Identifier	nvarchar	32	0
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
23	CRMCHKMSG_REMOTE	OUTDATED - TO BE DELETED - ACCESS STRONGLY DISCOURAGED	4	NOTE		nvarchar	80	0
24	CRMCHKPRF	Check Profiles	5	NOTE	Description	nvarchar	60	0
25	SCIEXCEPTN	Code Inspector: Exception Table	13	NOTE	SCI: Comments for an Exception	nvarchar	72	0
26	SCIEXCEPTN_APPL	Code Inspector: Table of Exception Requests	16	NOTE	CHAR72 data element for SYST	nvarchar	72	0
TOPAccounting - General
27	FAGL_CLOCO_COMNT	Comments for Closing Cockpit	11	NOTE	Comment	ntext	1073741823	0
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
28	UKRST	Course Enrollment (Results)	5	NOTE	Mark	decimal	2	1
29	UKRTB	Course Participation (Results)	4	NOTE	Mark	decimal	2	1
TOPAP-LIM Logistics Inventory Management Engine
30	/LIME/COLL_APS	Collection for Planning System	16	NOTE	Notes	nvarchar	50	0
31	/LIME/COLL_BW	Collection for Business Warehouse	16	NOTE	Notes	nvarchar	50	0
32	/LIME/COLL_FIN	Collection for Financial System	16	NOTE	Notes	nvarchar	50	0
33	/LIME/COLL_INV	Collection for Inventory System	16	NOTE	Notes	nvarchar	50	0
34	/LIME/COLL_LEG	Collection for External System	16	NOTE	Notes	nvarchar	50	0
35	/LIME/COLL_MMIM	Collection for R/3 Inventory Management	16	NOTE	Notes	nvarchar	50	0
36	/LIME/COLL_W2IM	Collection for WME after ERP-MMIM	16	NOTE	Notes	nvarchar	50	0
37	/LIME/PN_ITEM	Table to Save Prima Nota Item Data	69	NOTE	Notes	nvarchar	50	0
TOPApplication-Specific Upgrade
38	/ASU/CONTENT	ASU: Content	15	NOTE	ASU: Note Number	nvarchar	10	0
39	/ASU/STEPS	ASU Steps	16	NOTE	ASU: Note Number	nvarchar	10	0
40	/ASU/STEPS_V	ASU Steps (Version)	15	NOTE	ASU: Note Number	nvarchar	10	0
TOPArchiveLink
41	TOAPI	SAP ArchiveLink interface	38	NOTE	Single-Character Indicator	nvarchar	1	0
TOPBalanced Scorecard
42	UMB_SC187	Scorecard: Initiative: Message for Team Members	6	NOTE	Note	nvarchar	60	0
43	UMB_SC198	Scorecard: Initiative: Milestones (Text Table)	7	NOTE	Description	ntext	1073741823	0
TOPBank Customer Accounts
44	TBKKIHB1	In-House Bank ID from Payment Notes in Bank Statement	6	NOTE	Character Sequence in Payment Notes of Bank Statement	nvarchar	70	0
TOPBasic Functions
45	TPAMAT	Text Table for Search String TPAMA	5	NOTE	Description	nvarchar	64	0
46	UDM_T_CORRCONT	FSCM-DM: Container (Dialog Correspondence)	4	NOTE	Name	nvarchar	70	0
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
47	COAT_NOTES	COAT: Notes	6	NOTE	Character Field Length = 10	nvarchar	10	0
TOPBusiness Package for Manager Self-Service FI
48	FPB_EXP_COMMENT	Express Planning: Comments	11	NOTE		ntext	1073741823	0
TOPCheck Input
49	OIUCI_NOTES	Notes for Suspended Line item of Incoming Check	6	NOTE	Note Text for Line items	nvarchar	132	0
TOPClaims Management
50	ICLDRGITEM	DRG Item	25	NOTE	Note for Diagnosis Related Groups	nvarchar	80	0
51	ICLITEMEQ	Damaged Item	37	NOTE	Note on Salvage	nvarchar	50	0
52	ICLITEMRE	Damaged Real Estate	30	NOTE	Note on Salvage	nvarchar	50	0
53	ICLPAY	Claim Payment	31	NOTE	Payment Note	nvarchar	50	0
54	ICL_BENSPLIT_ITM	Benefit Split Item (One-Time)	23	NOTE	Payment Note	nvarchar	50	0
55	ICL_BENSPPER_ITM	Benefit Split Item (Periodic)	18	NOTE	Payment Note	nvarchar	50	0
56	ICSDRGITEM	DRG Item	25	NOTE	Note for Diagnosis Related Groups	nvarchar	80	0
57	ICSITEMEQ	Damaged Item	37	NOTE	Note on Salvage	nvarchar	50	0
58	ICSITEMRE	Damaged Real Estate	30	NOTE	Note on Salvage	nvarchar	50	0
59	ICSPAY	Payment	31	NOTE	Payment Note	nvarchar	50	0
60	ICS_BENSPLIT_ITM	Benefit Split Item (Shadow Table)	23	NOTE	Payment Note	nvarchar	50	0
61	ICS_BENSPPER_ITM	Benefit Split Item (Shadow Table)	18	NOTE	Payment Note	nvarchar	50	0
TOPClinical System
62	N2GL_ACT_NOTE	Pathways: Comment on Activity	9	NOTE	pathways Note	ntext	1073741823	0
TOPCollaboration Folders
63	CFX_NTF_TEMPLATE	Table for storing information about Notification Templates	6	NOTE	Commentary Text for Notifications	ntext	1073741823	0
TOPCollateral Management System
64	CMS_PCN_CR	Change Requests	15	NOTE	Change Request Note	nvarchar	60	0
65	CMS_TSK	Tasks	14	NOTE	Task Note	nvarchar	60	0
66	TCMS_CD_BUSINFO	Classification of a change to a business object - internal	5	NOTE	Note for the change	nvarchar	60	0
TOPConnection to External Systems
67	DPR_OBJLINK_SC	Object Link to SRM Shopping Carts	12	NOTE	Description of Request	nvarchar	40	0
68	DPR_OBJLINK_SC_I	Items for SRM Shopping Cart	24	NOTE	Description of Request	nvarchar	40	0
TOPCorporate Performance Monitor
69	UMR_RI141T	RMS: Risk-Reducing Activities - Milestones - Text Table	8	NOTE	Description	ntext	1073741823	0
70	UMR_RI142	RMS: Risk-Reducing Activities - Team Members	9	NOTE	Note	nvarchar	60	0
TOPCross-Application Components
71	TASUTREP	ASU: Toolbox: Reports to be started	19	NOTE	ASU: Toolbox: According note	nvarchar	10	0
TOPCustomer Enhancements
72	SMODIPROJ	Customer Modifications to WB Objects in Several Projects	9	NOTE	Customer enhancement: Text	nvarchar	60	0
TOPDocument Builder
73	/IPRO/TDOCMNT	Document Builder Documents	39	NOTE	Text, 255 Characters	nvarchar	255	0
74	/IPRO/TTEMPL	Document Builder Templates	10	NOTE	Template Note	ntext	1073741823	0
75	/IPRO/TUSRTMPL	Table of user template data	8	NOTE	Template Note	ntext	1073741823	0
TOPE-Recruiting
76	HRP5112	DB Table for Infotype 5112	20	NOTE	Notes of Talent Consultant About a Candidate	nvarchar	6	0
77	HRP5125	DB Table for Infotype 5125	20	NOTE	Notes on Requisition (Pointer)	nvarchar	6	0
78	HRP5135	DB Table for Infotype 5135	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
79	HRP5136	DB Table for Infotype 5136	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
80	HRP5137	DB Table for Infotype 5137	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
81	HRP5138	DB Table for Infotype 5138	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
82	HRP5139	DB Table for Infotype 5139	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
83	HRP5140	DB Table for Infotype 5140	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
84	HRP5141	DB Table for Infotype 5141	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
85	HRP5142	DB Table for Infotype 5142	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
86	HRP5143	Database Table for Infotype 5143	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
87	HRP5144	Database Table for Infotype 5144	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
88	HRP5145	Database Table for Infotype 5145	24	NOTE	Activity Note (Pointer)	nvarchar	6	0
89	T77RCF_CANDNOTES	Candidate Notes	8	NOTE		ntext	1073741823	0
TOPEnergy Data Management
90	EDEXTASKCONFERR	Data Exchange Task Confirmation Msssages Log	7	NOTE	Message Text	nvarchar	220	0
TOPEnterprise Compensation Management
91	T71ADM_EE_NOTE	Compensation Tracking of Employee notes	4	NOTE		ntext	1073741823	0
92	T71ADM_PROC_NOTE	Notes for Compensation Process Tracking	6	NOTE		ntext	1073741823	0
TOPError and Conflict Handler
93	FEH_MESS_PERS	Persistence of the Payload and other Data Relevant to FEH	12	NOTE	Payload Note	ntext	1073741823	0
TOPIntegration Engine
94	SXMSDCONF	Integration Engine: Settings for Deletion Concept	7	NOTE	XMS: Flag (true/false)	nvarchar	1	0
TOPKnowledge Warehouse
95	IWADM	Data for KEN Administration	20	NOTE	Comment	nvarchar	64	0
TOPLocalization
96	IDGT_INFO	GTI China: Data sent to GT	10	NOTE	GT Note	nvarchar	160	0
TOPMaster Data
97	ENOTE	Allocation of Object to Note for Field Service	6	NOTE	Static note to field service	nvarchar	2	0
98	ENOTET	Text Table for Field Service Notes	6	NOTE	Static note to field service	nvarchar	2	0
TOPMedical Patient Data Organization Patient Organizer
99	N1STRUCMEDRECCAT	IS-H*MED: Health Problems Catalog	14	NOTE	Comment for Health Problem	nvarchar	255	0
TOPMeter Reading
100	TE580N	Dynamic Notes to Field Service	2	NOTE	Dynamic note to field service	nvarchar	2	0
101	TE580T	Dynamic Notes to Field Service (Texts)	3	NOTE	Dynamic note to field service	nvarchar	2	0
102	TE582	Static Notes to Field Service	2	NOTE	Static note to field service	nvarchar	2	0
103	TE582T	Static Notes to Field Service (Texts)	3	NOTE	Static note to field service	nvarchar	2	0
TOPNetWeaver Enterprise Search
104	ESH_QP_QUE_GRAM	Query Grammar	8	NOTE	Query Parser Mapping	ntext	1073741823	0
TOPNon Profit Organizations
105	T7UNSLWOP_RC	SLWOP periods to be ignored for next reclassification date	3	NOTE		nvarchar	20	0
TOPPackage Tools
106	AKB_PRODUCTS	Product Catalog	8	NOTE	Long Text	ntext	1073741823	0
107	AKB_PRODUCT_COMP	Obsolete: Product Composition	6	NOTE	Obsolete: Comment	nvarchar	80	0
108	AKB_TRANS_CHECK	Obsolete: Compatibility Control	26	NOTE	Obsolete: Comment	nvarchar	80	0
TOPPrint and Output Management
109	TSPOPIP	Printer / device type repations	9	NOTE	Note number	nvarchar	8	0
110	TSPOPIPRN	Printer / device type relations	9	NOTE	Note number	nvarchar	8	0
111	TSPOPIPRN_WORK	Printer / device type relations	9	NOTE	Note number	nvarchar	8	0
TOPProcessing
112	TEOBJRESP	Def. Partner Roles and Note for Persons Responsible for Obj.	2	NOTE	Static note to field service	nvarchar	2	0
TOPSAP Business Partner
113	COMM_CLEAR_STACK	Data Cleansing Cases	10	NOTE	Data Cleansing: Note	nvarchar	50	0
TOPSAP Business Workflow
114	SWDANOTES	References to Notes for Ad Hoc Agents	3	NOTE	Object ID	nvarchar	90	0
TOPSAP Note Assistant
115	SMODIUSER	Processor of Customer Modifications	15	NOTE	Customer Enhancement: Text with 132 Characters	nvarchar	132	0
TOPSAP Utilities
116	TEAMI_LOG_MSG	Messages for AMI Communication (TEAMI_LOG_DATA)	7	NOTE	Text for translation	nvarchar	200	0
TOPSuite Inbox
117	IBO_C_WF_TAC	Tasks for Inbox Configuration	6	NOTE	Define Notes Enablement	nvarchar	1	0
118	IBO_C_WF_TAE	Tasks for Inbox Configuration (Exceptions in Multibackend)	7	NOTE	Define Notes Enablement	nvarchar	1	0
119	IBO_C_WF_TAS	Tasks for Inbox Configuration	6	NOTE	Define Notes Enablement	nvarchar	1	0
TOPTrading Contract
120	WB2_C_PF_MTHD_PM	Execution Paramter in Method for Processing of Follow-on doc	6	NOTE	Short Description	nvarchar	60	0
TOPTranslation Tools
121	LANG_LEXPT	Local Supplement for Exceptions: Translation	8	NOTE	Text Field	nvarchar	50	0
122	LANG_PEXPT	Translation exception	8	NOTE	Text Field	nvarchar	50	0
123	LXE_CSN	Object Lists	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
124	LXE_CSN_BK	Notes	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
125	LXE_CSN_HD	Notes	2	NOTE	SAP Note Number	nvarchar	10	0
126	LXE_CSN_HD2	Notes	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
127	LXE_CSN_PRIO	Notes	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
128	LXE_CSN_TXL	Notes	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
129	LXE_CSN_TXS	Notes	2	NOTE	Numeric Character Field, Length 10	nvarchar	10	0
130	LXE_LEXPT	Translation exception	8	NOTE	Text Line With 50 Characters	nvarchar	50	0
131	LXE_PEXPT	Translation exception	8	NOTE	Text Line With 50 Characters	nvarchar	50	0
TOPTransport Management System
132	TMSQWLF	TMS QA: Worklist - QA Flags for Requests	14	NOTE	General Flag	nvarchar	1	0
133	TMSQWLFH	TMS QA: Worklist - QA Flags for Requests	14	NOTE	General Flag	nvarchar	1	0
TOPUpgrade - General
134	MERGENEGLN	Exclusion Objects Merger Central Maintenance Table	12	NOTE	Note number	nvarchar	10	0
TOPUpgrade Tools
135	CRRERROR	CRR Error Messages	19	NOTE	Note number	nvarchar	10	0
TOPVendor Evaluation
136	EVAL_IV_RES_HD	Results of Vendor Evaluation (Header)	18	NOTE	Score variance	decimal	3	0
137	EVAL_IV_RES_ITM	Results of Vendor Evaluation (Item)	12	NOTE	Score variance	decimal	3	0
TOPWaste Management
138	EWA_WA_WEIGHPROC	Weighing Transaction	102	NOTE	Description	nvarchar	254	0
TOPWork Management Mobile Business
139	EWM_DEFAULTS	MAU: Define Default Values for Selection Fields	2	NOTE	Static note to field service	nvarchar	2	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

139 columns | ERP 6.0 | NOTE