	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

150 columns | ERP 6.0 | IWERK

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/MRSS/M_RSG_AA	Mirror for Allow Abstract Assignment	7	IWERK	Maintenance Planning Plant	nvarchar	4	0
2	/MRSS/M_RSG_SA	Mirror for extended assignments	7	IWERK	Maintenance Planning Plant	nvarchar	4	0
3	/SMERP/STG_PM001	Data staging - Equipment complex table	85	IWERK	Maintenance Planning Plant	nvarchar	4	0
4	/SMERP/STG_PM002	Data staging - Functional Location complex table	31	IWERK	Maintenance Planning Plant	nvarchar	4	0
5	/SMERP/STG_PM003	Data staging - Equipment List Set - Hdr - complex tab	85	IWERK	Maintenance Planning Plant	nvarchar	4	0
6	/SMERP/STG_PM008	Data staging - Functional Loc. List Set - Hdr - complex tab	31	IWERK	Maintenance Planning Plant	nvarchar	4	0
7	/WSOPT/C_OPRST	Relev. Control Keys	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
8	ITTS_OT_MODE	Operation Ticket Mode	2	IWERK	Plant for Work Center in WCM	nvarchar	4	0
9	ITTS_PERRES	Personnel Responsible in TTS	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
10	ITTS_SCRM	tts:screen management	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
11	T350W	Maintenance control parameters: Order type plant	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
12	TTS_FPUSAGE	Usages of Assistant Work Ticket	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
13	TTS_OTCONF	Configuration for User Field in Operation Ticket	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
14	TTS_PERRES	TTS Approver Authorizations	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
15	TTS_ROLE_CHECK	Check the role	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
16	TTS_WCCJ	TTS: Selection Fields for Creation with Template	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
17	TTS_WTCONF	Configuration for User Field in Work Ticket	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
18	WCCPU	WCM: Usages of WCM Object <-> Approvals	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPAerospace Defence Industry Solution
19	DIMSP_NOTIF_TYPE	MSP Notification Types	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
20	DIMSP_REVI_TYPE	MSP Revision Types	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPAMI Event Management
21	EFDT_EXPR002	FDT: Expression - Notification Order	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
22	EFDT_EXPR002A	FDT: Expression - Create Notification Order	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
23	EFDT_EXPR002S	FDT: Expression - Create Notification Order	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
24	EFDT_EXPR002T	FDT: Expression - Create Notification Order	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPConditions
25	B060	PM Message - Plant Maintenance	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPData Collection
26	S116	Customer Analysis	11	IWERK	Maintenance Planning Plant	nvarchar	4	0
27	S116E	S116 - Structural information	6	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPEquipment
28	EQUZ	Equipment time segment	16	IWERK	Maintenance Planning Plant	nvarchar	4	0
29	IEQT_WL_ITEMS	Interim Statuses - Items	34	IWERK	Maintenance Planning Plant	nvarchar	4	0
30	IEQT_WL_ITM_BAC	Interim Statuses - Items (Backup)	35	IWERK	Maintenance Planning Plant	nvarchar	4	0
31	T024I	Maintenance planner groups	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPFunctional Locations
32	IFLOT	Functional Location (Table)	25	IWERK	Maintenance Planning Plant	nvarchar	4	0
33	IFLOT_VS	Functional Location (Version Table)	26	IWERK	Maintenance Planning Plant	nvarchar	4	0
34	IRLOT	Reference Functional Location (Table)	19	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPLine Maintenance
35	/ISDFPS/CLMFLSTA	Status Objects in PM Order Type Flight	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPLogistics Basic Data
36	DMF_D_T001W	Transferred Sites	24	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPMaintenance History
37	HIKO	Order master data history	39	IWERK	Maintenance Planning Plant	nvarchar	4	0
38	T003O_DS	Digital Signatues for Order Operations	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
39	T003O_SC	Status Change Control For PM Orders	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPMaintenance Notifications
40	QMIH	Quality message - maintenance data excerpt	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPMaintenance Orders
41	/CUM/CONMS	CU: Construction Measure Master Data	8	IWERK	Maintenance Planning Plant	nvarchar	4	0
42	/CUM/CUDESIGN	CU: Design Header Data	9	IWERK	Maintenance Planning Plant	nvarchar	4	0
43	/CUM/CU_SRD	CU: Settlement Rule Determination Rules	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
44	/CUM/PRF_ORD	CU: Profile for Order Generation	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
45	/MRSS/C_RSG_AA	Allow Abstract Assignment	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
46	/MRSS/C_RSG_SA	Extended assignments	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
47	AFIH	Maintenance order header	10	IWERK	Maintenance Planning Plant	nvarchar	4	0
48	IOCI_ORGU	OCI Interface: Control Parameter PM/CS Order	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
49	IWOT_LNK	Assignment of View Profiles	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
50	T350E	Access sequence addresses for address proposal purch. data	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
51	T352R	Maintenance revisions	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
52	T399I	Planning plant parameters	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
53	TPMUS	PM/SM - User default values	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPMaintenance Program Definition
54	MPDITEM	Maintenance Plan Items	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
55	MPDPSD	MPD: MPD and MP header data	27	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPMaintenance Task Lists
56	EAPL	Allocation of task lists to pieces of equipment	14	IWERK	Maintenance Planning Plant	nvarchar	4	0
57	MPOS	Maintenance item	23	IWERK	Maintenance Planning Plant	nvarchar	4	0
58	TAPL	Allocation of task lists to functional locations	8	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPPlant Maintenance
59	T003O_BC	MCB Budget check parameter for PM Work order	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
60	T390_U	Print control by user	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPPlant Master
61	T001W	Plants/Branches	24	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPProcessing
62	TEN399A	Control: Automatic Creation of Maint./Serv. Notification	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
63	TEREGPLANT	Allocation of Plant to Service Object and Reg. Struc. Area	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
64	TEREGPLANTWC	Allocation of Workplace to Service Obj. and Regional Group	5	IWERK	Maintenance Planning Plant	nvarchar	4	0
65	TEREGPLNOTIF	Alloc. of Planning Plant to Notif.Profile and Reg.Struc.Area	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPProduct Lifecycle Management
66	CDIWPS_NAV_RV	Customizing Table for Navigation Area RV in MEB	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
67	DIWPS	Work Package	12	IWERK	Plant	nvarchar	4	0
68	DIWPS_CA	Characteristics for Work Package	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
69	DIWPS_REV_ORDER	Revision Order Table	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
70	DIWPS_RV_CA	Revision: Characteristics for Work Package	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
71	DIWPS_RV_CR	Revision: Cross-Reference Notification	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPReporting
72	S061	Location and planning	11	IWERK	Maintenance Planning Plant	nvarchar	4	0
73	S061E	S061 - Structural Information	6	IWERK	Maintenance Planning Plant	nvarchar	4	0
74	S114	Fahrzeugverbrauchsanalyse	12	IWERK	Onderhoudsorganisatie	nvarchar	4	0
75	S114E	S114 - Strukturinformationen	7	IWERK	Onderhoudsorganisatie	nvarchar	4	0
TOPRouting
76	PLKO	Task list - header	44	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPService Processing
77	/WSCGMBH/C_OPRST	ClickSchedulue: Relev. Control Keys	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
78	/WSCGMBH/C_TMPL	ClickSchedule: Assignment Templates	7	IWERK	Maintenance Planning Plant	nvarchar	4	0
79	T399A	Control: Automatic Order Creation	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPSimulation
80	VSAFIH_CN	Version: Order header for plant maintenance	11	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPVehicle Management System
81	VLCSMORDER	VELO : Service Order	6	IWERK	Maintenance Planning Plant	nvarchar	4	0
TOPWork Clearance Management
82	WCAAP	WCM: Application	13	IWERK	Maintenance Planning Plant	nvarchar	4	0
83	WCACD	WCM: Operational Class <-> PM Object	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
84	WCACE	WCM: Operational Condition <-> Operational Class	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
85	WCACH	WCM: (Temporary) Log for Tagging/Untagging (Time-Frame)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
86	WCACI	WCM: (Temporary) Log for Tagging/Untagging (Conflict Check)	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
87	WCACM	WCM: Current Operational Condition/Type	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
88	WCACN	WCM: (Temporary) Log (Tag/Test Tag)	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
89	WCACNQ	WCM: Log (Operational Tag)	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
90	WCACQ	WCM: Log for Tagging/Untagging (Conflict Check)	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
91	WCACS	WCM: (Temporary) Log (Protected Area)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
92	WCAD	WCM: Approval Group	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
93	WCADQ	WCM: Log (Approval Group)	4	IWERK	Maintenance Planning Plant	nvarchar	4	0
94	WCAG	WCM: Data for Mode-Dependent Tagging	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
95	WCAHE	WCM: Work Clearance Document (Header)	14	IWERK	Maintenance Planning Plant	nvarchar	4	0
96	WCAJ	WCM: Lineup	7	IWERK	Maintenance Planning Plant	nvarchar	4	0
97	WCAMB	WCM: Plant-Specific User Settings	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
98	WCAPL	WCM: Print Log	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
99	WCAR	WCM: Operational Step	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
100	WCAW	WCM: Work Approval	12	IWERK	Maintenance Planning Plant	nvarchar	4	0
101	WCC0R	WCM: WCM Object <-> View Profile	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
102	WCC0SU	WCM: Subscreens with Individual Attributes	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
103	WCC0SUT	WCM: Subscreens with Individual Attributes (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
104	WCC1	WCM: Work Permits	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
105	WCC2N	WCM: Requirements	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
106	WCC2W	WCM: Work	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
107	WCC3	WCM: Selection of WCM Objects	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
108	WCCA	WCM: Switching Data	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
109	WCCE	WCM: Conflict Rules	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
110	WCCF	WCM: Revision Phase	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
111	WCCFT	WCM: Revision Phase (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
112	WCCG	WCM: Overall Conditions of Technical System	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
113	WCCGT	WCM: Overall Conditions of Technical System (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
114	WCCH	WCM: Train	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
115	WCCHT	WCM: Train (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
116	WCCI	WCM: Tag <-> (Operational Group, Operational Type; Test Tag)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
117	WCCJ	WCM: Selection Fields for Creation with Template	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
118	WCCK	WCM: Operational Class	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
119	WCCKT	WCM: Operational Class (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
120	WCCL	WCM: Print	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
121	WCCLT	WCM: Print (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
122	WCCLU	WCM: Lineup Usage	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
123	WCCLUT	WCM: Lineup Usage	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
124	WCCLV	WCM: Lineup	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
125	WCCLX	WCM: Print (User-Specific)	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
126	WCCMR	WCM: Order Operation	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
127	WCCMS	WCM: Operational Step	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
128	WCCMST	WCM: Operational Step (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
129	WCCMU	WCM: Operational Step	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
130	WCCN	WCM: Valuation	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
131	WCCO	WCM: WCM Object	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
132	WCCOG	WCM: WCM Object	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
133	WCCOGT	WCM: WCM Object (General Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
134	WCCOR	WCM: WCM Object (Master) <-> WCM Object (Slave)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
135	WCCOT	WCM: WCM Object (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
136	WCCP	WCM: WCM Object <-> Approvals	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
137	WCCPN	WCM: Approval Group	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
138	WCCPV	WCM: Approval Groups	3	IWERK	Maintenance Planning Plant	nvarchar	4	0
139	WCCR	WCM: Application Profile	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
140	WCCU	WCM: Use of Work Clearance Document	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
141	WCCUT	WCM: Use of Work Clearance Document (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
142	WCCV	WCM: Physical Blocking Type	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
143	WCCVT	WCM: Physical Blocking Type (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
144	WCCWA	WCM: Changes (Additional Data) Forbidden	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
145	WCCWB	WCM: Assignment Forbidden	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
146	WCCX	WCM: Use of Work Approval	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
147	WCCXT	WCM: Use of Work Approval (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
148	WCCY	WCM: Use of Application	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
149	WCCYT	WCM: Use of Application (Texts)	2	IWERK	Maintenance Planning Plant	nvarchar	4	0
150	WCCZ	WCM: Text Processing	2	IWERK	Maintenance Planning Plant	nvarchar	4	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

150 columns | ERP 6.0 | IWERK