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

47 columns | Print definition?ERP 6.0  | MESSAGE_V2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/LOGLogtabelle9MESSAGE_V2Nachrichtenvariablenvarchar500
2/IXOS/RSA_T_PROTTable: Protocol Table for Return Messages12MESSAGE_V2Message Variablenvarchar500
3/OPT/BAPIRET2Table to log ICC <-> SAP process errors12MESSAGE_V2Message Variablenvarchar500
4/XFT/DIOAIQ_HMESArchive: IQ History - Messages10MESSAGE_V2Message Variablenvarchar500
5/XFT/DIO_IQ_HMESIQ History - Messages10MESSAGE_V2Message Variablenvarchar500
6/XFT/SRM_REC35Process instance: Messages11MESSAGE_V2Message Variablenvarchar500
7EHPRCD_COD_CHKLCheck Log15MESSAGE_V2Message Variablenvarchar500
8PIQDB_NL_DUOINERTable for storing errors of incoming messages in BRONHO8MESSAGE_V2Message Variablenvarchar500
9PIQDB_NL_OELDuo Outgoing Error Message8MESSAGE_V2Message Variablenvarchar500
10TRF_DOC_ERR_MSGFiori Transfer Stock Document Error Messages11MESSAGE_V2Message Variablenvarchar500
11PIQDB_NL_ERRLOGError log table for Incoming messages13MESSAGE_V2Message Variablenvarchar500
TOPAccounting Interface
12GLE_ECS_ITEM_MSGECS: Error Messages for Error Correction Items8MESSAGE_V2Message Variablenvarchar500
TOPAMI Event Management
13EFDT_EXPR004FDT: Expression - No Action9MESSAGE_V2Message Variablenvarchar500
14EFDT_EXPR004AFDT: Expression - No Action9MESSAGE_V2Message Variablenvarchar500
15EFDT_EXPR004SFDT: Expression - No Action8MESSAGE_V2Message Variablenvarchar500
16EFDT_EXPR004TFDT: Expression - No Action8MESSAGE_V2Message Variablenvarchar500
TOPArchiveLink
17TOA_L03SAP ArchiveLink: Log table14MESSAGE_V2Message Variablenvarchar500
TOPAuthoring Environment
18LSO_CPT_PROGRESSInformation on Running Publishing Activities14MESSAGE_V2Message Variablenvarchar500
TOPBackground RFC bgRFC
19BGRFC_I_DEST_ERRError Messages for bgRFC Destinations in Inbound Case6MESSAGE_V2Message Variablenvarchar500
20BGRFC_O_DEST_ERRError Messages for bgRFC Outbound Destinations6MESSAGE_V2Message Variablenvarchar500
21QRFC_I_ERR_STATEInbound qRFC: Unit Error State6MESSAGE_V2Message Variablenvarchar500
22QRFC_O_ERR_STATEOutbound qRFC: Unit Error State6MESSAGE_V2Message Variablenvarchar500
23TRFC_I_ERR_STATEInbound tRFC: Unit Error Status6MESSAGE_V2Message Variablenvarchar500
24TRFC_O_ERR_STATEOutbound tRFC: Unit Error State6MESSAGE_V2Message Variablenvarchar500
TOPClient-System Adapter
25MDMFDBPRKeys and other attributes of feedback messages9MESSAGE_V2Message Variablenvarchar500
TOPContent Activation
26BSANLY_BCACT_LOGActivation Log for Content Bundles12MESSAGE_V2Message Variablenvarchar500
TOPCross-Application Components
27FRE_UI_MSGF&R CON R/3 - Exception Messages for User Interface13MESSAGE_V2Message Variablenvarchar500
TOPFunds Management
28FMSPLIT_APROF_AActions in Rule-Based Account Distributions Action Profile8MESSAGE_V2Application Log: Message variable 2nvarchar500
TOPGRC Process Control Plug-in
29/GRCPI/GRIAMSGAM - Execution Message (Temp Storage during execution)9MESSAGE_V2Message Variablenvarchar500
TOPIndustry Solution Catch Weight Management
30CON_FIN_WQ_MSGMessages on the Transactions in the Work Queue15MESSAGE_V2Message Variablenvarchar500
TOPLease Accounting
31/LSIERP/PROC_LOGPersistence for Payment Trigger Containing Errors20MESSAGE_V2Message Variablenvarchar500
TOPMass Load
32MDGD_OBJ_STATUSMDG Data Load Object Processing Status12MESSAGE_V2Message Variablenvarchar500
TOPMobile Applications
33/ISDFPS/EHMSGERRError Messages9MESSAGE_V2Message Variablenvarchar500
34/ISDFPS/ERR_LISTMBO Message: Errors List21MESSAGE_V2Message Variablenvarchar500
TOPPatient Accounting
35NCOP_MESSIS-H: Copayment - Messages for Posting Back with Partial Pyt19MESSAGE_V2Message Variablenvarchar500
TOPProduction and Revenue Accounting
36OIUT2_INT_MESSGObsolete: Ownership Interface Messages (Application/Tech.)13MESSAGE_V2Message Variablenvarchar500
37OIUXI_INT_MESSGOwnership Interface Messages (Application/Technical)13MESSAGE_V2Message Variablenvarchar500
38OIU_SB_AVEXexception/error for availability point8MESSAGE_V2Message Parameternvarchar500
TOPTravel Expenses
39PTRV_DOC_MESSTransfer Travel -> FI/CO: CO Replacements of TRV Receipt13MESSAGE_V2Message Variablenvarchar500
40PTRV_RPRPOSTDLog of Posting Program RPRPOSTD13MESSAGE_V2Message Variablenvarchar500
TOPUser and Authorization Management
41USZBVPROTCUA: Protocols of the Distribution of Users13MESSAGE_V2Message Variablenvarchar500
42USZBVPROTCCUA: Protocols of the Distribution of Company Addresses13MESSAGE_V2Message Variablenvarchar500
TOPWeb Service and SOAP - ABAP
43SRT_CFG_LOG_ITEMSRT Logging: Item Table15MESSAGE_V2Message Variablenvarchar500
44SRT_SOAM_CONNECTSOAManager Connectivity : Application data for distribution19MESSAGE_V2Message Variablenvarchar500
TOPWorkforce Management Application
45WFA_CALCSTMSGCalculation Status Messages9MESSAGE_V2Message Variablenvarchar500
46WFA_VIOLATIONViolations17MESSAGE_V2Message Variablenvarchar500
TOPWorkforce Management Core
47WFMCAS_CALCSTMSGCalculation Status Messages9MESSAGE_V2Message Variablenvarchar500