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

51 columns | Print definition?ERP 6.0  | MSG_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_TRACE_LVAIF trace level definition4MSG_TYPEMessage Typenvarchar10
2/GSINS/NLG_ADF_CGBA Interface: Outgoing Message Body Customizing2MSG_TYPEMessage Typenvarchar40
3/GSINS/NLG_ADH_CGBA Interface: Outgoing Message Header Customizing2MSG_TYPEMessage Typenvarchar40
4/GSINS/NLG_ADH_TGBA Interface: Outgoing Message Header Customizing(texts)2MSG_TYPEMessage Typenvarchar40
5/GSINS/NLG_INAGBA Interface: Incoming Message Header7MSG_TYPEMessage Typenvarchar40
6/GSINS/NLG_MST_CGBA Interface: Message Types2MSG_TYPEMessage Typenvarchar40
7/GSINS/NLG_MST_TGBA Interface: Message Types(texts)2MSG_TYPEMessage Typenvarchar40
8/GSINS/NLG_OUTAGBA Interface: Outgoing Message Header4MSG_TYPEMessage Typenvarchar40
9/SAPPSSRM/THMSGMessage Types for Threshold Check4MSG_TYPEMessage Typenvarchar10
10/SLCE/SMW3_BDOCBDoc Message Store: Header9MSG_TYPESingle-Character Indicatornvarchar10
11BBPD_APPL_ATLAssign Attributes to EBP Applications4MSG_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
12CMCBC_PC_TOLERAtolerance limit of payment control rule4MSG_TYPEMessage Typenvarchar10
13GRFNMWRTMSGLGMSMP Runtime - Instance Execution Message Log14MSG_TYPEMSMP Message Log Entry Typenvarchar20
14PIQDB_NL_DUOILOGDUO Incoming Message Error Log Table4MSG_TYPEDUO Message Typenvarchar80
15PIQDB_NL_DUOMSGDUO Messages7MSG_TYPEDUO Message Typenvarchar80
16PIQDB_NL_OELDuo Outgoing Error Message4MSG_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
17RSBPC_EN_BCSPOA SBC E&N BCS Send Document Fields5MSG_TYPEMessage Typenvarchar10
18T7PIQ_NL_STR_TYMaintain the active struture (Obselete Not to be used!)2MSG_TYPEDUO Message Typenvarchar80
19T7PIQ_NL_STR_TYPMaintain the Active Struture for BRON-HO Messages1MSG_TYPEDUO Message Typenvarchar80
20TRF_DOC_ERR_MSGFiori Transfer Stock Document Error Messages4MSG_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
21WGDS_C_MSG_TYPEMessage Types2MSG_TYPEMessage Typenvarchar30
22WGDS_C_MSG_TYP_TText table of message types2MSG_TYPEMessage Typenvarchar30
23WGDS_D_MSG_HDRHeader information of a message3MSG_TYPEMessage Typenvarchar30
TOPAuthoring Environment
24LSO_CPT_PROGRESSInformation on Running Publishing Activities12MSG_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
TOPCollaborative Cross Applications
25/POA/D_EN_BCSPOA SBC E&N BCS Send Document Fields5MSG_TYPEMessage Typenvarchar10
TOPCollateral Management System
26TCMS_PCN_A_MSGMessage sverity change for business activity9MSG_TYPEMessage Typenvarchar10
27TCMS_PCN_PLMSGMessages associated to Plausibility5MSG_TYPEMessage Typenvarchar10
TOPCommunication
28TNHCF_OB_PRXMHCF: Properties of Outbound Proxy Methods6MSG_TYPEMessage Type of a Proxy Methodnvarchar300
TOPContract Accounts Receivable and Payable
29DFK_JC_CNTR_MSGMessages for Background Processing7MSG_TYPEMessage Typenvarchar10
TOPDB2 Universal Database for UNIX NT
30DB6_BW_HEALTHDB6: Results of BW Health Checks4MSG_TYPEnvarchar10
TOPDSD Connector
31/DSD/ME_MAP_RULEDSD-Connector: Define Mapping Rules4MSG_TYPEDSD Connector: Message Typenvarchar300
32/DSD/ME_MSG_HDDSD CN: Message header data7MSG_TYPEMessage Typenvarchar300
TOPeCATT Extended Computer Aided Test Tool
33ECVO_BUS_MSGeCATT Table for Validation Object Business Messages8MSG_TYPEBusiness Message Typenvarchar40
TOPExcise Duty
34/BEV2/CS_MSGEMCS Process: Messages6MSG_TYPEEMCS Process: Message Typenvarchar10
TOPFinancial Supply Chain Management
35EDX_TRACEEDX: Trace8MSG_TYPEEDX: Logging, Message Typenvarchar200
TOPFunds Management
36FMARCINFOMessages of initial archiving run RFFM_FMARC13MSG_TYPETwo digit numbernvarchar20
TOPHydrocarbon Product Management
37OIB_MIGO_HQCI_EStore the QCI-GOITEM-Bapiret for MIGOs hold/restore feature4MSG_TYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
TOPIntegration Engine
38SXMS_SCOPYWS/XI Log Table for System Copy5MSG_TYPESingle-Character Indicatornvarchar10
TOPMaintenance Orders
39/MRSS/C_ALERTSAssignment of Alert Types and Messages6MSG_TYPEMessage typenvarchar10
40/MRSS/C_OPT_MSGCustomizing for individual error level of optimizer messages4MSG_TYPEMessage typenvarchar10
TOPMobile Applications
41/ISDFPS/EHMSGHDRError Correction Framework6MSG_TYPEMessage Typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
42NNL_DDS_RMDeklaration Ergebnis Meldungen6MSG_TYPEDeklaration dataset meldung typnvarchar10
43NNL_DDS_RMLDeklaration Ergebnis meldung kopf7MSG_TYPEDeklaration dataset meldung typnvarchar10
TOPService Data Download
44/BDL/TASK_LOGMessageLog of SDCC task manager9MSG_TYPENot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPTest Organizer
45ISSUE_ATTRIBIssue Managment: Message Attributes3MSG_TYPEIssue Management: Message Typenvarchar60
46ISSUE_RELATIONIssue Management: Relationship Table (Project, Issue)3MSG_TYPESingle-Character Indicatornvarchar10
TOPTraders and Schedulers Workbench
47TOI0_CP_GRATRAssign Compatibility group with compatibility attributes9MSG_TYPEMessage Typenvarchar10
TOPTransaction Manager
48TCORFTS_FORMATFormats2MSG_TYPEMessage typenvarchar10
TOPWeb Screen Tools - ABAP
49WDY_WB_VD_CHECKContains UI Element Info and Error Info for View Checker5MSG_TYPEMessage Typenvarchar10
TOPWorkforce Management Application
50WFACS_REQMSGSrequest messages: warnings, errors, etc5MSG_TYPEmessage typesmallint50
TOPWorkforce Management Core
51WFDCS_REQMSGSrequest messages: warnings, errors, etc5MSG_TYPEmessage typesmallint50