	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

66 columns | ERP 6.0 | MDCODE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPBasic Market Data
1	/BA1/F4_FXRATES	Exchange Rates	2	MDCODE	Market Data Area	nvarchar	4	0
2	/BA1/F4_INTRATE2	Interest Rates for Reference	2	MDCODE	Market Data Area	nvarchar	4	0
3	/BA1/F4_INTSPRD	Interest Rates for Reference	2	MDCODE	Market Data Area	nvarchar	4	0
4	/BA1/F4_SEC_CLAS	Map Charactistic Value for GUID	2	MDCODE	Market Data Area	nvarchar	4	0
5	/BA1/F4_VOL_FX	Key Table for Exchange Rate Volatilities	2	MDCODE	Market Data Area	nvarchar	4	0
6	/BA1/F4_VOL_IR	Key Table for Reference Interest Rate Volatilities	2	MDCODE	Market Data Area	nvarchar	4	0
7	/BA1/F4_VOL_SEC	Key Table for Security Price Volatilities	2	MDCODE	Market Data Area	nvarchar	4	0
8	/BA1/TF4_APPL	Partner Applications	3	MDCODE	Market Data Area	nvarchar	4	0
9	/BA1/TF4_EXCH	Definition of Stock Exchanges	2	MDCODE	Market Data Area	nvarchar	4	0
10	/BA1/TF4_EXCHT	Definition of Stock Exchanges	3	MDCODE	Market Data Area	nvarchar	4	0
11	/BA1/TF4_FXCVFCT	Exchange Rate Factors for Exchange Rates	2	MDCODE	Market Data Area	nvarchar	4	0
12	/BA1/TF4_FXFWDYC	Yield Curve Types for Forward Exchange Rates	2	MDCODE	Market Data Area	nvarchar	4	0
13	/BA1/TF4_FXKURST	Map Exchange Rate Category to Rate Type	2	MDCODE	Market Data Area	nvarchar	4	0
14	/BA1/TF4_FXRTTPT	Text Table for Exchange Rate Categories	3	MDCODE	Market Data Area	nvarchar	4	0
15	/BA1/TF4_FXRTTYP	Rate Categories for Exchange Rates	2	MDCODE	Market Data Area	nvarchar	4	0
16	/BA1/TF4_MDC	Market Data Area	2	MDCODE	Market Data Area	nvarchar	4	0
17	/BA1/TF4_MDCT	Market Data Area	3	MDCODE	Market Data Area	nvarchar	4	0
18	/BA1/TF4_MDSET	Market Data Records	2	MDCODE	Market Data Area	nvarchar	4	0
19	/BA1/TF4_MDSETRY	Forward Yield Curves for Reference Interest Rates	2	MDCODE	Market Data Area	nvarchar	4	0
20	/BA1/TF4_MDSETT	Market Data Records	3	MDCODE	Market Data Area	nvarchar	4	0
21	/BA1/TF4_MDSETV	Underlying Independent Volatilities per Currency	2	MDCODE	Market Data Area	nvarchar	4	0
22	/BA1/TF4_MDSETYP	Market Data Types in the Market Data Set	2	MDCODE	Market Data Area	nvarchar	4	0
23	/BA1/TF4_PADDON	Definition of Price Symbols	2	MDCODE	Market Data Area	nvarchar	4	0
24	/BA1/TF4_PADDONT	Definition of Price Symbols	3	MDCODE	Market Data Area	nvarchar	4	0
25	/BA1/TF4_PRINFO	Definition of Price Information	2	MDCODE	Market Data Area	nvarchar	4	0
26	/BA1/TF4_PRTYPE	Definition of Price Types	2	MDCODE	Market Data Area	nvarchar	4	0
27	/BA1/TF4_PRTYPET	Text Table for /BA1/TF4_PRTYPET	3	MDCODE	Market Data Area	nvarchar	4	0
28	/BA1/TF4_RCALCB	Assignment of Calculation Bases to Reference Interest Rates	2	MDCODE	Market Data Area	nvarchar	4	0
29	/BA1/TF4_REFRATE	Reference Interest Rates: Attributes	2	MDCODE	Market Data Area	nvarchar	4	0
30	/BA1/TF4_REFRATT	Reference Interest Rates: Name (Language-Dependent)	3	MDCODE	Market Data Area	nvarchar	4	0
31	/BA1/TF4_RPLTYPE	Replacement Types for Yield Curves	2	MDCODE	Market Data Area	nvarchar	4	0
32	/BA1/TF4_RPLTYPT	Text Table for Replacement Types	3	MDCODE	Market Data Area	nvarchar	4	0
33	/BA1/TF4_RRATES	Reference Interest Rates	2	MDCODE	Market Data Area	nvarchar	4	0
34	/BA1/TF4_SCEN	Market Date Scenarios	2	MDCODE	Market Data Area	nvarchar	4	0
35	/BA1/TF4_SCENPGP	Grid Points of a Scenario Progression	2	MDCODE	Market Data Area	nvarchar	4	0
36	/BA1/TF4_SCENSQC	Grid Points for Scenario Sequences	2	MDCODE	Market Data Area	nvarchar	4	0
37	/BA1/TF4_SCENT	Market Date Scenarios	3	MDCODE	Market Data Area	nvarchar	4	0
38	/BA1/TF4_SCFX	Scenario Exchange Rates	2	MDCODE	Market Data Area	nvarchar	4	0
39	/BA1/TF4_SCFXV	Scenarios for Exchange Rate Volatility	2	MDCODE	Market Data Area	nvarchar	4	0
40	/BA1/TF4_SCIRV	Interest Volatility Scenarios	2	MDCODE	Market Data Area	nvarchar	4	0
41	/BA1/TF4_SCREFR	Scenario Interest Rates	2	MDCODE	Market Data Area	nvarchar	4	0
42	/BA1/TF4_SCREFSP	Scenario nterest Rate Spreads	2	MDCODE	Market Data Area	nvarchar	4	0
43	/BA1/TF4_SCSEC	Security Price Scenarios	2	MDCODE	Market Data Area	nvarchar	4	0
44	/BA1/TF4_SCSECV	Security Volatility Scenarios	2	MDCODE	Market Data Area	nvarchar	4	0
45	/BA1/TF4_SCS_FX	Exchange Rate Shifts	2	MDCODE	Market Data Area	nvarchar	4	0
46	/BA1/TF4_SCS_SEC	Security Price Shifts	2	MDCODE	Market Data Area	nvarchar	4	0
47	/BA1/TF4_SCS_VOL	Volatility Shifts	2	MDCODE	Market Data Area	nvarchar	4	0
48	/BA1/TF4_SCS_YC	Zero Shifts for Yield Curves	2	MDCODE	Market Data Area	nvarchar	4	0
49	/BA1/TF4_SCTYPE	Spread Curve Types	2	MDCODE	Market Data Area	nvarchar	4	0
50	/BA1/TF4_SEQUCE	Definition of Read Sequence	2	MDCODE	Market Data Area	nvarchar	4	0
51	/BA1/TF4_SPRDTYP	Spread Types	2	MDCODE	Market Data Area	nvarchar	4	0
52	/BA1/TF4_SPRDTYT	Spread Types: Names (Language-Dependent)	3	MDCODE	Market Data Area	nvarchar	4	0
53	/BA1/TF4_STDYC	Standard Yield Curves	2	MDCODE	Market Data Area	nvarchar	4	0
54	/BA1/TF4_STRTGY	Definition of Read Strategy	2	MDCODE	Market Data Area	nvarchar	4	0
55	/BA1/TF4_STRTGYT	Definition of Price Symbols	3	MDCODE	Market Data Area	nvarchar	4	0
56	/BA1/TF4_SYCGRID	Standard Yield Curves: Grid Points for Reference Int. Rates	2	MDCODE	Market Data Area	nvarchar	4	0
57	/BA1/TF4_UNIT	Definition of Exchange Rate Units	2	MDCODE	Market Data Area	nvarchar	4	0
58	/BA1/TF4_UNITT	Definition of Price Symbols	3	MDCODE	Market Data Area	nvarchar	4	0
59	/BA1/TF4_VCLUS	Volatility Cluster	2	MDCODE	Market Data Area	nvarchar	4	0
60	/BA1/TF4_VTYP	Volatility Types	2	MDCODE	Market Data Area	nvarchar	4	0
61	/BA1/TF4_VTYPT	Text Table for Volatility Types	3	MDCODE	Market Data Area	nvarchar	4	0
62	/BA1/TF4_YCRPLMT	Yield Curve Replacement	2	MDCODE	Market Data Area	nvarchar	4	0
63	/BA1/TF4_YCTYPE	Yield Curve Types	2	MDCODE	Market Data Area	nvarchar	4	0
64	/BA1/TF4_YCTYPET	Yield Curve Types: Name (Language-Dependent)	3	MDCODE	Market Data Area	nvarchar	4	0
65	/BA1/TF4_YCURVE	Yield Curves: General Properties	2	MDCODE	Market Data Area	nvarchar	4	0
TOPMulti Currency Accounting
66	GLE_MCA_RV_HSTRY	FX Revaluation History	15	MDCODE	Market Data Area	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

66 columns | ERP 6.0 | MDCODE