SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

66 columns | Print definition?ERP 6.0  | MDCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Market Data
1/BA1/F4_FXRATESExchange Rates2MDCODEMarket Data Areanvarchar40
2/BA1/F4_INTRATE2Interest Rates for Reference2MDCODEMarket Data Areanvarchar40
3/BA1/F4_INTSPRDInterest Rates for Reference2MDCODEMarket Data Areanvarchar40
4/BA1/F4_SEC_CLASMap Charactistic Value for GUID2MDCODEMarket Data Areanvarchar40
5/BA1/F4_VOL_FXKey Table for Exchange Rate Volatilities2MDCODEMarket Data Areanvarchar40
6/BA1/F4_VOL_IRKey Table for Reference Interest Rate Volatilities2MDCODEMarket Data Areanvarchar40
7/BA1/F4_VOL_SECKey Table for Security Price Volatilities2MDCODEMarket Data Areanvarchar40
8/BA1/TF4_APPLPartner Applications3MDCODEMarket Data Areanvarchar40
9/BA1/TF4_EXCHDefinition of Stock Exchanges2MDCODEMarket Data Areanvarchar40
10/BA1/TF4_EXCHTDefinition of Stock Exchanges3MDCODEMarket Data Areanvarchar40
11/BA1/TF4_FXCVFCTExchange Rate Factors for Exchange Rates2MDCODEMarket Data Areanvarchar40
12/BA1/TF4_FXFWDYCYield Curve Types for Forward Exchange Rates2MDCODEMarket Data Areanvarchar40
13/BA1/TF4_FXKURSTMap Exchange Rate Category to Rate Type2MDCODEMarket Data Areanvarchar40
14/BA1/TF4_FXRTTPTText Table for Exchange Rate Categories3MDCODEMarket Data Areanvarchar40
15/BA1/TF4_FXRTTYPRate Categories for Exchange Rates2MDCODEMarket Data Areanvarchar40
16/BA1/TF4_MDCMarket Data Area2MDCODEMarket Data Areanvarchar40
17/BA1/TF4_MDCTMarket Data Area3MDCODEMarket Data Areanvarchar40
18/BA1/TF4_MDSETMarket Data Records2MDCODEMarket Data Areanvarchar40
19/BA1/TF4_MDSETRYForward Yield Curves for Reference Interest Rates2MDCODEMarket Data Areanvarchar40
20/BA1/TF4_MDSETTMarket Data Records3MDCODEMarket Data Areanvarchar40
21/BA1/TF4_MDSETVUnderlying Independent Volatilities per Currency2MDCODEMarket Data Areanvarchar40
22/BA1/TF4_MDSETYPMarket Data Types in the Market Data Set2MDCODEMarket Data Areanvarchar40
23/BA1/TF4_PADDONDefinition of Price Symbols2MDCODEMarket Data Areanvarchar40
24/BA1/TF4_PADDONTDefinition of Price Symbols3MDCODEMarket Data Areanvarchar40
25/BA1/TF4_PRINFODefinition of Price Information2MDCODEMarket Data Areanvarchar40
26/BA1/TF4_PRTYPEDefinition of Price Types2MDCODEMarket Data Areanvarchar40
27/BA1/TF4_PRTYPETText Table for /BA1/TF4_PRTYPET3MDCODEMarket Data Areanvarchar40
28/BA1/TF4_RCALCBAssignment of Calculation Bases to Reference Interest Rates2MDCODEMarket Data Areanvarchar40
29/BA1/TF4_REFRATEReference Interest Rates: Attributes2MDCODEMarket Data Areanvarchar40
30/BA1/TF4_REFRATTReference Interest Rates: Name (Language-Dependent)3MDCODEMarket Data Areanvarchar40
31/BA1/TF4_RPLTYPEReplacement Types for Yield Curves2MDCODEMarket Data Areanvarchar40
32/BA1/TF4_RPLTYPTText Table for Replacement Types3MDCODEMarket Data Areanvarchar40
33/BA1/TF4_RRATESReference Interest Rates2MDCODEMarket Data Areanvarchar40
34/BA1/TF4_SCENMarket Date Scenarios2MDCODEMarket Data Areanvarchar40
35/BA1/TF4_SCENPGPGrid Points of a Scenario Progression2MDCODEMarket Data Areanvarchar40
36/BA1/TF4_SCENSQCGrid Points for Scenario Sequences2MDCODEMarket Data Areanvarchar40
37/BA1/TF4_SCENTMarket Date Scenarios3MDCODEMarket Data Areanvarchar40
38/BA1/TF4_SCFXScenario Exchange Rates2MDCODEMarket Data Areanvarchar40
39/BA1/TF4_SCFXVScenarios for Exchange Rate Volatility2MDCODEMarket Data Areanvarchar40
40/BA1/TF4_SCIRVInterest Volatility Scenarios2MDCODEMarket Data Areanvarchar40
41/BA1/TF4_SCREFRScenario Interest Rates2MDCODEMarket Data Areanvarchar40
42/BA1/TF4_SCREFSPScenario nterest Rate Spreads2MDCODEMarket Data Areanvarchar40
43/BA1/TF4_SCSECSecurity Price Scenarios2MDCODEMarket Data Areanvarchar40
44/BA1/TF4_SCSECVSecurity Volatility Scenarios2MDCODEMarket Data Areanvarchar40
45/BA1/TF4_SCS_FXExchange Rate Shifts2MDCODEMarket Data Areanvarchar40
46/BA1/TF4_SCS_SECSecurity Price Shifts2MDCODEMarket Data Areanvarchar40
47/BA1/TF4_SCS_VOLVolatility Shifts2MDCODEMarket Data Areanvarchar40
48/BA1/TF4_SCS_YCZero Shifts for Yield Curves2MDCODEMarket Data Areanvarchar40
49/BA1/TF4_SCTYPESpread Curve Types2MDCODEMarket Data Areanvarchar40
50/BA1/TF4_SEQUCEDefinition of Read Sequence2MDCODEMarket Data Areanvarchar40
51/BA1/TF4_SPRDTYPSpread Types2MDCODEMarket Data Areanvarchar40
52/BA1/TF4_SPRDTYTSpread Types: Names (Language-Dependent)3MDCODEMarket Data Areanvarchar40
53/BA1/TF4_STDYCStandard Yield Curves2MDCODEMarket Data Areanvarchar40
54/BA1/TF4_STRTGYDefinition of Read Strategy2MDCODEMarket Data Areanvarchar40
55/BA1/TF4_STRTGYTDefinition of Price Symbols3MDCODEMarket Data Areanvarchar40
56/BA1/TF4_SYCGRIDStandard Yield Curves: Grid Points for Reference Int. Rates2MDCODEMarket Data Areanvarchar40
57/BA1/TF4_UNITDefinition of Exchange Rate Units2MDCODEMarket Data Areanvarchar40
58/BA1/TF4_UNITTDefinition of Price Symbols3MDCODEMarket Data Areanvarchar40
59/BA1/TF4_VCLUSVolatility Cluster2MDCODEMarket Data Areanvarchar40
60/BA1/TF4_VTYPVolatility Types2MDCODEMarket Data Areanvarchar40
61/BA1/TF4_VTYPTText Table for Volatility Types3MDCODEMarket Data Areanvarchar40
62/BA1/TF4_YCRPLMTYield Curve Replacement2MDCODEMarket Data Areanvarchar40
63/BA1/TF4_YCTYPEYield Curve Types2MDCODEMarket Data Areanvarchar40
64/BA1/TF4_YCTYPETYield Curve Types: Name (Language-Dependent)3MDCODEMarket Data Areanvarchar40
65/BA1/TF4_YCURVEYield Curves: General Properties2MDCODEMarket Data Areanvarchar40
TOPMulti Currency Accounting
66GLE_MCA_RV_HSTRYFX Revaluation History15MDCODEMarket Data Areanvarchar40