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

28 columns | Print definition?ERP 6.0  | MSGCLASS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClaims Management
1TICL130Tables of Claim System11MSGCLASSApplication Areanvarchar200
TOPClinical System
2N1ABWMSGIS-H*MED: Assignment of service/check/message11MSGCLASSMessage Classnvarchar200
TOPCross-Application Components
3CCMSBI_THRH_VALTime-Dependent Threshold Values17MSGCLASSXMI logging: company name of external management toolnvarchar160
TOPDatabase Monitors
4ALLAZYMT2ALERTS NEXT GEN: NEW (>=4.6A) Database Monitoring Tree5MSGCLASSMessage Classnvarchar200
5INFCFGALRSINFCFGCHECK: temp. storing of alert results7MSGCLASSINFCFGCHECK: monit. attribute message class ('HH', ...)nvarchar200
TOPEnd User Technology
6RSZWMDPARAMCONSRBW Web Metadata: Parameter constraints14MSGCLASSApplication Areanvarchar200
TOPeXternal Management Interface Framework
7BAPIXMLOGRBAPI XMI: Logon information on actions of external mgt tools13MSGCLASSXMI logging: company name of external management toolnvarchar160
8TXMILOGRAWLog Information on Actions of External Management Tools13MSGCLASSXMI logging: company name of external management toolnvarchar160
9TXMIMSGTable for Lang.-Depend. Message Texts in XMI Log1MSGCLASSXMI logging: company name of external management toolnvarchar160
TOPMonitoring
10ALALERTDBAlert: alert database (general alert structure, raw message)31MSGCLASSXMI logging: company name of external management toolnvarchar160
11ALALERTXCCMS Monitoring: Cache for Alerts Already Read38MSGCLASSXMI logging: company name of external management toolnvarchar160
12ALDBSPERFCCMS Monitoring Arch.: Database Segment: Performance MTE19MSGCLASSXMI logging: company name of external management toolnvarchar160
13ALDBSSMESCCMS Monitoring Arch.: Database Segment: Status AttributeMTE14MSGCLASSXMI logging: company name of external management toolnvarchar160
14ALGRPCUSPFAlert: Group Customizing data performance class10MSGCLASSXMI logging: company name of external management toolnvarchar160
15ALMTCUSPERAlert: MT-specific Customizing Performance-Class18MSGCLASSXMI logging: company name of external management toolnvarchar160
16ALPFTHRHIST_TBPerformance Threshold History15MSGCLASSXMI logging: company name of external management toolnvarchar160
17ALTEXTDBHistory Database for text, status, and message nodes5MSGCLASSXMI logging: company name of external management toolnvarchar160
18CCMSBITHRHTime-Dependent MTE Threshold Values17MSGCLASSXMI logging: company name of external management toolnvarchar160
19CCMSBI_MTE_THRHTime-Dependent MTE Threshold Values17MSGCLASSXMI logging: company name of external management toolnvarchar160
20SCMC_NODE_MSCAdditional Attributes for Message Container Nodes29MSGCLASSXMI logging: company name of external management toolnvarchar160
21SCMC_NODE_PERFAdditional Attributes for Performance Nodes21MSGCLASSXMI logging: company name of external management toolnvarchar160
TOPPrint and Output Management
22TSPEVDEVOMS Events for Devices8MSGCLASSXMI logging: company name of external management toolnvarchar160
23TSPEVJOBOMS Events for Print Requests13MSGCLASSXMI logging: company name of external management toolnvarchar160
TOPProcess Monitoring Infrastructure
24SSPIMOALERTSPMI: Self-Monitoring, Table of Triggered Alerts29MSGCLASSXMI logging: company name of external management toolnvarchar160
TOPResourcen Management
25RMSAC_STATMSGSeverity of Message Errors2MSGCLASSApplication Log: Message class, message IDnvarchar200
TOPSAP Utilities
26ESMON_MSGBOMonitoring Mass Run: Business Objects in Messages1MSGCLASSApplication Areanvarchar200
TOPService Data Download
27/SDF/CMO_T_21BCMO Service: Message Classes1MSGCLASSMessage Classnvarchar200
28/SDF/CMO_T_21CCMO Service: Most Frequent Transport Errors1MSGCLASSMessage Classnvarchar200