	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

133 columns | ERP 6.0 | VAR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CNV_10940_REPVAR	Reports relevant for analyse variants	5	VAR	ABAP: Name of variant (without program name)	nvarchar	14	0
2	CNV_MBT_SWITCH_D	Detailed Table for storing values from Switch Framework	8	VAR	ABAP: Name of variant (without program name)	nvarchar	14	0
3	T7RUPACKGR	PFR Packages group	5	VAR	ABAP: Name of variant (without program name)	nvarchar	14	0
4	T800V	RW: Variables	3	VAR	Report Writer keyword	nvarchar	12	0
TOPBalanced Scorecard
5	UMB_MC101	Scorecard: Characteristics for the Value Fields of a Measure	10	VAR	Technical Name of Time Variable	nvarchar	10	0
6	UMB_MC107	Scorecard: BW Variables for the Value Fields of a Measure	10	VAR	Technical Name of Time Variable	nvarchar	10	0
7	UMB_SC100	Scorecard: Header Table	28	VAR	Technical Name of a CPM Variable	nvarchar	15	0
8	UMB_SC107	Scorecard: BIC Selections	8	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
9	UMB_SC108	Scorecard: Perspectives : BIC Selections	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
10	UMB_SC113	Scorecard: Perspective Assignment (Time-Dependent)	8	VAR	Technical Name of a CPM Variable	nvarchar	15	0
11	UMB_SC120	Scorecard: Strategy Assignment (Time-Dependent)	8	VAR	Technical Name of a CPM Variable	nvarchar	15	0
12	UMB_SC121	Scorecard: Strategy: BIC Selection	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
13	UMB_SC150	Scorecard: Objective Assignment (Time-Dependent)	8	VAR	Technical Name of a CPM Variable	nvarchar	15	0
14	UMB_SC152	Scorecard: Objective: BIC Selections	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
15	UMB_SC160	Scorecard: Measure Assignment (Time-Dependent)	8	VAR	Technical Name of a CPM Variable	nvarchar	15	0
16	UMB_SC166	Scorecard: Measures: BIC Selections	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
17	UMB_SC180	Scorecard: Initiatives	20	VAR	Technical Name of a CPM Variable	nvarchar	15	0
18	UMB_SC190	Scorecard: Initiatives: BIC Selections	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
19	UMB_SC194	Scorecard: Characteristics for BW Key Figs of an Initiative	10	VAR	Variable für Selection Conditions for Initiatives	nvarchar	10	0
20	UMB_SC196	Scorecard: BW Variables for Value Fields of an Initiative	10	VAR	Technical Name of Time Variable	nvarchar	10	0
21	UMB_WIZARD102	Default Settings for Each User. Used by BSC Wizard	7	VAR	Technical Name of a CPM Variable	nvarchar	15	0
TOPBusiness Planning and Simulation
22	UPB_PM_VARIABLE	Variables of Planning Folders	6	VAR	Variable	nvarchar	8	0
23	UPC_PROFILE_VAR	Planning Profiles - Variables	4	VAR	Variable	nvarchar	8	0
24	UPC_VAR	Variables	3	VAR	Variable	nvarchar	8	0
25	UPC_VARIABLE	Variables - Old Version of Database (New is UPC_VAR)	3	VAR	Variable	nvarchar	8	0
26	UPC_VARIABLET	Variables - Text Table	4	VAR	Variable	nvarchar	8	0
27	UPC_VAR_ATTR	Variables - Attributes	3	VAR	Variable	nvarchar	8	0
28	UPC_VAR_CHA	Variables - Characteristics	3	VAR	Variable	nvarchar	8	0
29	UPC_VAR_CHADEP	Variables - Selections using Hierarchies	3	VAR	Variable	nvarchar	8	0
30	UPC_VAR_CHADEPA	Variables - Selections using Hierarchies	3	VAR	Variable	nvarchar	8	0
31	UPC_VAR_CHA_ACT	Variables - Restricted Values	3	VAR	Variable	nvarchar	8	0
32	UPC_VAR_CHA_SEL	Variables - Selections	3	VAR	Variable	nvarchar	8	0
33	UPC_VAR_EXIT	Variables	3	VAR	Variable	nvarchar	8	0
34	UPC_VAR_HIE	Variables - Hierarchies	3	VAR	Variable	nvarchar	8	0
35	UPC_VAR_HIE_SEL	Variables - Selections using Hierarchies	3	VAR	Variable	nvarchar	8	0
36	UPC_VAR_HIE_SELA	Variables - Selections using Hierarchies (Active Values)	3	VAR	Variable	nvarchar	8	0
37	UPC_VAR_NUM_SEL	Variables - Numeric Selections	3	VAR	Variable	nvarchar	8	0
38	UPX_VARIABLE	UPX: Variable Assignment to Sales Planning	3	VAR	Variable	nvarchar	8	0
TOPCorporate Performance Monitor
39	UMC_TM100	Time Variable	2	VAR	Technical Name of Time Variable	nvarchar	10	0
40	UMC_TM100T	Time Variable: Texts	2	VAR	Technical Name of Time Variable	nvarchar	10	0
41	UMR_RF101	RMS: Measure-Risk Value Fields Selection Criteria	13	VAR	Technical Name of Time Variable	nvarchar	10	0
42	UMR_RF103	RMS: Measure-Risk Value Fields BW Variables	13	VAR	Technical Name of Time Variable	nvarchar	10	0
43	UMR_RI117	RMS: Measure Weight Data Selection - Selections - NOT USED	10	VAR	Technical Name of Time Variable	nvarchar	10	0
44	UMV_TR106	Value Driver Tree: Responsible Person	8	VAR	Technical Name of a CPM Variable	nvarchar	15	0
45	UMV_TR113	Obsolete: Value Driver Tree: Selections for the Value Fields	10	VAR	Technical Name of Time Variable	nvarchar	10	0
46	UMV_TR114	Obsolete:Value Driver Tree: BIC Selections for Value Drivers	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
47	UMV_TR117	Obsolete: Value Driver Tree: BW Variables for Value Fields	10	VAR	Technical Name of Time Variable	nvarchar	10	0
48	UMV_TR213	Value Driver Tree: Selections for the Value Fields	10	VAR	Technical Name of Time Variable	nvarchar	10	0
49	UMV_TR214	Value Driver Tree: BIC Selections for Measures	9	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
50	UMV_TR217	Value Driver Tree: BW Variables for Value Fields	10	VAR	Technical Name of Time Variable	nvarchar	10	0
51	UMV_TR227	Value Driver Tree: Responsible Persons for Measures	9	VAR	Technical Name of a CPM Variable	nvarchar	15	0
TOPDirectory
52	DBOBJ	Composition of Hybrid Objects	2	VAR	Table Name	nvarchar	30	0
53	LDAPMAP2	Mapping SAP Fields to LDAP Attributes - Fields	5	VAR	Table Name	nvarchar	30	0
54	LDAPPROP2	Proposals for Mapping SAP Fields to LDAP Attributes	5	VAR	Table Name	nvarchar	30	0
TOPIncentive and Commission Management ICM
55	CACS00_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
56	CACS00_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
57	CACS00_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
58	CACS00_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
59	CACS00_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
60	CACS00_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
61	CACS00_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
62	CACS00_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
63	CACS_B_VAR	Variants for BDTI	4	VAR	Variant Name	nvarchar	14	0
64	YCRM01_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
65	YCRM01_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
66	YCRM01_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
67	YCRM01_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
68	YCRM01_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
69	YCRM01_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
70	YCRM01_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
71	YCRM01_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
72	YHITEC_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
73	YHITEC_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
74	YHITEC_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
75	YHITEC_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
76	YHITEC_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
77	YHITEC_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
78	YHITEC_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
79	YHITEC_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
80	YSVMA_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
81	YSVMA_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
82	YSVMA_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
83	YSVMA_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
84	YSVMA_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
85	YSVMA_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
86	YSVMA_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
87	YSVMA_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
88	YTEL01_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
89	YTEL01_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
90	YTEL01_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
91	YTEL01_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
92	YTEL01_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
93	YTEL01_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
94	YTEL01_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
95	YTEL01_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
96	YTEL05_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
97	YTEL05_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
98	YTEL05_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
99	YTEL05_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
100	YTEL05_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
101	YTEL05_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
102	YTEL05_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
103	YTEL05_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
104	ZICMAG_B_VAR_ACT	Variants for Commission Case Activities	3	VAR	Variant Name	nvarchar	14	0
105	ZICMAG_B_VAR_BDL	Variants for Bundling	3	VAR	Variant Name	nvarchar	14	0
106	ZICMAG_B_VAR_CAS	Variants for Commission Case	3	VAR	Variant Name	nvarchar	14	0
107	ZICMAG_B_VAR_INV	Variants for Commission Case Participants	3	VAR	Variant Name	nvarchar	14	0
108	ZICMAG_B_VAR_LIN	Variants for Alternative Commission	3	VAR	Variant Name	nvarchar	14	0
109	ZICMAG_B_VAR_OBJ	Variants for Commission Case Object Data	3	VAR	Variant Name	nvarchar	14	0
110	ZICMAG_B_VAR_PAR	Variants for Commission Case Participant	3	VAR	Variant Name	nvarchar	14	0
111	ZICMAG_B_VAR_REL	Variants for Participant Relations	3	VAR	Variant Name	nvarchar	14	0
TOPInformation Consistency
112	SIC_NORM_ANORMRV	Assignment of Variables in Attribute Normalizing Rules	7	VAR	Variable of Basic Rule Type or Conditional Rule	nvarchar	30	0
113	SIC_NORM_BRTYI	Interface Variables for Basic Rule Types	3	VAR	Variable of Basic Rule Type	nvarchar	30	0
114	SIC_NORM_BRTYIT	Descriptioins for Interface Variables for Basic Rule Types	3	VAR	Variable	nvarchar	30	0
115	SIC_NORM_CONDRUC	Variables Assignment of Conditions	3	VAR	Interface Variable of Basic Rule Type or Condition Type	nvarchar	30	0
116	SIC_NORM_CONDRUV	Variables Assignment of Conditional Rules	7	VAR	Interface Variable of Basic Rule Type or Condition Type	nvarchar	30	0
117	SIC_NORM_CONDTIT	Descriptions for Interface Variables for Condition Types	3	VAR	Variable of Condition Type	nvarchar	30	0
118	SIC_NORM_CONDTYI	Interface Variables for Condition Types	3	VAR	Variable of Condition Type	nvarchar	30	0
119	SIC_NORM_NORMSTV	Assignment of Object Attributes to Rule Variables	5	VAR	Interface Variable of Attribute Normalizing Rule	nvarchar	30	0
TOPInternet Self-Services
120	UCES_CUST_ABBP	UCES: Customizing for Budget Billing Plan Adjustment	3	VAR	Variant of Internet Budget Billing Adjustment	nvarchar	1	0
TOPLocalization
121	J_1BECD_HISTORY	Electronic-Accounting-File History	13	VAR	Variant Register Category	nvarchar	1	0
TOPManagement Cockpit
122	UMM_FR101	Frames: Dimensions	10	VAR	Technical Name of Time Variable	nvarchar	10	0
123	UMM_FR115	Frame: Replacement of BW Variables	9	VAR	Technical Name of Time Variable	nvarchar	10	0
124	UMM_FR118	Frame: BIC Selections	8	VAR	Variable für Selection Conditions for BIC Documents	nvarchar	10	0
TOPMaster Data
125	GMREPORT	GM Report Tracking	8	VAR	Report Variant	nvarchar	14	0
TOPPayment Item
126	TBKKIRCV	Control of the Recipient Bank Detail Identification	4	VAR	Bank Identification Variant	nvarchar	1	0
TOPPrint and Output Management
127	T022D	Spool: Print control translation	4	VAR	Spool: Variant for use of print control sequences	nvarchar	1	0
TOPProfitability Analysis
128	TKEPPLLEVS	Planning Level - Selection Table	14	VAR	Variable On / Off	nvarchar	1	0
129	TKEPPLPPS	Planning Package - Selection Table	15	VAR	Variable On / Off	nvarchar	1	0
TOPRisk Analysis
130	JBRBDSVAR	RM-BDS: VaR Data	6	VAR	RM Report Data Memory: Value at Risk	float	15	16
TOPService Data Download
131	TCUSFUBA	Summary table of FMs to determine system-specific data	2	VAR	3-Byte field	nvarchar	3	0
TOPTour Data Entry
132	/DSD/DE_FUPREC	Tour Data Entry Control	3	VAR	Variant for Data Transfer from RADB	nvarchar	14	0
TOPWithout Description
133	IRTEST_URL	Variable Replacement CR	1	VAR	Parameter for URLs of Crystal Reports	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

133 columns | ERP 6.0 | VAR