	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

115 columns | ERP 6.0 | TEXT3

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	DVKTX	R/2-R/3 Link: Delivery texts R2 -> R3	10	TEXT3	Text R/2-R/3 Link	nvarchar	72	0
2	PB0290	HR Master Record: Infotype 0290 - Identity card CIS	33	TEXT3	Additional Information	nvarchar	50	0
3	PYC_D_PY_MSG	PYC: payroll message	44	TEXT3	Text Element for Structure PLOG_TEXT	nvarchar	132	0
4	PYC_D_PY_MSG_JOB	PYC: payroll message	27	TEXT3	Text Element for Structure PLOG_TEXT	nvarchar	132	0
5	ZML_MAILSETTING	Mail settings for OTM	10	TEXT3	Text	nvarchar	255	0
TOPBasic Functions
6	EIKP	Foreign Trade: Export/Import Header Data	45	TEXT3	Comments: Text for foreign trade processing	nvarchar	40	0
7	EIPO	Foreign Trade: Export/Import: Item Data	22	TEXT3	Comments: Text for foreign trade processing	nvarchar	40	0
8	MAZO	Foreign Trade: Customs Law Description	8	TEXT3	Description for customs description	nvarchar	70	0
9	T604D	Preference: Description of Preference Procedure Code	8	TEXT3	Text, 40 Characters Long	nvarchar	40	0
10	T604N	Import Processing: Control Code Description	7	TEXT3	Description of rule	nvarchar	60	0
11	T604O	Foreign Trade: Sections With Regard to Customs Law - Descr.	7	TEXT3	Text, 40 Characters Long	nvarchar	40	0
12	T604T	Foreign Trade: Commodity Code/Import Code No. Description	7	TEXT3	Text, 40 Characters Long	nvarchar	40	0
13	T604Z	Foreign Trade: Chapter - Descriptions	8	TEXT3	Text, 40 Characters Long	nvarchar	40	0
14	T605T	Foreign Trade: Business Transaction Type - Descriptions	7	TEXT3	Text Field of Length 60	nvarchar	60	0
15	T609GP	Foreign Trade: PRODCOM/GP Number (Prod.Stat.) - Descriptions	7	TEXT3	Description of rule	nvarchar	60	0
16	T610CT	Import Processing: CAS No. for Pharmaceut.Products - Descr.	7	TEXT3	Description of rule	nvarchar	60	0
17	T615T	Foreign Trade: Customs Offices - Descriptions	7	TEXT3	Text Field of Length 60	nvarchar	60	0
18	T616T	Foreign Trade: Procedures - Descriptions	7	TEXT3	Text Field of Length 60	nvarchar	60	0
19	T618MT	EU Market: EU Market Products List No. - Descriptions	7	TEXT3	Description of rule	nvarchar	60	0
TOPCentral Part of Product Master
20	CRMC_TAX_TCODE_T	Description for Assignment of Tax Scale Code to a Country	7	TEXT3	Description of Tax Scale Code	nvarchar	60	0
TOPClinical System
21	N2MV_DISREQ	Dispatch Request Data Table	40	TEXT3	Free Text 3	nvarchar	72	0
22	N2MV_VSDAT	Recipient Data Table	39	TEXT3	Free Text 3	nvarchar	72	0
TOPDenmark
23	PA0073	HR Master Record: Infotype 0073 (Private Pensions - DK)	46	TEXT3	Supplementary pension text 3	nvarchar	20	0
TOPFinancial Accounting
24	T007F	Taxes on Sales/Purchases Groups	10	TEXT3	Text Name	nvarchar	32	0
TOPForeign Trade
25	/SAPSLL/T604R3	GTS: Worklist: Retransfer of Commodity Code	10	TEXT3	Text, 40 Characters Long	nvarchar	40	0
26	/SAPSLL/T606GTR3	GTS: Legal Services: Legal Regulations - Name	6	TEXT3	Description of Length 60 for GTS	nvarchar	60	0
TOPFunds Management
27	FMCIT	Commitment items texts	9	TEXT3	Description 3	nvarchar	50	0
28	FMDECKRGT	Cover Pool Texts	9	TEXT3	Description 3	nvarchar	50	0
29	FMHVMTXTT	Budget Memo Texts, language dependent	8	TEXT3	Description 3	nvarchar	50	0
30	FMPPT	Commitment Item in Chart of Commitment Items: Texts	9	TEXT3	Description 3	nvarchar	50	0
TOPGlobal Trade Services
31	/SAPSLL/CCGRT	Legal Control: Control Groupings for Products - Relation.	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
32	/SAPSLL/CCSHT	Legal Control: Peculiarity Code for Products - Text	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
33	/SAPSLL/CTYGPT	Legal Services: Country Group - Text	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
34	/SAPSLL/CUCAART	SLL: Toll Types - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
35	/SAPSLL/CUCAFAT	GTS: Description of Requested Concession	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
36	/SAPSLL/CUCAGGT	GTS: Tax Assessment Duty Group - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
37	/SAPSLL/CUCAPRT	SLL: Additional Procedures - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
38	/SAPSLL/CUCBMST	GTS: Tax Assessment Measure - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
39	/SAPSLL/CUCDADT	Definition of Customs Duty Types: Text Table	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
40	/SAPSLL/CUCINDT	GTS: Customs Processing Indicator	8	TEXT3	Text 60 Characters Long	nvarchar	60	0
41	/SAPSLL/CUCMTRT	SLL: Description of Type of Transport	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
42	/SAPSLL/CUCNGAT	SLL: Range of Goods - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
43	/SAPSLL/CUCPATT	SLL: Description of Preliminary Docmt Types	8	TEXT3	Text 60 Characters Long	nvarchar	60	0
44	/SAPSLL/CUCPROT	GTS: Place into a Customs Status - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
45	/SAPSLL/CUCPSTT	Status of a Document - Name	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
46	/SAPSLL/CUCZAFT	GTS: Payment Demand for Tax Assessment - Description	8	TEXT3	Text 60 Characters Long	nvarchar	60	0
47	/SAPSLL/LCPROT	Project Master - Text Table	11	TEXT3	Text 60 Characters Long	nvarchar	60	0
48	/SAPSLL/LC_CUSB1	GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.	27	TEXT3	Text 60 Characters Long	nvarchar	60	0
49	/SAPSLL/LC_CUSB2	GTS Customs Management: Toll Category: Preferred Customs	28	TEXT3	Text 60 Characters Long	nvarchar	60	0
50	/SAPSLL/LC_CUSMN	GTS: Customs Processing: Measures Relating to Duty Rate	23	TEXT3	Text 60 Characters Long	nvarchar	60	0
51	/SAPSLL/PRECONDT	GTS: preference: additional cond's (upload data provider -B)	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
52	/SAPSLL/PSVCONDT	GTS: Preference: Additional Conditions (Manual Entry)	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
53	/SAPSLL/T606DLT	Legal Control: Text for Procedure for Determining Lic. Types	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
54	/SAPSLL/T606DRT	Legal Control: Text for Procedure for Determining Leg. Regs	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
55	/SAPSLL/T606GT	Legal Services: Texts for Legal Regulations	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
56	/SAPSLL/T606ST	Leg. Control: Text for Status of License of Legal Regulation	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
57	/SAPSLL/T606T	SLL: Legal Control: License Type - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
58	/SAPSLL/T608GT	Sanctioned Party List: Group of List - Name	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
59	/SAPSLL/T608IT	Sanctioned Party List: Type of Identification - Name	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
60	/SAPSLL/T608LT	Legal Control - SPL - Type of List - Reference	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
61	/SAPSLL/T608RT	Legal Control: SPL - Type of Reference - Text	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
62	/SAPSLL/TBO00T	GTS: Description for BOP Category	7	TEXT3	Text Field of Length 60	nvarchar	60	0
63	/SAPSLL/TBO01T	GTS: Bill of Product - Item Category - Description	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
64	/SAPSLL/TCOCMPT	Text for Rule Set for Comparing Addresses/Strings	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
65	/SAPSLL/TCOGVST	Text for Feeder System Grouping	5	TEXT3	Text 60 Characters Long	nvarchar	60	0
66	/SAPSLL/TCOPST	Partner Group Relevant for Letter of Credit - Description	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
67	/SAPSLL/TCOTST	Basic Structure of Customs Tariff System - Text	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
68	/SAPSLL/TCSIDDOT	Identification Types - Names	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
69	/SAPSLL/TCSIDDT	Schema for Identification Types - Name	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
70	/SAPSLL/TCSSCHOT	Options for Release Reason - Name	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
71	/SAPSLL/TCSSCHT	Determination Procedure for Release Reason - Name	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
72	/SAPSLL/TFCTRT	Aggregation Schema - Description	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
73	/SAPSLL/TLAGRT	GTS: Aggregation Rules for Customs Doc. - Description	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
74	/SAPSLL/TLEBTST	Rule Set for Customs Business Transaction Types - Text	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
75	/SAPSLL/TLECHT	Legal Services: Text for Document Type of Customs Document	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
76	/SAPSLL/TLECIT	Legal Services: Customs Document- Item Category Text	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
77	/SAPSLL/TLECPT	GTS: Supplementary Declaration: Document Type - Description	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
78	/SAPSLL/TLEDPGT	Legal Services: Depreciation Group Texts	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
79	/SAPSLL/TLEMOT	GTS: Definition of Model for BOM Cost Estimate - Description	6	TEXT3	Text 60 Characters Long	nvarchar	60	0
80	/SAPSLL/TRS01T	GTS: Restitution: CAP Recoding - Reference Type	7	TEXT3	Text 60 Characters Long	nvarchar	60	0
TOPGRC Access Control Plug-In
81	/VIRSA/CRAUTHC1T	Restricted Critical Authorizations Text	8	TEXT3	Description	nvarchar	120	0
82	/VIRSA/ZCRAUTHC1	Restricted Critical Authorizations	15	TEXT3	Description	nvarchar	120	0
TOPI18N Unicode
83	UM4MAINLOG	SPUMG: Main Log table	8	TEXT3		nvarchar	40	0
84	UMGMAINLOG	SPUMG: Main Log table	8	TEXT3	SPUMG: Parameter for main log messages	nvarchar	40	0
85	UMG_TEST_13	Unicode conversion testtable	3	TEXT3		nvarchar	10	0
TOPImplementation Guide
86	TIMG1	Status Fields for Customizing Transaction	12	TEXT3	Text (20 Characters)	nvarchar	20	0
TOPInternationalization I18N
87	CFONT_MAINLOG	I18N:Cascading font, log table	8	TEXT3		nvarchar	40	0
TOPLocalization
88	J_3RFF4DATA	Cash flow statement customizing	10	TEXT3	Item Description	nvarchar	45	0
89	J_3RFF4DATAT	Cash flow statement row texts	8	TEXT3	Item Description	nvarchar	45	0
TOPMaterial Groups
90	WTREE	Version Management for Reclassification Trees	38	TEXT3	Text/Icon/Symbol	nvarchar	75	0
TOPMaterial Master
91	MGVSPECTYPETEXTS	Text for specialization types	7	TEXT3	Header table material master specialization	nvarchar	80	0
TOPNetWeaver Enterprise Search
92	ESH_TST_EH_RTT	Text table of ESH_TST_EH_RTI	6	TEXT3	Character field, length 64	nvarchar	64	0
TOPOLAP Technology
93	RSR_CACHE_LOG	OLAP Cache Table for Saving Log Entries	13	TEXT3	Character Field of Length 40	nvarchar	40	0
TOPPayroll
94	T5TPSCHODN	Tabulka hodností	10	TEXT3	Textové pole o délce 60 znaku	nvarchar	60	0
TOPPeriodical Sales and Distribution
95	JKAKPR	Ad Pre-Print Order: Header Data	27	TEXT3	Text (80 Characters)	nvarchar	80	0
96	JVTFAHRM	IS-M: Driver Notification (Shipping Documents)	6	TEXT3	Text (80 Characters)	nvarchar	80	0
97	JVTZUSTM	IS-M/SD: Carrier Notification (Shipping Documents)	10	TEXT3	Text (80 Characters)	nvarchar	80	0
TOPPersonnel Administration
98	T7PL08	Conversion table for leave codes	7	TEXT3	Text field - 60 characters	nvarchar	60	0
99	T7PLT0	Conversion table for leave codes fot tempolary workers	7	TEXT3	Text field - 60 characters	nvarchar	60	0
TOPReal Estate Management
100	VZWDVL	Buffer for sends within Financial Assets Management	19	TEXT3	Text (20 Characters)	nvarchar	20	0
TOPRemaining Beverage - Obsolete Objects
101	/BEV1/CLT998	Table for Border Crossing Points	5	TEXT3	Table text	nvarchar	60	0
102	/BEV3/CHCDPCUST	CDP: Contract Data Customer	22	TEXT3	CH: Free Text 30 Characters	nvarchar	30	0
103	/BEV3/CHWDCMMNT	Internal memos / comments on CHD	9	TEXT3	Check: Character Field length = 80, Upper and Lower Case	nvarchar	80	0
TOPRisk Analysis
104	JBRNODETXT	All Information for Display of Hierarchies	34	TEXT3	Text/Icon/Symbol	nvarchar	75	0
TOPRussia
105	PA0290	HR Master Record: Infotype 0290 - Identity card CIS	33	TEXT3	Additional Information	nvarchar	50	0
TOPTransportation
106	VTTK	Shipment Header	94	TEXT3	Addit.text 3	nvarchar	40	0
TOPWarehouse Management
107	LL01	Whse Activity Monitor: Critical Transfer Order Items	17	TEXT3	Processing note for a critical activity	nvarchar	40	0
108	LL02	Whse Activity Monitor: Critical Transfer Requirement Items	18	TEXT3	Processing note for a critical activity	nvarchar	40	0
109	LL03	Whse Activity Monitor: Critical Posting Change Documents	14	TEXT3	Processing note for a critical activity	nvarchar	40	0
110	LL04	Whse Activity Monitor: Critical Deliveries	14	TEXT3	Processing note for a critical activity	nvarchar	40	0
111	LL05	Whse Activity Monitor: Critical Stocks	14	TEXT3	Processing note for a critical activity	nvarchar	40	0
112	LL06	Whse Activity Monitor: Critical Storage Bins	14	TEXT3	Processing note for a critical activity	nvarchar	40	0
113	LL07	Whse Activity Monitor: Critical Production Orders	14	TEXT3	Processing note for a critical activity	nvarchar	40	0
TOPWorkbench Tools Editors, Painters, Modelers
114	COVMVDAT	Table for Storing Coverage Results from Coverage Analyzer	31	TEXT3	For General Use of Names of Length < 30	nvarchar	30	0
115	COVMVHIS	Table for Storing the History from Coverage Analyzer	33	TEXT3	For General Use of Names of Length < 30	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

115 columns | ERP 6.0 | TEXT3