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

23 columns | Print definition?ERP 6.0  | MSGNUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CLINKCustom Data Link22MSGNUMBERApplication log: Internal message serial numbernvarchar60
2CNVMBTPROCRESTRCNV MBT Process Type restriction message2MSGNUMBERApplication log: Internal message serial numbernvarchar60
3CNV_MBT_WORD_LOGWorkinstruction: messages during report generation2MSGNUMBERFour-digit numbernvarchar40
4CNV_PROTDOWN7MSGNUMBERApplication log: Internal message serial numbernvarchar60
5HRHAPCN_OBJ_LOGObject Library: Action Log - Additional Data5MSGNUMBERApplication log: Internal message serial numbernvarchar60
6HRHAPCN_OBJ_MSGObject Library: Additional Message6MSGNUMBERApplication log: Internal message serial numbernvarchar60
7PIQDB_NL_DUOINERTable for storing errors of incoming messages in BRONHO6MSGNUMBERMessage Numbernvarchar30
8PIQDB_NL_ERRLOGError log table for Incoming messages11MSGNUMBERMessage Numbernvarchar30
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
9CRMRDTRMSGTexts of Messages of Syntax Checks (OBSOLETE)5MSGNUMBERSyntax error message numbernvarchar40
TOPAMI Event Management
10EFDT_EXPR004FDT: Expression - No Action6MSGNUMBERMessage Numbernvarchar30
11EFDT_EXPR004AFDT: Expression - No Action6MSGNUMBERMessage Numbernvarchar30
12EFDT_EXPR004SFDT: Expression - No Action5MSGNUMBERMessage Numbernvarchar30
13EFDT_EXPR004TFDT: Expression - No Action5MSGNUMBERMessage Numbernvarchar30
TOPAppraisal, Valuation, and Survey Tool
14HRHAP_ACT_LOGAppraisal Document: Action Log - Additional Data4MSGNUMBERApplication log: Internal message serial numbernvarchar60
TOPBasis Application Log
15BALCApplication Log: Log or message context3MSGNUMBERApplication log: Internal message serial numbernvarchar60
16BALMApplication log: log message3MSGNUMBERApplication log: Internal message serial numbernvarchar60
17BALMPApplication log: message parameter3MSGNUMBERApplication log: Internal message serial numbernvarchar60
TOPFlexible Real Estate Management
18VICASTEPSTATUSStatus of Process Step16MSGNUMBERApplication Log: External IDnvarchar1000
TOPMigration
19VIMILOGOBJLog per Object (Errors Only)13MSGNUMBERApplication log: Internal message serial numbernvarchar60
20VIMITABSTATUSStatus per Table10MSGNUMBERApplication Log: External IDnvarchar1000
TOPSyntax, Compiler, Runtime
21SLIN_TRMSG_KEYConversion TRMSG Key + Prio ---> SLIN Key2MSGNUMBERSyntax error message numbernvarchar40
22TRMSGSyntax Check Error Messages3MSGNUMBERSyntax error message numbernvarchar40
23TRMSGTSyntax Check Error Messages3MSGNUMBERCHAR03 data element for SYSTnvarchar30