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

32 columns | Print definition?ERP 6.0  | MSGTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X034Notification Process Configuration14MSGTEXTNotification Text Namenvarchar700
2/OPT/Y034Notification Process Configuration14MSGTEXTNotification Text Namenvarchar700
3/OPT/Z034Notification Process Configuration14MSGTEXTNotification Text Namenvarchar700
4CNV_MBT_WORD_LOGWorkinstruction: messages during report generation4MSGTEXTText Linenvarchar1320
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
5CRMRDTRMSGTexts of Messages of Syntax Checks (OBSOLETE)6MSGTEXTText of syntax error message (table TRMSG)nvarchar400
6CRM_CATT_MSGCATT Messages (prepared for Conversion in CHECKMAN)15MSGTEXTCheck resultnvarchar2550
7CRM_ECATT_MSGeCATT Messages (Prepared for Conversion in CHECKMAN)14MSGTEXTCheck resultnvarchar2550
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
8DCERRLISTDD: Tabelle für die Speicherung fehlerhafter DD-Objekte9MSGTEXTText der Meldungnvarchar1000
TOPBasic Data
9NCIFIS-HCM: Errored Inbound Messages in Original Format14MSGTEXTIS-HCM Text of Error Messagenvarchar800
TOPClinical System
10N1MESFOATi.s.h.med: Medication, Drug Message - Text4MSGTEXTMedication: Drug Message Textnvarchar1200
TOPDatabase Monitors
11INFCFGRESDDetail result table for Informix/OS check program14MSGTEXTDetail message text for checknvarchar800
12INFCFGRESMMaster result table for Informix/OS check program12MSGTEXTGlobal message text for check runnvarchar800
TOPeCATT Extended Computer Aided Test Tool
13ECLOG_FAIL_MSGGeneral Message Parts in FAILURE Object11MSGTEXTMessage Textntext10737418230
TOPeXternal Management Interface Framework
14BAPIXMLOGRBAPI XMI: Logon information on actions of external mgt tools23MSGTEXTActual text of messagenvarchar1280
15TXMILOGRAWLog Information on Actions of External Management Tools23MSGTEXTActual text of messagenvarchar1280
16TXMIMSGTable for Lang.-Depend. Message Texts in XMI Log4MSGTEXTActual text of messagenvarchar1280
TOPFinancial Accounting
17/OPT/T852Notification Process Configuration14MSGTEXTNotification Text Namenvarchar700
TOPMaster Data
18JGTAKTFSYSIS-M: Buffer Table for Activities in Non-SAP Systems (BP)15MSGTEXTText (100 characters)nvarchar1000
TOPMigration
19TEMUSERINFOMessages for IS-U Migration Workbench User3MSGTEXTMessage Text for Infonvarchar600
TOPMonitoring
20ALALERTDBAlert: alert database (general alert structure, raw message)41MSGTEXTActual text of messagenvarchar1280
21ALALERTXCCMS Monitoring: Cache for Alerts Already Read48MSGTEXTActual text of messagenvarchar1280
22ALDBSSMESCCMS Monitoring Arch.: Database Segment: Status AttributeMTE24MSGTEXTActual text of messagenvarchar1280
23ALTEXTDBHistory Database for text, status, and message nodes15MSGTEXTActual text of messagenvarchar1280
24SCMC_NODE_MSCAdditional Attributes for Message Container Nodes39MSGTEXTActual text of messagenvarchar1280
TOPPerformance Assessment Workbench
25SLS_QPROTPAW - Batch Qualification Generation Protocol13MSGTEXTPAW - Protocol Messagenvarchar720
TOPPrint and Output Management
26TSPEVDEVOMS Events for Devices18MSGTEXTActual text of messagenvarchar1280
27TSPEVJOBOMS Events for Print Requests23MSGTEXTActual text of messagenvarchar1280
TOPProcess Monitoring Infrastructure
28SSPIMOALERTSPMI: Self-Monitoring, Table of Triggered Alerts39MSGTEXTActual text of messagenvarchar1280
TOPReal Estate Management
29VIAK12Acct settlement error log12MSGTEXTMessage Textnvarchar730
TOPSyntax, Compiler, Runtime
30TRMSGSyntax Check Error Messages4MSGTEXTText of syntax error message (table TRMSG)nvarchar400
31TRMSGTSyntax Check Error Messages4MSGTEXTCHAR255 data element for SYSTnvarchar2550
TOPUSA
32BTXMESSBSI: Error Messages Entities2MSGTEXTBSI: Error messagenvarchar2500