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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
Basis Components :: Exchange Infrastructure :: Integration Server :: Integration Engine
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SXMSMSGREF276Message Reference StorageIntegration Engine
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, MESSAGE_ID, JOB_ID, QUEUE_ID, PID, SENDER, SND_PARTY, SND_PARTY_SCHEME, SND_NAME, SND_NAMESPACE, RECEIVER, RCV_PARTY, RCV_PARTY_SCHEME, RCV_NAME, RCV_NAMESPACE, MSG_SIZE, QOS, STATUS, START_VERSION, FILTERGUID, BRANCH, PROCESSID, PACKAGE_X, PACKTIME, FILTER_TYPE, COMMIT_ACTOR, QUEUE FROM SXMSMSGREF
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CLIENTClientnvarchar30 Allow NULL? 
2MESSAGE_IDXI: Message IDvarbinary160
3JOB_IDJob IDnvarchar320 Allow NULL? 
4QUEUE_IDID for Message Queuenvarchar320 Allow NULL? 
5PIDIntegration Engine: Pipeline IDnvarchar400 Allow NULL? 
6SENDERXI: Servicenvarchar600 Allow NULL? 
7SND_PARTYXI: Communication Partynvarchar600 Allow NULL? 
8SND_PARTY_SCHEMEXI Partner: Identification Schemanvarchar1200 Allow NULL? 
9SND_NAMEXI: Interface Namenvarchar1200 Allow NULL? 
10SND_NAMESPACEXI: Interface Namespacenvarchar2550 Allow NULL? 
11RECEIVERXI: Servicenvarchar600 Allow NULL? 
12RCV_PARTYXI: Communication Partynvarchar600 Allow NULL? 
13RCV_PARTY_SCHEMEXI Partner: Identification Schemanvarchar1200 Allow NULL? 
14RCV_NAMEXI: Interface Namenvarchar1200 Allow NULL? 
15RCV_NAMESPACEXI: Interface Namespacenvarchar2550 Allow NULL? 
16MSG_SIZEint100 Allow NULL? 
17QOSIntegration Engine: Quality of Servicenvarchar40 Allow NULL? 
18STATUSJob Processing Statuschar10 Allow NULL? 
19START_VERSIONSequence Number for a Message Log IDnvarchar30 Allow NULL? 
20FILTERGUIDFilter IDvarbinary160
21BRANCHchar10 Allow NULL? 
22PROCESSIDProcess ID for Package Processingnvarchar320 Allow NULL? 
23PACKAGE_XMessage Reference for Packagechar10 Allow NULL? 
24PACKTIMEUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
25FILTER_TYPEMessage Typechar10 Allow NULL? 
26COMMIT_ACTORchar10 Allow NULL? 
27QUEUEName of tRFC Queuenvarchar240 Allow NULL? 
NamePrimaryUniqueTypeColumns
SXMSMSGREF~0YesYesCLUSTEREDMESSAGE_ID, CLIENT
SXMSMSGREF~002NoNoNONCLUSTEREDQOS, STATUS, JOB_ID, CLIENT
SXMSMSGREF~003NoNoNONCLUSTEREDQUEUE_ID, CLIENT
SXMSMSGREF~004NoNoNONCLUSTEREDSTATUS, FILTERGUID, CLIENT
SXMSMSGREF~005NoNoNONCLUSTEREDSTATUS, PACKAGE_X, PROCESSID, CLIENT
SXMSMSGREF~006NoNoNONCLUSTEREDSTATUS, PACKTIME, CLIENT