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

68 columns | Print definition?ERP 6.0  | SELNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBalanced Scorecard
1UMB_MC101Scorecard: Characteristics for the Value Fields of a Measure6SELNOSelection numbernvarchar20
2UMB_MC107Scorecard: BW Variables for the Value Fields of a Measure7SELNOSelection numbernvarchar20
3UMB_SC102Scorecard: Value Definition of the CPM Variable4SELNOSelection numbernvarchar20
4UMB_SC107Scorecard: BIC Selections3SELNOSelection numbernvarchar20
5UMB_SC108Scorecard: Perspectives : BIC Selections4SELNOSelection numbernvarchar20
6UMB_SC109Scorecard: Perspectives: Assigned BW Queries4SELNOSelection numbernvarchar20
7UMB_SC111Scorecard: Assigned BW Queries3SELNOSelection numbernvarchar20
8UMB_SC121Scorecard: Strategy: BIC Selection4SELNOSelection numbernvarchar20
9UMB_SC122Scorecard: Strategies: Assigned BW Queries4SELNOSelection numbernvarchar20
10UMB_SC152Scorecard: Objective: BIC Selections4SELNOSelection numbernvarchar20
11UMB_SC153Scorecard: Objective: Assigned BW Queries4SELNOSelection numbernvarchar20
12UMB_SC166Scorecard: Measures: BIC Selections4SELNOSelection numbernvarchar20
13UMB_SC167Scorecard: Measures: BPS Link4SELNOSelection numbernvarchar20
14UMB_SC168Scorecard: Measures: Assigned BW Queries4SELNOSelection numbernvarchar20
15UMB_SC171Scorecard: BW Web Report (Obsolete)6SELNOSelection numbernvarchar20
16UMB_SC172Scorecard: URL (Obsolete)6SELNOSelection numbernvarchar20
17UMB_SC173Scorecard: BW Web Report6SELNOSelection numbernvarchar20
18UMB_SC174Scorecard: URL6SELNOSelection numbernvarchar20
19UMB_SC190Scorecard: Initiatives: BIC Selections4SELNOSelection numbernvarchar20
20UMB_SC191Scorecard: Initiatives: BPS Links4SELNOSelection numbernvarchar20
21UMB_SC192Scorecard: Initiatives: Assigned BW Queries4SELNOSelection numbernvarchar20
22UMB_SC194Scorecard: Characteristics for BW Key Figs of an Initiative6SELNOSelection numbernvarchar20
23UMB_SC196Scorecard: BW Variables for Value Fields of an Initiative7SELNOSelection numbernvarchar20
TOPCorporate Performance Monitor
24UMC_RSTRCTRestrictions3SELNOSelection numbernvarchar20
25UMK_BU101Total Float3SELNOSelection numbernvarchar20
26UMK_MB140URL Assignment4SELNOSelection numbernvarchar20
27UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria9SELNOSelection numbernvarchar20
28UMR_RF103RMS: Measure-Risk Value Fields BW Variables10SELNOSelection numbernvarchar20
29UMR_RI117RMS: Measure Weight Data Selection - Selections - NOT USED6SELNOSelection numbernvarchar20
30UMR_RI200RMS: Assigned BW Queries7SELNOSelection numbernvarchar20
31UMR_RI201RMS: BW Web Report7SELNOSelection numbernvarchar20
32UMR_RI202RMS: URL7SELNOSelection numbernvarchar20
33UMV_TR102Value Driver Tree: Selections of the CPM Variables4SELNOSelection numbernvarchar20
34UMV_TR104Value Driver Tree: Value Combinations of Runtime Variables5SELNOSelection numbernvarchar20
35UMV_TR105Value Driver Tree: Assignment of BPS Characteristics4SELNOSelection numbernvarchar20
36UMV_TR108Value Driver Tree: Versions of Value Fields for Simulation4SELNOSelection numbernvarchar20
37UMV_TR113Obsolete: Value Driver Tree: Selections for the Value Fields6SELNOSelection numbernvarchar20
38UMV_TR114Obsolete:Value Driver Tree: BIC Selections for Value Drivers4SELNOSelection numbernvarchar20
39UMV_TR115Obsolete:Val.Driver Tree:BW Queries and Workbooks of Drivers4SELNOSelection numbernvarchar20
40UMV_TR117Obsolete: Value Driver Tree: BW Variables for Value Fields7SELNOSelection numbernvarchar20
41UMV_TR125Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers5SELNOSelection numbernvarchar20
42UMV_TR126Obsolete: Frame: URL5SELNOSelection numbernvarchar20
43UMV_TR213Value Driver Tree: Selections for the Value Fields6SELNOSelection numbernvarchar20
44UMV_TR214Value Driver Tree: BIC Selections for Measures4SELNOSelection numbernvarchar20
45UMV_TR215Value Driver Tree: BW Queries and Workbooks for Measures4SELNOSelection numbernvarchar20
46UMV_TR217Value Driver Tree: BW Variables for Value Fields7SELNOSelection numbernvarchar20
47UMV_TR218Value Driver Tree: Assignment of BPS Functions to Measures4SELNOSelection numbernvarchar20
48UMV_TR225Value Driver Tree: Assignment of web Reports to Measures5SELNOSelection numbernvarchar20
49UMV_TR226Value Driver Tree: Assignment of URLs to Measures5SELNOSelection numbernvarchar20
TOPManagement Cockpit
50UMM_BU100Obsolete: Selections for Buffer of Transaction Data5SELNOSelection numbernvarchar20
51UMM_BU103Obsolete: Selections for Buffer of Transaction Data5SELNOSelection numbernvarchar20
52UMM_BU106Selections for Buffer of Transaction Data5SELNOSelection numbernvarchar20
53UMM_CO102Cockpits: Assignment of Variables with Selection Conditions7SELNOSelection numbernvarchar20
54UMM_DFT_BICDATADefault BIC Data for Frame7SELNOCount parametersnvarchar40
55UMM_DFT_CHARTDefault BW Data for Cockpit Frame7SELNOCount parametersnvarchar40
56UMM_DFT_LABELDefault Chart Unit for Frame Graphics7SELNOCount parametersnvarchar40
57UMM_DFT_LEGDATADefault Legacy Data for Frame BW Data7SELNOCount parametersnvarchar40
58UMM_DFT_LEGSTUCTable: Default Legacy Structure for Cockpit7SELNOCount parametersnvarchar40
59UMM_DFT_Q_RANGEDefault Value Range for 4 Quadrants7SELNOCount parametersnvarchar40
60UMM_DFT_T_RANGEDefault Value Range for Tachometer7SELNOCount parametersnvarchar40
61UMM_FR101Frames: Dimensions5SELNOSelection numbernvarchar20
62UMM_FR115Frame: Replacement of BW Variables6SELNOSelection numbernvarchar20
63UMM_FR116Frame Web Report3SELNOSelection numbernvarchar20
64UMM_FR118Frame: BIC Selections3SELNOSelection numbernvarchar20
65UMM_FR121Frame: URL4SELNOSelection numbernvarchar20
66UMM_LG100Selections for Log of Transaction Data Buffer4SELNOSelection numbernvarchar20
67UMM_ST101Selections for Status of the Frames in the Cockpits7SELNOSelection numbernvarchar20
68UMM_VA103Variables: Proposed Selections4SELNOSelection numbernvarchar20