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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components :: Basis Services Communication Interfaces :: Communication Services Mail, Fax, SMS, Telephony
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SXNODES321SAPconnect: Communication nodesCommunication Services Mail, Fax, SMS, Telephony
SQL:  selectupdate insert create

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

SELECT MANDT, NODE, COUNTRY, R_NODE, R_ADMIN, R3_SYSTEM, R3_CLIENT, DESCRIP, PREFERENCE, ACTIVE, RETRY_HOUR, RETRY_MIN, LSTCHGUSER, LSTCHGDATE, F_DO_MON, F_EXTFCTS, ES_VERSION, RFCDEST, NODE_TYPE, MAIL_HOST, MAIL_PORT, CODEPAGE, F_ESMTP, PASSWORD, ENCODING, RESPONSE_TYPE, RESPONSE_PATT, SMTPUSER, STARTTLS, HOSTMATCH, TRUSTCHECK, TLSIDENT FROM SXNODES
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2NODEName of SAPconnect Node or Telephony Servernvarchar60CHAR(N' ')NoSX_NODE_ID Allow NULL? 
3COUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
4R_NODEName of SAPconnect Node or Telephony Servernvarchar60CHAR(N' ')YesSXNODESSX_NODE_ID Allow NULL? 
5R_ADMINRML Name (Remote Mail, SAP - SAP - Communication)nvarchar120CHAR(N' ')YesAD_UNAME Allow NULL? 
6R3_SYSTEMName of SAP Systemnvarchar80CHAR(N' ')YesSYSYSID Allow NULL? 
7R3_CLIENTClientnvarchar30CLNT(N'000')Yes*MANDT Allow NULL? 
8DESCRIPCommentnvarchar500CHAR(N' ')YesCHAR50 Allow NULL? 
9PREFERENCENode Can Resolve Path Referencechar10CHAR(N' ')YesSX_PREF Allow NULL? 
10ACTIVESAPconnect: Node is ready for usechar10CHAR(N' ')YesSX_ACTIVE Allow NULL? 
11RETRY_HOURSAPconnect: Maximum Repetition Time (hours)nvarchar30NUMC(N'000')YesSXRETRYHOU Allow NULL? 
12RETRY_MINSAPconnect: Maximum Repetition Time (Minutes)nvarchar30NUMC(N'000')YesSXRETRYMIN Allow NULL? 
13LSTCHGUSERLast Changed bynvarchar120CHAR(N' ')YesAS4USER Allow NULL? 
14LSTCHGDATEDate of Last Changenvarchar80DATS(N'00000000')YesAS4DATE Allow NULL? 
15F_DO_MONNode/server is to be monitored by the alert monitorchar10CHAR(N' ')YesF_DO_MON Allow NULL? 
16F_EXTFCTSNode supports extended functions (as of 4.5B)char10CHAR(N' ')YesF_EXTFCTS Allow NULL? 
17ES_VERSIONSAPconnect: Version number of external server softwarenvarchar80CHAR(N' ')YesSX_VERSION Allow NULL? 
18RFCDESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')YesRFCDESRFCDEST Allow NULL? 
19NODE_TYPESAPconnect: Node Type (RFC,SMTP)char10CHAR(N' ')YesSX_NODETYP Allow NULL? 
20MAIL_HOSTSAPconnect: Host Name of Mail MTAnvarchar1000CHAR(N' ')YesSX_MLHOST Allow NULL? 
21MAIL_PORTSAPconnect: Port Number of Mail MTAnvarchar320CHAR(N' ')YesSX_MLPORT Allow NULL? 
22CODEPAGESAP Character Set IDnvarchar40NUMC(N'0000')YesTCP00CPCODEPAGE Allow NULL? 
23F_ESMTPSAPconnect: Node Supports ESMTPchar10CHAR(N' ')YesSX_ESMTP Allow NULL? 
24PASSWORDSAPconnect: Passwordnvarchar200CHAR(N' ')YesSX_PASSWRD Allow NULL? 
25ENCODINGSAPconnect: Coding Procedure for Message Textchar10CHAR(N' ')YesSX_ENCODING Allow NULL? 
26RESPONSE_TYPESAPconnect: Type of Confirmation (Successful, with Errors)char10CHAR(N' ')YesSX_RSPTYPE Allow NULL? 
27RESPONSE_PATTSAPconnect: Text Pattern in a Confirmationnvarchar800CHAR(N' ')YesSX_RSPPATT Allow NULL? 
28SMTPUSERUser Namenvarchar400CHAR(N' ')YesSX_USER Allow NULL? 
29STARTTLSTransport Layer Security (TLS)char10NUMC(N'0')YesSX_STARTTLS Allow NULL? 
30HOSTMATCHTLS: Check Host Name of Server Certificatechar10CHAR(N' ')YesSX_HOSTMATCH Allow NULL? 
31TRUSTCHECKTLS: Check Server Certificatechar10CHAR(N' ')YesSX_TRUSTCHECK Allow NULL? 
32TLSIDENTClient Identitynvarchar60CHAR(N' ')YesSX_TLSIDENT Allow NULL? 
NamePrimaryUniqueTypeColumns
SXNODES~0YesYesCLUSTEREDNODE, MANDT