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

52 columns | Print definition?ERP 6.0  | OPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5FDSNCONDIDSN: Definitions of conditions9OPERABAP: Selection option operatornvarchar80
2T77PAYKZTSTime Schedule Report Customizing Table4OPERTime Schedule Report - Cross Operationnvarchar10
3T7RUTSTime Scedule Report Customizing Table4OPERTime Schedule Report - Cross Operationnvarchar10
4TSFSTStorage for Search Terms3OPERBoolean Valuenvarchar10
TOPBalanced Scorecard
5UMB_MC101Scorecard: Characteristics for the Value Fields of a Measure16OPERSelection operand (EQ, NE, .....)nvarchar20
6UMB_MC107Scorecard: BW Variables for the Value Fields of a Measure14OPERSelection operand (EQ, NE, .....)nvarchar20
7UMB_SC102Scorecard: Value Definition of the CPM Variable7OPERSelection operand (EQ, NE, .....)nvarchar20
8UMB_SC107Scorecard: BIC Selections10OPERType of OPTION component in row type of a Ranges typenvarchar20
9UMB_SC108Scorecard: Perspectives : BIC Selections11OPERType of OPTION component in row type of a Ranges typenvarchar20
10UMB_SC121Scorecard: Strategy: BIC Selection11OPERType of OPTION component in row type of a Ranges typenvarchar20
11UMB_SC152Scorecard: Objective: BIC Selections11OPERType of OPTION component in row type of a Ranges typenvarchar20
12UMB_SC166Scorecard: Measures: BIC Selections11OPERType of OPTION component in row type of a Ranges typenvarchar20
13UMB_SC190Scorecard: Initiatives: BIC Selections11OPERType of OPTION component in row type of a Ranges typenvarchar20
14UMB_SC194Scorecard: Characteristics for BW Key Figs of an Initiative14OPERSelection operand (EQ, NE, .....)nvarchar20
15UMB_SC196Scorecard: BW Variables for Value Fields of an Initiative14OPERSelection operand (EQ, NE, .....)nvarchar20
TOPBasic Functions
16EMMAC_CCAT_MSGMessage Pool for Case Category6OPERCheck Appearance of Messagenvarchar10
TOPCorporate Performance Monitor
17UMC_RSTRCTRestrictions5OPERSelection operand (EQ, NE, .....)nvarchar20
18UMC_UN100Notification12OPEROperandnvarchar20
19UMK_BU101Total Float5OPERSelection operand (EQ, NE, .....)nvarchar20
20UMR_RF101RMS: Measure-Risk Value Fields Selection Criteria19OPERSelection operand (EQ, NE, .....)nvarchar20
21UMR_RF103RMS: Measure-Risk Value Fields BW Variables17OPERSelection operand (EQ, NE, .....)nvarchar20
22UMR_RI117RMS: Measure Weight Data Selection - Selections - NOT USED16OPERSelection operand (EQ, NE, .....)nvarchar20
23UMV_TR102Value Driver Tree: Selections of the CPM Variables7OPERSelection operand (EQ, NE, .....)nvarchar20
24UMV_TR104Value Driver Tree: Value Combinations of Runtime Variables7OPERSelection operand (EQ, NE, .....)nvarchar20
25UMV_TR108Value Driver Tree: Versions of Value Fields for Simulation7OPERSelection operand (EQ, NE, .....)nvarchar20
26UMV_TR113Obsolete: Value Driver Tree: Selections for the Value Fields16OPERSelection operand (EQ, NE, .....)nvarchar20
27UMV_TR114Obsolete:Value Driver Tree: BIC Selections for Value Drivers11OPERType of OPTION component in row type of a Ranges typenvarchar20
28UMV_TR117Obsolete: Value Driver Tree: BW Variables for Value Fields12OPERSelection operand (EQ, NE, .....)nvarchar20
29UMV_TR213Value Driver Tree: Selections for the Value Fields16OPERSelection operand (EQ, NE, .....)nvarchar20
30UMV_TR214Value Driver Tree: BIC Selections for Measures11OPERType of OPTION component in row type of a Ranges typenvarchar20
31UMV_TR217Value Driver Tree: BW Variables for Value Fields12OPERSelection operand (EQ, NE, .....)nvarchar20
TOPFrance
32T5F2HExtension of payroll period calculation methods8OPEROperator for data calculationnvarchar40
TOPItaly
33T5ITI5Rules for the determination of work and absence days9OPEROperatornvarchar20
TOPManagement Cockpit
34UMM_BU100Obsolete: Selections for Buffer of Transaction Data7OPERSelection operand (EQ, NE, .....)nvarchar20
35UMM_BU103Obsolete: Selections for Buffer of Transaction Data7OPERSelection operand (EQ, NE, .....)nvarchar20
36UMM_BU106Selections for Buffer of Transaction Data7OPERSelection operand (EQ, NE, .....)nvarchar20
37UMM_CO102Cockpits: Assignment of Variables with Selection Conditions12OPERSelection operand (EQ, NE, .....)nvarchar20
38UMM_COBUFCockpit BW Buffer Case Number (For Runtime Variable)7OPERSelection operand (EQ, NE, .....)nvarchar20
39UMM_FR101Frames: Dimensions14OPERSelection operand (EQ, NE, .....)nvarchar20
40UMM_FR115Frame: Replacement of BW Variables13OPERSelection operand (EQ, NE, .....)nvarchar20
41UMM_FR118Frame: BIC Selections10OPERType of OPTION component in row type of a Ranges typenvarchar20
42UMM_LG100Selections for Log of Transaction Data Buffer6OPERSelection operand (EQ, NE, .....)nvarchar20
43UMM_ST101Selections for Status of the Frames in the Cockpits9OPERSelection operand (EQ, NE, .....)nvarchar20
44UMM_VA103Variables: Proposed Selections6OPERSelection operand (EQ, NE, .....)nvarchar20
TOPPayroll
45T7ROG1EE register - ER history29OPERSingle-Character Indicatornvarchar10
46T7ROG2EE register - EE history20OPERSingle-Character Indicatornvarchar10
47T7ROG3EE register - EE history24OPERSingle-Character Indicatornvarchar10
48T7ROG6EE register - EE history25OPERSingle-Character Indicatornvarchar10
TOPReuse Services for Country Development
49T5F99FCForms: Conditions10OPERABAP: Selection option operatornvarchar80
TOPService Data Download
50/SOMO/DOCSTASCHScheduling table for document volume statistics6OPERnvarchar30
TOPSpain
51T5E25Operations for contract type change2OPERContract category change operationnvarchar20
52T5E25TOperation texts for contract category change3OPERContract category change operationnvarchar20