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

41 columns | Print definition?ERP 6.0  | MSGTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P05TPRNL_PR_RSPMPension Return: PR - Output Data - Response Data - Messages6MSGTYPEMessage Typenvarchar10
2PIQDB_NL_DUOINERTable for storing errors of incoming messages in BRONHO4MSGTYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
3TWFQUWorkflow: General settings13MSGTYPEWorkflow: Message typenvarchar80
4ZZMSGMessages from CATTs4MSGTYPENachrichtentypnvarchar10
5PIQDB_NL_ERRLOGError log table for Incoming messages9MSGTYPEMessage Typenvarchar10
TOPClient-System Adapter
6MDMEXTRHEADMDM Header Table for Extraktor Metadata4MSGTYPEMDM Extraction Object: Message Typenvarchar10
7MDM_OBJECT_IDMDM: Storage of Sent Object IDs3MSGTYPEMDM Extraction Object: Message Typenvarchar10
TOPDistributed System Landscape
8/ISDFPS/XI_FILTXI Filter for Prioritized Message Dispatch3MSGTYPEXI: Interface Namenvarchar1200
TOPDocument Management Framework
9SKWF_LOGLogging Table4MSGTYPEMessage Typenvarchar10
TOPEnd User Technology
10RSZWMDPARAMCONSRBW Web Metadata: Parameter constraints13MSGTYPESingle-Character Indicatornvarchar10
TOPEnvironment, Health and Safety
11/TDAG/RCSW_MSGMessages REACH Compliance1MSGTYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
TOPIncentive and Commission Management ICM
12TCACS_MSGFilter for Message Types (Message Control)3MSGTYPEMessage Typenvarchar10
13TCACS_MSG_TCommissions: Message Types4MSGTYPEMessage Typenvarchar10
TOPIntegration Engine
14SXMSINTERFACESender/Receiver Definition10MSGTYPEMessage Typenvarchar10
15SXMSMSGDEFMessage Definition9MSGTYPEMessage Typenvarchar10
16SXMSPHISTXML Message Broker: History4MSGTYPEIntegration Engine: Message Typenvarchar10
17SXMSPHIST2XML Message Broker: History (Switch Table)4MSGTYPEIntegration Engine: Message Typenvarchar10
18SXMSPMASTIntegration Engine: Message Queue (Master)4MSGTYPEIntegration Engine: Message Typenvarchar10
19SXMSPMAST2XML Message Broker: Message Queue (Master) (Switch Table)4MSGTYPEIntegration Engine: Message Typenvarchar10
TOPMaintenance Orders
20/MRSS/D_ALERTSAlerts5MSGTYPEMessage Typenvarchar10
TOPMexico
21PMX_MAXWWHOURSHCM Mexico CE: Maximum weekly working hours2MSGTYPEStandard message typenvarchar10
TOPMobile Applications
22/ISDFPS/RCR_LISTList of Messages: Receiver6MSGTYPEMessage Typenvarchar10
TOPOLAP Technology
23RSR_CACHE_LOGOLAP Cache Table for Saving Log Entries6MSGTYPEMessage Typenvarchar10
TOPPerformance Assessment Workbench
24SLS_QPROTPAW - Batch Qualification Generation Protocol12MSGTYPEPAW - Message Type (for protocol)nvarchar10
TOPProduct Safety
25CCRCC_ERRMAILEHS: Specify Recipients for Error Messages7MSGTYPEMessage Typenvarchar10
26CCRCC_LIMITSEHS: Relative Quantity Restriction5MSGTYPEMessage Typenvarchar10
27CCRCT_EHS_SLIMITEHS: Limit Values in Substance (EH&S Data)6MSGTYPEMessage Typenvarchar10
TOPResourcen Management
28RMSAC_STATMSGSeverity of Message Errors4MSGTYPEApplication Log: Message type (A,E,W,I,S)nvarchar10
TOPSAP Business Partner
29MDMEXTRHEAD_PREFMDM Header Table Extractor Metadata (Copy)4MSGTYPEMDM Extraction Object: Message Typenvarchar10
TOPSAP Business Workflow
30SWWLOGHISTWorkflow Runtime: History of a Work Item16MSGTYPEMessage Typenvarchar10
TOPSAP NetWeaver Mobile - Use subcomponents
31BWAFCCMSWAF: General Log from PDA12MSGTYPEMessage Typenvarchar10
32MECLIENTLOGCCMS: Log Entries of Clients12MSGTYPEMessage Typenvarchar10
33MECLIENTTRACECCMS: Trace Entries of the Clients12MSGTYPEMessage Typenvarchar10
34MEREP_208Replicator Run Control22MSGTYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
35MEREP_604Log Message Table5MSGTYPEMessage Type for Logsnvarchar10
36MEREP_UCLOGLog to keep track of status of data tables7MSGTYPEMessage Type for Logsnvarchar10
37MESYHEADMobile Engine: Header for Synchronization Container10MSGTYPEMessage Typenvarchar10
38MESYHEADDMobile Engine: Header for Synchronization Container10MSGTYPEMessage Typenvarchar10
TOPSCM Basis
39CAVEIBDOCCAVE: Inbound Document Processing10MSGTYPEMessage type: S Success, E Error, W Warning, I Info, A Abortnvarchar10
TOPWorkbench Utilities
40APAFOREIGNObsolete5MSGTYPEObsoletenvarchar10
41APARELAObsolete3MSGTYPEObsoletenvarchar10