	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

135 columns | ERP 6.0 | IMPORT_YEAR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPIncentive and Commission Management ICM
1	CACS00_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
2	CACS00_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
3	CACS00_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
4	CACS00_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
5	CACS00_B_VAR_CAS	Variants for Commission Case	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
6	CACS00_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
7	CACS00_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
8	CACS00_B_VAR_OBJ	Variants for Commission Case Object Data	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
9	CACS00_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
10	CACS00_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
11	CACS00_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
12	CACS00_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
13	CACS00_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
14	CACS00_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
15	CACS00_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
16	CACS00_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
17	CACS00_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
18	CACSCP_RCP_BUFF	RCP: Buffer Table for RCP Processing	3	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
19	CACSCP_RCP_CASE	RCP: Initial Commission Cases	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
20	CACSCP_RCP_WL	RCP: Worklist	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
21	CACS_BUFFLOG	Commissions: Log Table of Commission Objects	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
22	CACS_COILOG	Recording of the Keys of Records Processed with COI	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
23	CACS_EDTPROT	Commissions: Log for EDT Interface Supply	7	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
24	CACS_TGLOG	Obsolete (Target Agreements: Log)	9	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
25	CACS_WFCAS	Commission Case: Workflow Characteristics for Pending Cases	3	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
26	TCACS_CATT01	Directory of Commission Cases to be Tested Automatically	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
27	TCACS_CATT01T	Directory of Commission Cases to be Tested Automatically	5	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
28	YCRM01_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
29	YCRM01_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
30	YCRM01_B_VAR_ACT	Variants for Commission Case Activities	7	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
31	YCRM01_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
32	YCRM01_B_VAR_CAS	Variants for Commission Case	14	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
33	YCRM01_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
34	YCRM01_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
35	YCRM01_B_VAR_OBJ	Variants for Commission Case Object Data	53	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
36	YCRM01_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
37	YCRM01_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
38	YCRM01_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
39	YCRM01_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
40	YCRM01_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
41	YCRM01_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
42	YCRM01_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
43	YCRM01_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
44	YCRM01_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
45	YHITEC_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
46	YHITEC_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
47	YHITEC_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
48	YHITEC_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
49	YHITEC_B_VAR_CAS	Variants for Commission Case	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
50	YHITEC_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
51	YHITEC_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
52	YHITEC_B_VAR_OBJ	Variants for Commission Case Object Data	17	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
53	YHITEC_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
54	YHITEC_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
55	YHITEC_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
56	YHITEC_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
57	YHITEC_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
58	YHITEC_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
59	YHITEC_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
60	YHITEC_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
61	YHITEC_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
62	YSVMA_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
63	YSVMA_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
64	YSVMA_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
65	YSVMA_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
66	YSVMA_B_VAR_CAS	Variants for Commission Case	14	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
67	YSVMA_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
68	YSVMA_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
69	YSVMA_B_VAR_OBJ	Variants for Commission Case Object Data	21	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
70	YSVMA_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
71	YSVMA_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
72	YSVMA_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
73	YSVMA_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
74	YSVMA_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
75	YSVMA_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
76	YSVMA_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
77	YSVMA_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
78	YSVMA_RCP_BUFF	RCP: Buffer Table for RCP Processing	3	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
79	YSVMA_RCP_CASE	RCP: Initial Commission Cases	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
80	YSVMA_RCP_WL	RCP: Worklist	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
81	YSVMA_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
82	YTEL01_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
83	YTEL01_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
84	YTEL01_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
85	YTEL01_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
86	YTEL01_B_VAR_CAS	Variants for Commission Case	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
87	YTEL01_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
88	YTEL01_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
89	YTEL01_B_VAR_OBJ	Variants for Commission Case Object Data	41	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
90	YTEL01_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
91	YTEL01_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
92	YTEL01_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
93	YTEL01_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
94	YTEL01_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
95	YTEL01_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
96	YTEL01_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
97	YTEL01_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
98	YTEL01_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
99	YTEL05_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
100	YTEL05_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
101	YTEL05_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
102	YTEL05_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
103	YTEL05_B_VAR_CAS	Variants for Commission Case	14	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
104	YTEL05_B_VAR_INV	Variants for Commission Case Participants	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
105	YTEL05_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
106	YTEL05_B_VAR_OBJ	Variants for Commission Case Object Data	39	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
107	YTEL05_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
108	YTEL05_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
109	YTEL05_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
110	YTEL05_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
111	YTEL05_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
112	YTEL05_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
113	YTEL05_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
114	YTEL05_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
115	YTEL05_RCP_BUFF	RCP: Buffer Table for RCP Processing	3	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
116	YTEL05_RCP_CASE	RCP: Initial Commission Cases	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
117	YTEL05_RCP_WL	RCP: Worklist	4	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
118	YTEL05_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
119	ZICMAG_ACT	Commission Case Activities	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
120	ZICMAG_BDL	Rebundling Order for Triggering Subobjects	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
121	ZICMAG_B_VAR_ACT	Variants for Commission Case Activities	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
122	ZICMAG_B_VAR_BDL	Variants for Bundling	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
123	ZICMAG_B_VAR_CAS	Variants for Commission Case	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
124	ZICMAG_B_VAR_INV	Variants for Commission Case Participants	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
125	ZICMAG_B_VAR_LIN	Variants for Alternative Commission	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
126	ZICMAG_B_VAR_OBJ	Variants for Commission Case Object Data	9	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
127	ZICMAG_B_VAR_PAR	Variants for Commission Case Participant	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
128	ZICMAG_B_VAR_REL	Variants for Participant Relations	6	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
129	ZICMAG_CAS	Commission Case	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
130	ZICMAG_INV	Commission Case Participants	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
131	ZICMAG_LIN	Variant Commissions	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
132	ZICMAG_OBJ	Commission Case Object Data	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
133	ZICMAG_OBJHIST	Change History of Subobjects That Trigger Commission	8	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
134	ZICMAG_PAR	Commission Case Participation	2	IMPORT_YEAR	Year Commission Case Reported	nvarchar	4	0
135	ZICMAG_REL	Participant Relations in a Commission Participation	2	IMPORT_YEAR	Year Commission Case Reported	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

135 columns | ERP 6.0 | IMPORT_YEAR