	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

115 columns | ERP 6.0 | COLOR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMERP/STG_MM001	Data staging - Material master plant view complex table	181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
2	/SMERP/STG_MM002	Data staging - Material storage location view complex table	181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
3	/SMERP/STG_MM003	Data staging - Material UoM view complex table	182	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
4	/SMERP/STG_MM004	Data staging - Material warehouse view complex table	181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
5	/SMERP/STG_MM005	Data staging - Material batch view complex table	181	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
6	/WSOPT/DWS	Daily Work Schedule	6	COLOR	Color for ShiftTemplate	nvarchar	8	0
7	/XPPM/EVA_C_KPIC	PPM CS EVA: KPI Customizing (color ranges)	5	COLOR	KPI color	nvarchar	2	0
8	ABAP_ONLINE_ROOM	ABAP Online Community: Room members	7	COLOR	ABAP ONline Community: Character 64	nvarchar	64	0
9	DOUI_ELEM	DBOS Cockpit: Screen Element	23	COLOR	DBOS Cockpit: ID	nvarchar	32	0
10	EHFNDD_CHM_BINFO	Chemical - Basic Info	9	COLOR	Color	nvarchar	21	0
11	GRPC_STAT_COLOR	Status Color details	2	COLOR	Character field, length 7	nvarchar	7	0
12	QOD_STATUS_C	QM Statuses Customizing	5	COLOR	Status Color	nvarchar	6	0
13	T457H	MPS evaluation: hierarchy of MRP elements	16	COLOR	Color of curve	tinyint	3	0
14	TN1PDS_OGCA	Assignment of Occupational Group to Color	4	COLOR	Color of Progress Entry	nvarchar	7	0
15	UMG_TEST_B	data->string converstion test table	1	COLOR		nvarchar	1	0
16	UMG_TEST_C		1	COLOR		nvarchar	1	0
17	UMG_TEST_D	Unicode conversion test table	1	COLOR		nvarchar	1	0
18	UMG_TEST_G	Test table	2	COLOR	Single-Character Indicator	nvarchar	1	0
19	UMG_TEST_Q	Test table	1	COLOR		nvarchar	1	0
20	UMG_TEST_R	Test table	2	COLOR	Single-Character Indicator	nvarchar	1	0
21	YLP_MAST_LANE	MASTER LANE TABLE	5	COLOR	Color code for lane	nvarchar	20	0
22	ZEIMMARA	USING FOR STORING EIM MARA DATAS	212	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
23	ZRDB_DEL_DIR	16.09.2009: Delete DIR	50	COLOR	Nicht näher def. Bereich, evtl. für Patchlevels verwendbar	nvarchar	4	0
TOPAccount Determination
24	T180S	Reporting: Display Variants: Fields	19	COLOR	Color of curve	tinyint	3	0
TOPAppointment Calendar
25	SCAPPTTYPE	Appointment Type	11	COLOR	Appointment Management: Color of Appts. of Certain Types	int	10	0
TOPASAP Tools and Contents
26	SMAPPR0	Solution Map: Process category, main process, process	4	COLOR	Solution Map: Color	nvarchar	2	0
TOPAssortment
27	WRF_APC_MPA	Markdown Profile Assignment	5	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
TOPBasis Components
28	/XFT/INV_C14	Line coloring	2	COLOR	Line color	nvarchar	4	0
TOPBusiness Service Functions
29	RTXTF	Format Table for Report Texts	11	COLOR	Color	nvarchar	1	0
TOPCapacity and Resource Planning
30	/MRSS/C_RM_ASSGC	Maintain Colors for Assignments display	5	COLOR	Assignment Color Code	nvarchar	2	0
31	/MRSS/C_RM_SRCHC	Colors for Search Results	8	COLOR	Assignment Color Code	nvarchar	2	0
TOPCapacity Leveling
32	TCY66	Curve representation	3	COLOR	Color category of curve	nvarchar	2	0
TOPClaims Management
33	ICLITEMAU	Damaged Vehicle	19	COLOR	Color	nvarchar	10	0
34	ICSITEMAU	Damaged Vehicle	19	COLOR	Color	nvarchar	10	0
TOPClasses
35	KSML	Characteristics of a Class	23	COLOR	Color	nvarchar	1	0
TOPClinical System
36	N2AZLAYT	Rezeptierhilfe: GUI Layout Table	6	COLOR	GUI Struktur Layout Table COLOR	nvarchar	1	0
37	TN2CHART_COLOR	Enhances New Field MEDICATION_COLOR	2	COLOR	Charting: Color	nvarchar	15	0
38	TN2CHART_COLOR_T	Charting: Text Table for TN2CHART_COLOR	3	COLOR	Charting: Color	nvarchar	15	0
TOPComponent Integration Installation Windows Components
39	ECLSTAMPS	Table of All Existing Stamps for ECL Viewer	6	COLOR		int	10	0
TOPConstruction Equipment Management
40	J_3GLEIART	Activity Types	11	COLOR	Calendar: Color flag	nvarchar	1	0
TOPCross-Application Components
41	BC430_PROT	Archive for Logs of BC430_CHECK	6	COLOR		nvarchar	1	0
42	MMARA	General material data	212	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
TOPData Collection
43	TKEBX	Administration of exceptions	7	COLOR	Color in hierarchy graphic	nvarchar	2	0
TOPDatabase Monitors
44	INFCFGALRS	INFCFGCHECK: temp. storing of alert results	6	COLOR	INFCFGCHECK: Monit. attribute color	nvarchar	1	0
TOPEmployee Self-Service
45	T77WWW_LECC	Color codes for life event menu	1	COLOR	ESS Color for life event framework	nvarchar	8	0
46	T77WWW_LECCP	Color code allocation to service	3	COLOR	ESS Color for life event framework	nvarchar	8	0
47	T77WWW_LECCT	Color codes long texts for life event menu	2	COLOR	ESS Color for life event framework	nvarchar	8	0
TOPEnd User Technology
48	RSRA_BP_RTXTF	Report Agent BP Transport Copy/Versioning of rtxth	11	COLOR	Color	nvarchar	1	0
TOPEnterprise Service Framework Layer
49	SCOL_PLANE_ADDON	<cool> Ref. Flight Example: Additional Data for Aircraft	3	COLOR		ntext	1073741823	0
TOPEnvironment
50	LKSML	Characteristics of a Class	23	COLOR	Color	nvarchar	1	0
TOPEnvironment, Health and Safety
51	TCGL3	EHS: Report Applications	18	COLOR	Color display of a hierarchy node	nvarchar	1	0
TOPGraphic
52	COLORSEXC	Excel Colors	3	COLOR	Row Index of Internal Tables	int	10	0
53	TLSU5	SAP Structural Graphics: Text Table Colors	3	COLOR	Name of color	nvarchar	40	0
54	TWCOL	Possible colors (W lib)	2	COLOR	Color in W interface	nvarchar	11	0
55	TWCOT	Texts on Colors	3	COLOR	Color in W interface	nvarchar	11	0
TOPI18N Unicode
56	TECHED02_COLORS	Test	1	COLOR		nvarchar	1	0
57	TECHED03_COLORS	Multilangual demo data	1	COLOR		nvarchar	1	0
58	TECHED03_RESULT1	Result table for Unicode outside communication exercises	5	COLOR		nvarchar	1	0
59	UMG_TEST_1	Multilangual demo data	1	COLOR		nvarchar	1	0
60	UMG_TEST_2	Multilangual demo data	1	COLOR		nvarchar	1	0
61	UMG_TEST_3	Multilangual demo data	1	COLOR		nvarchar	1	0
62	UMG_TEST_4	Multilangual demo data	2	COLOR	Single-Character Indicator	nvarchar	1	0
TOPInventory Management
63	MMIM_REP_PRINT	Print Settings, Reporting MM-IM	7	COLOR	Do Not Color Values After +/- Sign	nvarchar	1	0
TOPLoans Management
64	TDPR_ATTRTYPE	Attribute Type	2	COLOR	Color display of a hierarchy node	nvarchar	1	0
TOPLocalization
65	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	130	COLOR	Color of Line Item in the List	nvarchar	3	0
66	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	130	COLOR	Color of Line Item in the List	nvarchar	3	0
67	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	130	COLOR	Color of Line Item in the List	nvarchar	3	0
TOPLogistics
68	TCNVF	Variable overviews: Displayed fields	16	COLOR	Variable overviews: Color	nvarchar	1	0
69	TCNVZ	Variable overviews: Displayed objects (lines)	12	COLOR	Variable overviews: Color	nvarchar	1	0
TOPMaintenance Orders
70	/MRSS/C_DBM_STAT	This Table maps DBM order status to graphical element type	3	COLOR	Graphic element type	nvarchar	2	0
71	/MRSS/C_DSG_CLR	Hold the color details of the properties of the graph	3	COLOR	Colors for chart engine graph	nvarchar	20	0
72	/MRSS/C_DSG_COL	Color Properties for Web Util Report	4	COLOR	WebDynpro:BarColor	nvarchar	2	0
73	/MRSS/C_DSG_TCOL	Table to store the team colour properties	3	COLOR	Colors for chart engine graph	nvarchar	20	0
TOPMaintenance Processing
74	/MRSS/C_DPR_ACCL	Color for showing resource availability(Assignment Calendar)	3	COLOR	Color code for Resource Availability(Assgn Calendar)	nvarchar	2	0
TOPManagement Cockpit
75	UMM_DFT_T_RANGE	Default Value Range for Tachometer	11	COLOR	Color of Range	int	10	0
76	UMM_FR119	Table for Legend Color (Obsolete from SEM 3.5)	5	COLOR	Color	nvarchar	10	0
77	UMM_FR120	Table for Graphics Color (Obsolete from SEM 3.5)	4	COLOR	Color	nvarchar	10	0
TOPMaterial Groups
78	WTREE	Version Management for Reclassification Trees	18	COLOR	Color display of a hierarchy node	nvarchar	1	0
TOPMaterial Master
79	MARA	General Material Data	212	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
80	MARA_TMP	File for Incorrect Data in Direct Input	219	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
81	MVRA	Cross-version fields for MARA	212	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
82	WER_TEST_ARTICLE	Subset of articles used for testing	8	COLOR	Color of curve	tinyint	3	0
83	WER_TEST_MARA	Subset of mara fields for testing	7	COLOR	Color of curve	tinyint	3	0
84	WER_TEST_RESULT	Subset of mara fields containing the result for testing	7	COLOR	Color of curve	tinyint	3	0
TOPPersonal Object Worklist
85	POWL_EASY_DEFT	Technical Fields of Fieldcatalog for Easy-POWL Feeder	31	COLOR		nvarchar	2	0
TOPPlanning
86	N1PGCOLSTAT	Color Selection for Appointments	8	COLOR	Surgery Scheduling: Value for Color	nvarchar	8	0
TOPPortfolio Management
87	RPM_DP_STATGRP	Dependency:Status Indicators group	6	COLOR	Alert Object Color Status	nvarchar	7	0
88	RPM_PROJ_BDGRP	Project Budget Status Group	6	COLOR	Alert Object Color Status	nvarchar	7	0
89	RPM_PROJ_PRGRP	Project Priority group	6	COLOR	Alert Object Color Status	nvarchar	7	0
90	RPM_PROJ_RKGRP	Project Risk Group	6	COLOR	Alert Object Color Status	nvarchar	7	0
91	RPM_PROJ_SDGRP	Project Schedule Status Group	6	COLOR	Alert Object Color Status	nvarchar	7	0
92	RPM_PROJ_STGRP	Project Staffing Status Group	6	COLOR	Alert Object Color Status	nvarchar	7	0
TOPPrice Planning Workbench
93	WRF_PPW_WORKLERR	PPW Worklist Error Table	4	COLOR	Characteristic Value that Describes a Color	nvarchar	18	0
94	WRF_PPW_WORKLIST	PPW Worklist	4	COLOR	Characteristic Value that Describes a Color	nvarchar	18	0
TOPProcess Controls
95	GRPCDEFTYPE	Deficiency Type	3	COLOR	Color	nvarchar	1	0
TOPProduct definition
96	TFIPR_ATTRTYPE	Attribute Category	2	COLOR	Color display of a hierarchy node	nvarchar	1	0
TOPProfitability Analysis
97	CEPRINT	Table for description of print statement for CO-PA forms	25	COLOR	Display color	nvarchar	2	0
98	CESETS	Set Administration in the Report Painter	13	COLOR	Display color	nvarchar	2	0
TOPRisk Analysis
99	JBRNODETXT	All Information for Display of Hierarchies	14	COLOR	Color display of a hierarchy node	nvarchar	1	0
TOPRisk Assessment
100	EHHSSC_RISKEVA	Risk Evaluations	4	COLOR	Risk Evaluation Color	nvarchar	1	0
101	EHHSSC_RISKLVL	Risk Levels	6	COLOR	Risk Level Color	nvarchar	1	0
TOPSAP Internet Transaction Server
102	ITS_CSS	contains cascading style sheets (css) for generator	42	COLOR		nvarchar	25	0
TOPSAP Multiresource Scheduling
103	/MRSS/C_SGX_CTPO	JGantt Color Categories - Color Items	4	COLOR	RGB Color Code (Red, Green, Blue) Separated by Commas	nvarchar	11	0
TOPSAP Utilities
104	SCODE_IN	Seal code	9	COLOR	Characteristic Value for Colors of Variants	nvarchar	18	0
TOPShift Planning
105	T77ED	Shift Planning: Definition of Shifts	23	COLOR	Color Definition for Shift Abbreviation Field	nvarchar	1	0
106	T77RQ_ICON	Icon Settings for Requirements Matchup - Shift Planning	5	COLOR	Color Definition for Shift Abbreviation Field	nvarchar	1	0
107	T77SP_STYLE	Color and Character Formatting for Shift Planning	4	COLOR	Color Definition for Shift Abbreviation Field	nvarchar	1	0
TOPTime Data Recording and Administration
108	TMW_TD_ATTRIB	Color Attributes for Short IDs in the TMW	4	COLOR	Color Definition for Shift Abbreviation Field	nvarchar	1	0
TOPTraders and Schedulers Workbench
109	OIJWLRCN	OIL-TSW: Worklist Reason codes	7	COLOR	OIL-TSW: Color	nvarchar	2	0
TOPTravel Expenses
110	T706_ABWH	Absence Types from Place of Work (PS; Separation Allowance)	5	COLOR	Color of Selected Days in Calendar	tinyint	3	0
TOPTravel Planning
111	TA20PPP	Priority of Trip Rules	3	COLOR	Color of priority	nvarchar	1	0
TOPUser and Authorization Management
112	USKRIA	Entry of Critical Auths for Report RSUSR009	8	COLOR	Color for WRITE	tinyint	3	0
TOPWaste Management
113	TEWARESULTZ	IS-W: Allocation of fields to confirmation category	13	COLOR	Color Of Confirmation Field	nvarchar	20	0
TOPWithout Description
114	RSHIENODES	Hierarchy Node(s)	16	COLOR	Color of Hierarchicy Node	nvarchar	2	0
TOPWork Center
115	TC30	Work center category	8	COLOR	Color work center category for graphics	nvarchar	11	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 | COLOR