	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

147 columns | ERP 6.0 | TEXT2

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	DVKTX	R/2-R/3 Link: Delivery texts R2 -> R3	9	TEXT2	Text R/2-R/3 Link	nvarchar	72	0
2	PB0290	HR Master Record: Infotype 0290 - Identity card CIS	32	TEXT2	Additional Information	nvarchar	50	0
3	PYC_D_PY_MSG	PYC: payroll message	41	TEXT2	Text Element for Structure PLOG_TEXT	nvarchar	132	0
4	PYC_D_PY_MSG_JOB	PYC: payroll message	24	TEXT2	Text Element for Structure PLOG_TEXT	nvarchar	132	0
5	T527O	Organizational Key Validation	6	TEXT2	Name of organizational element	nvarchar	40	0
6	T5UPBS01ACTIONT	Text table for tree fields	6	TEXT2	Nature of Action Long Text	nvarchar	80	0
7	ZML_MAILSETTING	Mail settings for OTM	9	TEXT2	Text	nvarchar	255	0
TOPArchiveLink
8	TOAER	SAP ArchiveLink: Storage system related error texts	5	TEXT2	Char 80	nvarchar	80	0
TOPBasic Functions
9	EIKP	Foreign Trade: Export/Import Header Data	44	TEXT2	Comments: Text for foreign trade processing	nvarchar	40	0
10	EIPO	Foreign Trade: Export/Import: Item Data	21	TEXT2	Comments: Text for foreign trade processing	nvarchar	40	0
11	MAZO	Foreign Trade: Customs Law Description	7	TEXT2	Description for customs description	nvarchar	70	0
12	T604D	Preference: Description of Preference Procedure Code	7	TEXT2	Text, 40 Characters Long	nvarchar	40	0
13	T604N	Import Processing: Control Code Description	6	TEXT2	Description of rule	nvarchar	60	0
14	T604O	Foreign Trade: Sections With Regard to Customs Law - Descr.	6	TEXT2	Text, 40 Characters Long	nvarchar	40	0
15	T604T	Foreign Trade: Commodity Code/Import Code No. Description	6	TEXT2	Text, 40 Characters Long	nvarchar	40	0
16	T604Z	Foreign Trade: Chapter - Descriptions	7	TEXT2	Text, 40 Characters Long	nvarchar	40	0
17	T605T	Foreign Trade: Business Transaction Type - Descriptions	6	TEXT2	Text Field of Length 60	nvarchar	60	0
18	T609GP	Foreign Trade: PRODCOM/GP Number (Prod.Stat.) - Descriptions	6	TEXT2	Description of rule	nvarchar	60	0
19	T610CT	Import Processing: CAS No. for Pharmaceut.Products - Descr.	6	TEXT2	Description of rule	nvarchar	60	0
20	T610NAT	Import Processing: Verification Document Descriptions	6	TEXT2	Description of rule	nvarchar	60	0
21	T610PAT	Foreign Trade: Preference Type - Description	6	TEXT2	Description of rule	nvarchar	60	0
22	T610VAT	Foreign Trade: Preliminary Imp. Docs/Exp.Docs - Descriptions	6	TEXT2	Description of rule	nvarchar	60	0
23	T615T	Foreign Trade: Customs Offices - Descriptions	6	TEXT2	Text Field of Length 60	nvarchar	60	0
24	T616T	Foreign Trade: Procedures - Descriptions	6	TEXT2	Text Field of Length 60	nvarchar	60	0
25	T618GT	EU Market: EU Market Products Group - Descriptions	6	TEXT2	Description	nvarchar	40	0
26	T618MT	EU Market: EU Market Products List No. - Descriptions	6	TEXT2	Description of rule	nvarchar	60	0
27	T618OT	EU Market: Market Organization Descriptions	6	TEXT2	Description	nvarchar	40	0
28	T618WT	EU Market: Market Organization Number - Descriptions	7	TEXT2	Description	nvarchar	40	0
29	T869T	Consolidation of investments methods	5	TEXT2	Description of the method variant for cons. of investments	nvarchar	20	0
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
30	TBE01T	P&S BTE: Language-Specific Descriptions	4	TEXT2	Text for Interfaces	nvarchar	50	0
31	TPS01T	Process BTE: Language-Specific Descriptions	4	TEXT2	Text for Interfaces	nvarchar	50	0
TOPCentral Part of Product Master
32	CRMC_TAX_TCODE_T	Description for Assignment of Tax Scale Code to a Country	6	TEXT2	Description of Tax Scale Code	nvarchar	60	0
TOPClinical System
33	N2MV_DISREQ	Dispatch Request Data Table	39	TEXT2	Free Text 2 (Greeting Form)	nvarchar	72	0
34	N2MV_VSDAT	Recipient Data Table	38	TEXT2	Free Text 2 (Greeting Form)	nvarchar	72	0
TOPDenmark
35	PA0073	HR Master Record: Infotype 0073 (Private Pensions - DK)	44	TEXT2	Supplementary pension text 2	nvarchar	10	0
TOPDocumentation Tools
36	TUCHK3	Information on the CHECK Index	7	TEXT2	Text Field of Length 60	nvarchar	60	0
TOPFinancial Accounting
37	T007F	Taxes on Sales/Purchases Groups	9	TEXT2	Text Name	nvarchar	32	0
TOPForeign Trade
38	/SAPSLL/T604R3	GTS: Worklist: Retransfer of Commodity Code	9	TEXT2	Text, 40 Characters Long	nvarchar	40	0
39	/SAPSLL/T606GTR3	GTS: Legal Services: Legal Regulations - Name	5	TEXT2	Description of Length 60 for GTS	nvarchar	60	0
TOPFunds Management
40	FMCIT	Commitment items texts	8	TEXT2	Description 2	nvarchar	50	0
41	FMDECKRGT	Cover Pool Texts	8	TEXT2	Description 2	nvarchar	50	0
42	FMHVMTXTT	Budget Memo Texts, language dependent	7	TEXT2	Description 2	nvarchar	50	0
43	FMPPT	Commitment Item in Chart of Commitment Items: Texts	8	TEXT2	Description 2	nvarchar	50	0
TOPGL Account Posting
44	TCJ_DOCUMENTS	Cash Journal Documents (Header Data)	22	TEXT2	Additional Field 2 for Cash Journal Document Header	nvarchar	30	0
TOPGlobal Trade Services
45	/SAPSLL/CCGRT	Legal Control: Control Groupings for Products - Relation.	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
46	/SAPSLL/CCSHT	Legal Control: Peculiarity Code for Products - Text	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
47	/SAPSLL/CTYGPT	Legal Services: Country Group - Text	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
48	/SAPSLL/CUCAART	SLL: Toll Types - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
49	/SAPSLL/CUCAFAT	GTS: Description of Requested Concession	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
50	/SAPSLL/CUCAGGT	GTS: Tax Assessment Duty Group - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
51	/SAPSLL/CUCAPRT	SLL: Additional Procedures - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
52	/SAPSLL/CUCBMST	GTS: Tax Assessment Measure - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
53	/SAPSLL/CUCDADT	Definition of Customs Duty Types: Text Table	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
54	/SAPSLL/CUCINDT	GTS: Customs Processing Indicator	7	TEXT2	Text 60 Characters Long	nvarchar	60	0
55	/SAPSLL/CUCMTRT	SLL: Description of Type of Transport	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
56	/SAPSLL/CUCNGAT	SLL: Range of Goods - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
57	/SAPSLL/CUCPATT	SLL: Description of Preliminary Docmt Types	7	TEXT2	Text 60 Characters Long	nvarchar	60	0
58	/SAPSLL/CUCPROT	GTS: Place into a Customs Status - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
59	/SAPSLL/CUCPSTT	Status of a Document - Name	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
60	/SAPSLL/CUCZAFT	GTS: Payment Demand for Tax Assessment - Description	7	TEXT2	Text 60 Characters Long	nvarchar	60	0
61	/SAPSLL/LCPROT	Project Master - Text Table	10	TEXT2	Text 60 Characters Long	nvarchar	60	0
62	/SAPSLL/LC_CUSB1	GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.	26	TEXT2	Text 60 Characters Long	nvarchar	60	0
63	/SAPSLL/LC_CUSB2	GTS Customs Management: Toll Category: Preferred Customs	27	TEXT2	Text 60 Characters Long	nvarchar	60	0
64	/SAPSLL/LC_CUSMN	GTS: Customs Processing: Measures Relating to Duty Rate	22	TEXT2	Text 60 Characters Long	nvarchar	60	0
65	/SAPSLL/LEGSSTT	SLL: Statistics Status - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
66	/SAPSLL/PRECONDT	GTS: preference: additional cond's (upload data provider -B)	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
67	/SAPSLL/PSVCONDT	GTS: Preference: Additional Conditions (Manual Entry)	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
68	/SAPSLL/T606DLT	Legal Control: Text for Procedure for Determining Lic. Types	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
69	/SAPSLL/T606DRT	Legal Control: Text for Procedure for Determining Leg. Regs	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
70	/SAPSLL/T606GT	Legal Services: Texts for Legal Regulations	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
71	/SAPSLL/T606ST	Leg. Control: Text for Status of License of Legal Regulation	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
72	/SAPSLL/T606T	SLL: Legal Control: License Type - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
73	/SAPSLL/T608GT	Sanctioned Party List: Group of List - Name	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
74	/SAPSLL/T608IT	Sanctioned Party List: Type of Identification - Name	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
75	/SAPSLL/T608LT	Legal Control - SPL - Type of List - Reference	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
76	/SAPSLL/T608RT	Legal Control: SPL - Type of Reference - Text	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
77	/SAPSLL/TBO00T	GTS: Description for BOP Category	6	TEXT2	Text Field of Length 60	nvarchar	60	0
78	/SAPSLL/TBO01T	GTS: Bill of Product - Item Category - Description	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
79	/SAPSLL/TCOCMPT	Text for Rule Set for Comparing Addresses/Strings	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
80	/SAPSLL/TCOGVST	Text for Feeder System Grouping	4	TEXT2	Text 60 Characters Long	nvarchar	60	0
81	/SAPSLL/TCOPST	Partner Group Relevant for Letter of Credit - Description	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
82	/SAPSLL/TCOTSIT	SLL: Unit of Measurement Systems - Name	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
83	/SAPSLL/TCOTST	Basic Structure of Customs Tariff System - Text	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
84	/SAPSLL/TCSIDDOT	Identification Types - Names	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
85	/SAPSLL/TCSIDDT	Schema for Identification Types - Name	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
86	/SAPSLL/TCSSCHOT	Options for Release Reason - Name	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
87	/SAPSLL/TCSSCHT	Determination Procedure for Release Reason - Name	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
88	/SAPSLL/TFCTRT	Aggregation Schema - Description	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
89	/SAPSLL/TLAGRT	GTS: Aggregation Rules for Customs Doc. - Description	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
90	/SAPSLL/TLEBTST	Rule Set for Customs Business Transaction Types - Text	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
91	/SAPSLL/TLECHT	Legal Services: Text for Document Type of Customs Document	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
92	/SAPSLL/TLECIT	Legal Services: Customs Document- Item Category Text	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
93	/SAPSLL/TLECPT	GTS: Supplementary Declaration: Document Type - Description	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
94	/SAPSLL/TLEDPGT	Legal Services: Depreciation Group Texts	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
95	/SAPSLL/TLEMOT	GTS: Definition of Model for BOM Cost Estimate - Description	5	TEXT2	Text 60 Characters Long	nvarchar	60	0
96	/SAPSLL/TRS01T	GTS: Restitution: CAP Recoding - Reference Type	6	TEXT2	Text 60 Characters Long	nvarchar	60	0
TOPGRC Access Control Plug-In
97	/VIRSA/CRAUTHC1T	Restricted Critical Authorizations Text	7	TEXT2	Description	nvarchar	120	0
98	/VIRSA/ZCRAUTHC1	Restricted Critical Authorizations	14	TEXT2	Description	nvarchar	120	0
TOPI18N Unicode
99	UM4MAINLOG	SPUMG: Main Log table	7	TEXT2		nvarchar	40	0
100	UMGMAINLOG	SPUMG: Main Log table	7	TEXT2	SPUMG: Parameter for main log messages	nvarchar	40	0
101	UMG_TEST_13	Unicode conversion testtable	2	TEXT2		nvarchar	10	0
TOPImplementation Guide
102	TIMG1	Status Fields for Customizing Transaction	11	TEXT2	Text (20 Characters)	nvarchar	20	0
TOPInternationalization I18N
103	CFONT_MAINLOG	I18N:Cascading font, log table	7	TEXT2		nvarchar	40	0
104	I18NSRHLOG	Main Log for the Report I18N_SEARCH and the Worker Jobs	6	TEXT2	General Text for I18N_SEARCH	nvarchar	40	0
TOPLocalization
105	J_3RFF4DATA	Cash flow statement customizing	9	TEXT2	Item Description	nvarchar	45	0
106	J_3RFF4DATAT	Cash flow statement row texts	7	TEXT2	Item Description	nvarchar	45	0
TOPMaterial Groups
107	WTREE	Version Management for Reclassification Trees	32	TEXT2	Text/Icon/Symbol	nvarchar	75	0
TOPMaterial Master
108	MGVSPECTYPETEXTS	Text for specialization types	5	TEXT2	Category of Material	nvarchar	20	0
TOPNetWeaver Enterprise Search
109	ESH_TST_EH_RTT	Text table of ESH_TST_EH_RTI	5	TEXT2	Character field, length 64	nvarchar	64	0
TOPOLAP Technology
110	RSR_CACHE_LOG	OLAP Cache Table for Saving Log Entries	12	TEXT2	Character Field of Length 40	nvarchar	40	0
TOPPatient Management
111	TNICPM	IS-H: ICPM structure - Delivery of ICPM catalog	6	TEXT2	IS-H: ICPM characters 41-80 of the ICPM text	nvarchar	40	0
TOPPayment Transactions
112	T042ZT	Texts of Payment Methods for Automatic Payment	5	TEXT2	Description of Payment Method in Logon Language	nvarchar	30	0
TOPPayroll
113	T5TPS0730	Doplnková data infotypu 0730	11	TEXT2	Text 30 míst	nvarchar	30	0
114	T5TPS0731	Doplnková data infotypu 0731	13	TEXT2	Text 30 míst	nvarchar	30	0
115	T5TPSCHODN	Tabulka hodností	9	TEXT2	Textové pole o délce 60 znaku	nvarchar	60	0
116	T5TPSCKK3	Kategorie dosaženého vzdelání podle KKOV	6	TEXT2	Text, 255 znaku	nvarchar	255	0
117	T5TPSTXT01	Formuláre infotypu 0729 - doplnku opatrení	15	TEXT2	Komentár	nvarchar	50	0
TOPPeriodical Sales and Distribution
118	JKAKPR	Ad Pre-Print Order: Header Data	26	TEXT2	Text (80 Characters)	nvarchar	80	0
119	JVTFAHRM	IS-M: Driver Notification (Shipping Documents)	5	TEXT2	Text (80 Characters)	nvarchar	80	0
120	JVTZUSTM	IS-M/SD: Carrier Notification (Shipping Documents)	9	TEXT2	Text (80 Characters)	nvarchar	80	0
TOPPersonnel Administration
121	T7PL08	Conversion table for leave codes	6	TEXT2	Text field - 60 characters	nvarchar	60	0
122	T7PLT0	Conversion table for leave codes fot tempolary workers	6	TEXT2	Text field - 60 characters	nvarchar	60	0
TOPReal Estate Management
123	VZWDVL	Buffer for sends within Financial Assets Management	18	TEXT2	Text (20 Characters)	nvarchar	20	0
TOPRemaining Beverage - Obsolete Objects
124	/BEV1/CLT998	Table for Border Crossing Points	4	TEXT2	Table text	nvarchar	60	0
125	/BEV3/CHCDPCUST	CDP: Contract Data Customer	21	TEXT2	CH: Free Text 30 Characters	nvarchar	30	0
126	/BEV3/CHWDCMMNT	Internal memos / comments on CHD	8	TEXT2	Check: Character Field length = 80, Upper and Lower Case	nvarchar	80	0
TOPRisk Analysis
127	JBRNODETXT	All Information for Display of Hierarchies	28	TEXT2	Text/Icon/Symbol	nvarchar	75	0
TOPRussia
128	PA0290	HR Master Record: Infotype 0290 - Identity card CIS	32	TEXT2	Additional Information	nvarchar	50	0
TOPSpain
129	T5EDH	Local tax offices/authorities	5	TEXT2	Text (20 Characters)	nvarchar	20	0
TOPTerminologyGlossary
130	STERM_DWN2	MultiTerm Download: Attribute Values	6	TEXT2		nvarchar	60	0
TOPTranslation Tools
131	MLTTSTTEM1	MLT Test Cases: Template for Small Table	5	TEXT2	Text, 40 Characters Long	nvarchar	40	0
132	MLTTSTTEM2	MLT Test Cases: Template for Medium-Size Tables	4	TEXT2	Text, 40 Characters Long	nvarchar	40	0
133	MLTTSTTEM3	MLT Test Cases: Template for Large Tables	4	TEXT2	Text, 40 Characters Long	nvarchar	40	0
134	MLTTSTWRK1	MLT Test Cases: Work Area for Small Table	5	TEXT2	Text, 40 Characters Long	nvarchar	40	0
135	MLTTSTWRK2	MLT Test Cases: Work Area for Medium-Size Table	4	TEXT2	Text, 40 Characters Long	nvarchar	40	0
136	MLTTSTWRK3	MLT Test Cases: Work Area for Large Table	4	TEXT2	Text, 40 Characters Long	nvarchar	40	0
TOPTransportation
137	VTTK	Shipment Header	93	TEXT2	Addit.text 2	nvarchar	40	0
TOPWarehouse Management
138	LL01	Whse Activity Monitor: Critical Transfer Order Items	16	TEXT2	Processing note for a critical activity	nvarchar	40	0
139	LL02	Whse Activity Monitor: Critical Transfer Requirement Items	17	TEXT2	Processing note for a critical activity	nvarchar	40	0
140	LL03	Whse Activity Monitor: Critical Posting Change Documents	13	TEXT2	Processing note for a critical activity	nvarchar	40	0
141	LL04	Whse Activity Monitor: Critical Deliveries	13	TEXT2	Processing note for a critical activity	nvarchar	40	0
142	LL05	Whse Activity Monitor: Critical Stocks	13	TEXT2	Processing note for a critical activity	nvarchar	40	0
143	LL06	Whse Activity Monitor: Critical Storage Bins	13	TEXT2	Processing note for a critical activity	nvarchar	40	0
144	LL07	Whse Activity Monitor: Critical Production Orders	13	TEXT2	Processing note for a critical activity	nvarchar	40	0
TOPWaste Management
145	EWA_ORDER_HEAD	Header Table for Waste Disposal Order	37	TEXT2	Text (30 Characters)	nvarchar	30	0
TOPWorkbench Tools Editors, Painters, Modelers
146	COVMVDAT	Table for Storing Coverage Results from Coverage Analyzer	30	TEXT2	For General Use of Names of Length < 30	nvarchar	30	0
147	COVMVHIS	Table for Storing the History from Coverage Analyzer	32	TEXT2	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

147 columns | ERP 6.0 | TEXT2