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

50 columns | Print definition?ERP 6.0  | MTMCNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCross-Application Components
1CCMSBI_BWPTR_CPHCPH/BI: Delta Management Table for Extraction of CPH Data21MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
2CCMSBI_CPH_BWPTRCPH/BW: Reader Pointer for the Extraction of CPH Data3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
3CCMSBI_CUSTDATATime-Dependent General MTE Data2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
4CCMSBI_METHODSTime-Dependent Reaction Methods2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
5CCMSBI_THRH_VALTime-Dependent Threshold Values2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
TOPDirectory
6LDAPGATEWLDAP Connector6MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
TOPMonitoring
7ALALERTDBAlert: alert database (general alert structure, raw message)9MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
8ALALERTXCCMS Monitoring: Cache for Alerts Already Read16MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
9ALALRTGUIDGUIDs for CCMS Alert IDs (for Alert Framework)9MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
10ALDBSMTECCMS Monitoring Arch.: Database Segment: General MTE Data2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
11ALDBSPERFCCMS Monitoring Arch.: Database Segment: Performance MTE2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
12ALDBSSMESCCMS Monitoring Arch.: Database Segment: Status AttributeMTE2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
13ALDBSTOOLCCMS Monitoring Arch.: Database Segment: MTE Method Data2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
14ALDWNTIMEDowntime of systems for availability calculations2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
15ALMBCDATACCMS Monitoring Cache: Data for "MTEs of one Class"3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
16ALMBRDATACCMS Monitoring Cache: Data for "MTEs of one Class"3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
17ALMONIDEFAlerts: Description of Monitor Definition Nodes13MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
18ALMTCUSGENAlert: MT-specific Customizing Class-independent2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
19ALMTCUSMSCAlert: MTE-specific Customizing: message container2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
20ALMTCUSPERAlert: MT-specific Customizing Performance-Class2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
21ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
22ALMTMSCFILAlert: MTE-Specific Message Container Filter2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
23ALPERFDBAlert: Performance database3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
24ALPERFDB_CAlert: Performance Database3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
25ALPERFOBAlert: Performance Database Object Part2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
26ALPFASSIGNAlert: Assignment of Reorg/Coll Schema to MTE (New Version)2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
27ALPFCOLLTIDTID List Created from ALPFREORG:Objects to Collect in PerfDB2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
28ALPFTHRHIST_RWSPerformance Threshold History: Number of Records2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
29ALPFTHRHIST_TBPerformance Threshold History2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
30ALTIDTOOLAlert: Assignment of tools to Tid2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
31ALXMBALERTPersistence Table for XMB Alert IDs3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
32CCMSBIDATATime-Dependent General MTE Data2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
33CCMSBIMETHTime-Dependent MTE Reaction Methods2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
34CCMSBITHRHTime-Dependent MTE Threshold Values2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
35CCMSBI_MTE_DATATime-Dependent General MTE Data2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
36CCMSBI_MTE_METHTime-Dependent MTE Reaction Methods2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
37CCMSBI_MTE_THRHTime-Dependent MTE Threshold Values2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
38CSMBK_SEMCSM_BK: Semantic and Token Definitions6MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
39CSMCENTOOLCCMS Monitoring: Container for Methods Started Centrally2MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
40SCMC_NODEBasic Data of Executed Monitors9MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
41SCMC_NODE_MSCAdditional Attributes for Message Container Nodes3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
42SCMC_NODE_PERFAdditional Attributes for Performance Nodes3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
43SCMC_NODE_SMESAdditional Attributes for Log Nodes3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
TOPProcess Monitoring Infrastructure
44SSPIMOALERTSPMI: Self-Monitoring, Table of Triggered Alerts12MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
TOPService Data Download
45/SDF/RZ20_TMPL_NTemplate Table for SDCC Component Download - Negative List4MTMCNAMEText, 40 Characters Longnvarchar400
46/SDF/RZ20_TMPL_PTemplate Table for SDCC Component Download - Positive List4MTMCNAMEText, 40 Characters Longnvarchar400
TOPWithout Description
47CCMSBIAVAILDOWNTIndividual Non-Availability Settings4MTMCNAMEText, 40 Characters Longnvarchar400
48CCMSBIAVLREPCFIndividual Reporting Settings: SLA Limits4MTMCNAMEText, 40 Characters Longnvarchar400
49CCMSBI_CPH_GUIDSGUIDs for Long MTE Name4MTMCNAMEAlert: Name of Monitoring Contextnvarchar400
50CCMSBI_GUIDS_CPHGUIDs for Long MTE Names (Extended)3MTMCNAMEAlert: Name of Monitoring Contextnvarchar400