	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

136 columns | ERP 6.0 | EXT_KEY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GBT/N_DT_EVNT_I	Detected events, which potentially need to be reloaded	10	EXT_KEY	External Object Key	nvarchar	50	0
2	/IWBEP/I_SBD_XT	SB: DM extensions	3	EXT_KEY	Service Builder: Extension Key	nvarchar	40	0
3	/IWBEP/I_SBD_XTT	SB: DM extension descriptions	3	EXT_KEY	Service Builder: Extension Key	nvarchar	40	0
4	/IWBEP/I_SBU_XT	SB: UI extensions	3	EXT_KEY	Service Builder: Extension Key	nvarchar	40	0
5	/IWBEP/I_SBU_XTT	SB: UI extension descriptions	3	EXT_KEY	Service Builder: Extension Key	nvarchar	40	0
6	/OPT/CT_IDH_DATA	Inbound Document Handler: Table for storing key/value pairs	3	EXT_KEY	Field Name from External System	nvarchar	50	0
7	/OPT/VIM_IDH_EXT	Inbound Document Handler: Table for storing original values	3	EXT_KEY	Field Name from External System	nvarchar	50	0
TOPASAP AcceleratedSAP
8	IATNODE01	Node Table for Implementation Assistant	4	EXT_KEY	External key	nvarchar	12	0
9	IATNODE01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
10	IATNODE01T	Node Names for Implementation Assistant	6	EXT_KEY	External key	nvarchar	12	0
11	TNODEREV	Structure Item Table for Review Structures	4	EXT_KEY	External key	nvarchar	12	0
12	TNODEREVR	References for Review Structures	2	EXT_KEY	External key	nvarchar	12	0
13	TNODEREVT	Structure Item Descriptions for Review Structures	6	EXT_KEY	External key	nvarchar	12	0
14	TTREEBRAEX	Attribute Repository for Structure Nodes: Invalid Industry	4	EXT_KEY	External key	nvarchar	12	0
15	TTREEBRAIN	Attribute Repository for Sturcture Nodes: Valid Industry	4	EXT_KEY	External key	nvarchar	12	0
16	TTREECOUEX	Attribute Repository for Structure Nodes: Invalid Countries	4	EXT_KEY	External key	nvarchar	12	0
17	TTREECOUIN	Attribute Repository for Structure Nodes: Valid Countries	4	EXT_KEY	External key	nvarchar	12	0
18	TTREEFLAEX	Attribute Repository for Hierarchy Nodes: Invalid Flavors	4	EXT_KEY	External key	nvarchar	12	0
19	TTREEFLAIN	Attribute Repository for Hierarchy Nodes: Valid Flavors	4	EXT_KEY	External key	nvarchar	12	0
20	TTREERELEX	Attribute Repository for Hierarchy Nodes: Invalid Release	4	EXT_KEY	External key	nvarchar	12	0
21	TTREERELIN	Attribute Repository for Hierarchy Nodes: Valid Release	4	EXT_KEY	External key	nvarchar	12	0
22	TTREEROAEX	Attribute Repository for Structure Nodes: Invalid Roadmap	4	EXT_KEY	External key	nvarchar	12	0
23	TTREEROAIN	Attribute Repository for Structure Nodes: Valid Roadmap	4	EXT_KEY	External key	nvarchar	12	0
24	TTREEROLEX	Attribute Repository for Structure Nodes: Invalid Role	4	EXT_KEY	External key	nvarchar	12	0
25	TTREEROLIN	Attribute Repository for Structure Nodes: Valid Role	4	EXT_KEY	External key	nvarchar	12	0
26	TTREESUBEX	Attribute Rep. for Structure Nodes: Invalid Subject Area	4	EXT_KEY	External key	nvarchar	12	0
27	TTREESUBIN	Attribute Repository for Structure Nodes: Valid Subject Area	4	EXT_KEY	External key	nvarchar	12	0
TOPASAP Tools and Contents
28	SMAPTNODE	Solution Map: Node table	4	EXT_KEY	External key	nvarchar	12	0
29	SMAPTNODER	Solution Map: Node references	2	EXT_KEY	External key	nvarchar	12	0
30	SMAPTNODET	Solution Map: Node texts	6	EXT_KEY	External key	nvarchar	12	0
TOPAuthoring Tools
31	QMM_NODE	QMM: Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
32	QMM_NODER	QMM: General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
33	QMM_NODET	QMM: General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPBusiness Navigator
34	BMTNODE01	Structure repository for process model objects: Node table	4	EXT_KEY	External key	nvarchar	12	0
35	BMTNODE01R	Structure repository for process model objects: References	2	EXT_KEY	External key	nvarchar	12	0
36	BMTNODE01T	Structure Repository for Process Model Objects: Node Names	6	EXT_KEY	External key	nvarchar	12	0
37	DFTNODE01	Structure repository for process model objects: Node table	4	EXT_KEY	External key	nvarchar	12	0
38	DFTNODE01R	Structure repository for process model objects: References	2	EXT_KEY	External key	nvarchar	12	0
39	DFTNODE01T	Structure Repository for Process Model Objects: Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPCase Management
40	SCMG_T_CASE_ATTR	Case Attributes	4	EXT_KEY	Case ID	nvarchar	12	0
TOPClinical System
41	N2COMM_LOG	Documents Received in Temporary Storage	11	EXT_KEY	External Key of a Transferred Object	nvarchar	120	0
42	N2COMM_LOGSTAT	Last Known Status for Transmitted Object	10	EXT_KEY	External Key of a Transferred Object	nvarchar	120	0
TOPContract Accounts Receivable and Payable
43	DFKKCASEITEMSH	Item List in Cases, Header Data	11	EXT_KEY	Case ID	nvarchar	12	0
44	DFKKWLI_ADD	Additional Collection Case Attributes	3	EXT_KEY	Customer-Specific Collection Case ID	nvarchar	30	0
45	TFK052I	Customizing for Additional Collection Case Attributes	3	EXT_KEY	Customer-Specific Collection Case ID (Customizing)	nvarchar	1	0
TOPControlling
46	FCOMT_CR_OBJECT	Change Request: Objects	5	EXT_KEY	External Key	nvarchar	30	0
TOPDocument Management Framework
47	KDS_NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
48	KDS_NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
49	KDS_NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPDocument Management Services
50	SDOKNODE	SDOK: Node table for general structure repository	4	EXT_KEY	External key	nvarchar	12	0
51	SDOKNODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
52	SDOKNODET	SDOK: Name of Nodes for General Structure Repository	6	EXT_KEY	External key	nvarchar	12	0
TOPeCATT Extended Computer Aided Test Tool
53	ECBR_NODE	SHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes	4	EXT_KEY	External key	nvarchar	12	0
54	ECBR_NODER	SHI3 ECBR/ECBO - Node References	2	EXT_KEY	External key	nvarchar	12	0
55	ECBR_NODET	SHI3 ECBR/ECBO - Names of Nodes for eCATT Browser	6	EXT_KEY	External key	nvarchar	12	0
TOPEmployee Interaction Center
56	THREIC_PER_ALRTS	EIC: Personal Alerts	5	EXT_KEY	Case ID	nvarchar	12	0
TOPHierarchy Storage
57	TARCH01	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
58	TARCH01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
59	TARCH01T	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
60	TNODE01	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
61	TNODE01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
62	TNODE01T	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
63	TTREE	Definition table for structures	3	EXT_KEY	External key	nvarchar	12	0
64	TTREV	Versions: Header Data	4	EXT_KEY	External key	nvarchar	12	0
65	TTREVBRAEX	Versions: Copy of TTREEBRAEX	5	EXT_KEY	External key	nvarchar	12	0
66	TTREVBRAIN	Versions: Copy of TTREEBRAIN	5	EXT_KEY	External key	nvarchar	12	0
67	TTREVCOUEX	Versions: Copy of TTREECOUEX	5	EXT_KEY	External key	nvarchar	12	0
68	TTREVCOUIN	Versions: Copy of TTREECOUIN	5	EXT_KEY	External key	nvarchar	12	0
69	TTREVROAEX	Versions: Copy of TTREEROAEX	5	EXT_KEY	External key	nvarchar	12	0
70	TTREVROAIN	Versions: Copy of TTREEROAIN	5	EXT_KEY	External key	nvarchar	12	0
71	TTREVROLEX	Versions: Copy of TTREEROLEX	5	EXT_KEY	External key	nvarchar	12	0
72	TTREVROLIN	Versions: Copy of TTREEROLIN	5	EXT_KEY	External key	nvarchar	12	0
73	TTREVSUBEX	Versions: Copy of TTREESUBEX	5	EXT_KEY	External key	nvarchar	12	0
74	TTREVSUBIN	Versions: Copy of TTREESUBIN	5	EXT_KEY	External key	nvarchar	12	0
TOPImplementation Guide
75	TDOKUIMG	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
76	TDOKUIMGR	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
77	TDOKUIMGT	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
78	TNODEIMG	Node table for the new IMG	4	EXT_KEY	External key	nvarchar	12	0
79	TNODEIMGR	References for the new IMG	2	EXT_KEY	External key	nvarchar	12	0
80	TNODEIMGT	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
81	TNODEPR	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
82	TNODEPRR	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
83	TNODEPRT	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
84	TNODERELN	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
85	TNODERELNR	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
86	TNODERELNT	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPInterface to External Project Software
87	PSGUID	GUIDs for Project Definition	5	EXT_KEY	External Key for PS Object	nvarchar	40	0
TOPKnowledge Warehouse
88	CUSTNODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
89	CUSTNODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
90	CUSTNODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
91	IWB0NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
92	IWB0NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
93	IWB0NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
94	IWB1NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
95	IWB1NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
96	IWB1NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
97	IWB2NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
98	IWB2NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
99	IWB2NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
100	IWB7NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
101	IWB7NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
102	IWB7NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
103	KWN_NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
104	KWN_NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
105	KWN_NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
106	TXML_NODE	XML: table of nodes	4	EXT_KEY	External key	nvarchar	12	0
107	TXML_NODER	XML: General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
108	TXML_NODET	XML: General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPPerformance Assessment Workbench
109	KWPWNODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
110	KWPWNODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
111	KWPWNODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPPortfolio
112	VDARL_PAYM_PLAN	References from Premium Plans to Relevant Objects	5	EXT_KEY	External Key for Objects for a Premium Plan	nvarchar	32	0
TOPProfitability Analysis
113	TKENODE01	CO-PA: Node Table for General Structure Repository	4	EXT_KEY	External key	nvarchar	12	0
114	TKENODE01A	CO-PA: Attributes for Node Table TKENODE01	4	EXT_KEY	External key	nvarchar	12	0
115	TKENODE01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
116	TKENODE01T	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPSAPscript
117	TFORM01	Node Table for SAPscript Form Tree	4	EXT_KEY	External key	nvarchar	12	0
118	TFORM01R	SAPscript Form Tree: References	2	EXT_KEY	External key	nvarchar	12	0
119	TFORM01T	SAPscript Form Tree: Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPService
120	DVS1NODE	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
121	DVS1NODER	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
122	DVS1NODET	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPSession Manager
123	BMENTTREE	Definition Table for Structures	3	EXT_KEY	External key	nvarchar	12	0
124	TMENU01	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
125	TMENU01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
126	TMENU01T	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
127	TMENUBK01	Node Table for General Structure Storage	4	EXT_KEY	External key	nvarchar	12	0
128	TMENUBK01R	General Structure Storage References	2	EXT_KEY	External key	nvarchar	12	0
129	TMENUBK01T	General Structure Storage Node Names	6	EXT_KEY	External key	nvarchar	12	0
TOPTest Organizer
130	TNODE02	Test Organizer, Node Table	4	EXT_KEY	External key	nvarchar	12	0
131	TNODE02A	Test Organizer, Test Catalog, Plan, Package Attributes	3	EXT_KEY	External key	nvarchar	12	0
132	TNODE02R	Test Organizer, References	2	EXT_KEY	External key	nvarchar	12	0
133	TNODE02T	Test Organizer, Texts	6	EXT_KEY	External key	nvarchar	12	0
TOPWorkbench Utilities
134	RLB_DB_TR	Reuse Library: Structure Repository: Nodes	4	EXT_KEY	External key	nvarchar	12	0
135	RLB_DB_TRR	Reuse Library: Structure Repository: References	2	EXT_KEY	External key	nvarchar	12	0
136	RLB_DB_TRT	Reuse Library: Structure Repository: Descriptions	6	EXT_KEY	External key	nvarchar	12	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

136 columns | ERP 6.0 | EXT_KEY