	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

108 columns | ERP 6.0 | LONGTEXT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	EHPRCC_IMSEGF	Import segment fields	11	LONGTEXT	Long Text	nvarchar	1	0
2	MDGHDB_LONGTEXT	Table for Storing Long texts	10	LONGTEXT	Long Text	ntext	1073741823	0
3	MSPT_OIGSI	Shipment Item to store deleted records	17	LONGTEXT	TD Longtext indicator	nvarchar	1	0
4	ZCATSDB	Records changed with processing status '10'	100	LONGTEXT		nvarchar	1	0
5	ZCATSDB2	Records changed with processing status '10'	101	LONGTEXT		nvarchar	1	0
TOPASAP Tools and Contents
6	SMAPBP0T	Solution Map: Best Practice (Text)	5	LONGTEXT	Name	nvarchar	100	0
7	SMAPCOMP0T	Solution Map: Component (Text)	5	LONGTEXT	Name	nvarchar	100	0
8	SMAPPA0T	Solution Map: Partner product (text)	5	LONGTEXT	Name	nvarchar	100	0
9	SMAPPD0T	Solution Map: Product information (text)	5	LONGTEXT	Name	nvarchar	100	0
10	SMAPPI0T	Solution Map: Performance Indicator (Text)	5	LONGTEXT	Name	nvarchar	100	0
11	SMAPPR0T	Solution Map: Process category, main process, process (txt)	5	LONGTEXT	Name	nvarchar	100	0
TOPBasic Market Data
12	/BA1/TF4_CACATGT	Texts for Corporate Action Categories	3	LONGTEXT	Long Text	nvarchar	60	0
13	/BA1/TF4_CA_MDLT	Texts for Corporate Action Models	3	LONGTEXT	Long Text	nvarchar	60	0
14	/BA1/TF4_MATSTRT	Text Table for Maturity Structures	4	LONGTEXT	Text Field of Length 60	nvarchar	60	0
15	/BA1/TF4_SCENDCT	Data Categories Scenario	3	LONGTEXT	Long Text	nvarchar	60	0
16	/BA1/TF4_VCALCMT	Calculation Methods for Volatilities	3	LONGTEXT	Long Text	nvarchar	60	0
17	/BA1/TF4_YCMDLT	Text Table for External Model for Yield Curve	3	LONGTEXT	Long Text	nvarchar	60	0
TOPControlling
18	QISRSCENARIO	Basic Scenario Data	5	LONGTEXT	Long Text Exists	nvarchar	1	0
TOPCross-Application Components
19	/IXOS/DC_PVL_WD	Customizing Table for Web Dynpro project overview view list	6	LONGTEXT	Additional description for a web dynpro view	nvarchar	255	0
20	/IXOS/DC_WD_PVL	Customizing Table for Web Dynpro project overview view list	6	LONGTEXT	Additional description for a web dynpro view	nvarchar	255	0
TOPEnvironment, Health and Safety
21	/TDAG/CPC_IMSEGF	Import segment fields	11	LONGTEXT	Long Text	nvarchar	1	0
TOPESS Based on WD ABAP
22	HRESS_D_CATS_FAV	CATS Favorites: database table	107	LONGTEXT	Long Text	nvarchar	1	0
TOPFramework for the Principle of Dual Control
23	TBCA_OBJECT_CATT	Text Table of Object Categories	3	LONGTEXT	Release Object Description	nvarchar	35	0
24	TBCA_REL_ACTT	Text Tables for the Release Activities	4	LONGTEXT	Full description	nvarchar	35	0
25	TBCA_REL_PROCT	Text Tables for the Release Procedure	4	LONGTEXT	Required Release Steps	nvarchar	35	0
26	TBCA_REL_STATUST	Text Table for Release Object Status	5	LONGTEXT	Full description	nvarchar	35	0
TOPGlobal Performance Analysis Transaction ST3
27	AMSTANO	Global Performance Analysis: Other Statistics Data	6	LONGTEXT	N3 Workload: Description of Service Type	nvarchar	128	0
TOPMaster Data Framework
28	DML_TEXTTYPE	MDF Text Types	3	LONGTEXT	Long Text	nvarchar	1	0
TOPMedia Product Sales and Distribution
29	JKSDSQPEVENTT	Text Table for JKSDSQPEVENT	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
30	TJKSD131FILTERGT	Text Table for Media Issue Worklist Function Groups	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
31	TJKSD131T	Text Table for Media Issue Worklist Function Groups	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
32	TJKSDCALCMETHODT	Text Table for TJKSDCALCMETHOD	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
33	TJKSDCICORDRULET	Checking Rule for Orders in CIC - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
34	TJKSDCOLCUSTEXLT	Exclusion Method for Recall Groups - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
35	TJKSDCOLCUSTGRPT	Customer Recall Group Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
36	TJKSDCOMPLTYPE1T	CIC: Complaint Types for Delivery - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
37	TJKSDCOMPLTYPE2T	CIC: Complaint Types for Returns - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
38	TJKSDCORESTRUCTT	Description - Display Structure for Sales Quantity Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
39	TJKSDCQPREASONT	Text Table for Constant Service Reasons	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
40	TJKSDCQPSERVTEXT	IS-M: Constant Service Types, Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
41	TJKSDCQPSUPPLYT	Delivery Status of Constant Service - Text	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
42	TJKSDCRCQPTOSQPT	IS-M: Copy Rules Constant Service to Quantity Plan	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
43	TJKSDCRSQPTOCQPT	IS-M: Copy Rules Quantity Plan to Constant Service	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
44	TJKSDEVENTRULET	Text Table for Transfer Rule in Event Processing	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
45	TJKSDFCADDFUNCT	Texts for Additional Functions for Reference Issue Selection	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
46	TJKSDFCAREAT	Name - Planning Group in Reference Issue Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
47	TJKSDFCCOPYRULET	Text Table for TJKSDFCCOPYRULE	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
48	TJKSDFCSECMETHT	Texts - Calculation Methods for Safety Stock	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
49	TJKSDFCSEGMENTT	Text Table for Segments in a Planning Area	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
50	TJKSDFCSEGMETHDT	Method Definition for Segmentation (Forecast)	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
51	TJKSDFCSEGVART	Text Table for TJKSDFCSEGVAR	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
52	TJKSDFIHIERT	Filter Hierarchy Definition for Quantity Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
53	TJKSDFILTERT	Text - Filter for Quantity Planning View	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
54	TJKSDHIERSTRUCT	Text Table for Hierarchy Levels	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
55	TJKSDISSUEMETHT	Text Table for TJKSDISSUEMETHOD	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
56	TJKSDMMSTATGRPT	Text - Cross-Plant Material Status Group	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
57	TJKSDPLANORGDTRT	Text for Det. Group for Planning Org. for Qty Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
58	TJKSDPLANORGT	Planning Organization for Quantity Planning - Texts	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
59	TJKSDPQPCALC1T	Times for Planning Process in Sales Planning - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
60	TJKSDPQPCALC2T	Grouping of Calculation Methods in Purchase Planning - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
61	TJKSDRECHKGRPT	Return Customer Group Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
62	TJKSDRECHKPROCHT	Check Procedure Return Text Table Header Data	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
63	TJKSDRECHKPROCT	Return Check Procedure Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
64	TJKSDRECHKRULEHT	Return Checking Rule Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
65	TJKSDRECHKRULET	Return Checking Rule Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
66	TJKSDREISCHKGRPT	Return Issue Group Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
67	TJKSDRETLOGHANDT	Return Delivery	4	LONGTEXT	IS-M: Long Text	nvarchar	50	0
68	TJKSDRETSORTINGT	Sort Indicators for Return Delivery	4	LONGTEXT	IS-M: Long Text	nvarchar	50	0
69	TJKSDSBRGRPCONTT	Text for Replen. Planning Grouping for Contract Items	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
70	TJKSDSBRGRPISSUT	Text for Replen. Planning Grouping for Media Issues	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
71	TJKSDSBRRULECALT	Calc. Rule for Replenishment Planning Quantities - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
72	TJKSDSBRRULEDATT	Calculation Rule for Replenishment Planning Date - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
73	TJKSDSBRTIMESTRT	IS-M: Period Patterns for Replenishment Planning - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
74	TJKSDSFDETRULET	Stock Interpretation Rule - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
75	TJKSDSFSTTYPET	Stock Type for Stock Determination - Text Table	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
76	TJKSDSQPCALC1T	Times for Planning Process in Sales Planning - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
77	TJKSDSQPCALC2T	Grouping of Calculation Methods for Sales Planning - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
78	TJKSDSTFRWORKT	Text Table for Goods Transfer Procedure	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
79	TJKSDSTOCKTYPET	Text Table for Stock Types	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
80	TJKSDSTRUCTURET	Text - Structure for Quantity Planning View	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
81	TJKSDSUBSTRUCTT	Text - Substructure in Sales Quantity Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
82	TJKSDSUBSTRUPQPT	Text - Substructure for Purchase Quantity Planning	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
83	TJKSDUPDATERULET	Text - Update Rules for Quantity Planning View	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
84	TJKSDUPDMETHODT	Text - Calculation Method in Quantity Planning	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
85	TJKSDUSRGRPT	Text - User Group for Quantity Planning View	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
86	TJKSDVERIFYRULET	Rule for Calculating Corrected Sales Figures - Texts	5	LONGTEXT	IS-M: Long Text	nvarchar	50	0
87	TJKSDVIEWFUNCT	Text - Calculation Method for Quantity Planning View	6	LONGTEXT	IS-M: Long Text	nvarchar	40	0
88	TJKSDVIEWLOADERT	Texts for Determining Historical Sales Figures	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
89	TJKSDVIEWLOADT	Texts for Determining Historical Sales Figures	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
90	TJKSDVIEWMETHODT	Text - Distribution Method for Planning View	5	LONGTEXT	IS-M: Long Text	nvarchar	40	0
91	TJKSDVIEWT	Text for Quantity Planning View	6	LONGTEXT	IS-M: Long Text	nvarchar	50	0
TOPMenu Painter
92	D301T	Texts for Program Functions and Menu Bars	9	LONGTEXT	GUI: Long text (CUA text until 3.1)	nvarchar	20	0
TOPMonitoring
93	SWLN3CMPIF	Non-R/3 Statistic: Action Type and Service Type Information	5	LONGTEXT	DSR Statistics: Long Text for Action/Service Type	nvarchar	128	0
94	SWLN3CMPIT	Non-R/3 Statistic: Action Type and Service Type Information	6	LONGTEXT	DSR Statistics: Long Text for Action/Service Type	nvarchar	128	0
TOPPost Processing Framework
95	PPFTTTCUT	PPF: Action Definition in Customizing	5	LONGTEXT	Name	nvarchar	70	0
TOPSAP Business Workflow
96	SWDSHEADER	WF Definition: Basic Data	13	LONGTEXT	Workflow definition: Long text ID	nvarchar	1	0
97	SWD_HEADER	WF Definition/Runtime: Basic Data	14	LONGTEXT	Workflow definition: Long text ID	nvarchar	1	0
TOPTerminologyGlossary
98	STERM_LINK	Link Between Concept and Associated Terms	16	LONGTEXT	General Flag	nvarchar	1	0
99	STERM_Q_CHECK	Table for Terminology Check	35	LONGTEXT	General Flag	nvarchar	1	0
TOPTime Sheet
100	CATSDB	CATS: Database Table for Time Sheet	100	LONGTEXT	Long Text	nvarchar	1	0
TOPTraders and Schedulers Workbench
101	OIJEC	TD-Transport Unit Master Data Events	34	LONGTEXT	TD - event long text indicator	nvarchar	1	0
102	OIJEV	TD-Vehicle ~ Berth Master Data Events	37	LONGTEXT	TD - event long text indicator	nvarchar	1	0
103	OIJSUBITEMEVENTS	Nomination Sub Item Events	34	LONGTEXT	TD - event long text indicator	nvarchar	1	0
TOPTransportation and Distribution
104	OIGSI	Shipment Item	17	LONGTEXT	TD Longtext indicator	nvarchar	1	0
TOPWeb Application Builder
105	W3BHTMFUNC	WAB: Business HTML Functions	3	LONGTEXT	Long docu for Business HTML Element	nvarchar	30	0
106	W3BHTMPARA	WAB: Business HTML Parameters	5	LONGTEXT	Long docu for Business HTML Element	nvarchar	30	0
107	W3BHTMVALU	WAB: Values for Business HTML Parameters	8	LONGTEXT	Long docu for Business HTML Element	nvarchar	30	0
108	W3BHTMWIZZ	WAB: Business HTML Wizards	3	LONGTEXT	Long docu for Business HTML Element	nvarchar	30	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

108 columns | ERP 6.0 | LONGTEXT