SXNODES SAP (SAPconnect: Communication nodes) Table details

Dictionary Type: Table
Description: SAPconnect: Communication nodes




ABAP Code to SELECT data from SXNODES
Related tables to SXNODES
Access table SXNODES




Table field list including key, data, relationships and ABAP select examples

SXNODES is a standard SAP Table which is used to store SAPconnect: Communication nodes data and is available within R/3 SAP systems depending on the version and release level.

The SXNODES table consists of various fields, each holding specific information or linking keys about SAPconnect: Communication nodes data available in SAP. These include NODE (Name of SAPconnect Node or Telephony Server), COUNTRY (Country Key), R_NODE (Name of SAPconnect Node or Telephony Server), R_ADMIN (RML Name (Remote Mail, SAP - SAP - Communication)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP SXNODES table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
NODEName of SAPconnect Node or Telephony Server SX_NODE_IDCHAR6SX_NODE_IDSXNSX_NODE_ID
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
R_NODEName of SAPconnect Node or Telephony Server SX_NODE_IDCHAR6SXNODESSX_NODE_IDSXNSX_NODE_ID
R_ADMINRML Name (Remote Mail, SAP - SAP - Communication) AD_UNAMECHAR12CHAR12
R3_SYSTEMName of SAP System SYSYSIDCHAR8SYCHAR08
R3_CLIENTClient MANDTCLNT3Assigned to domainMANDT
DESCRIPComment CHAR50CHAR50TEXT50
PREFERENCENode Can Resolve Path Reference SX_PREFCHAR1SX_BOOLEAN
ACTIVESAPconnect: Node is ready for use SX_ACTIVECHAR1SKONOFF
RETRY_HOURSAPconnect: Maximum Repetition Time (hours) SXRETRYHOUNUMC3NUM3
RETRY_MINSAPconnect: Maximum Repetition Time (Minutes) SXRETRYMINNUMC3NUM3
LSTCHGUSERLast Changed by AS4USERCHAR12AS4USER
LSTCHGDATEDate of Last Change AS4DATEDATS8AS4DATE
F_DO_MONNode/server is to be monitored by the alert monitor F_DO_MONCHAR1SX_BOOLEAN
F_EXTFCTSNode supports extended functions (as of 4.5B) F_EXTFCTSCHAR1SX_BOOLEAN
ES_VERSIONSAPconnect: Version number of external server software SX_VERSIONCHAR8CHAR8
RFCDESTLogical Destination (Specified in Function Call) RFCDESTCHAR32RFCDESRFCDESTRFCF4_RFCDESTYPEALL
NODE_TYPESAPconnect: Node Type (RFC,SMTP) SX_NODETYPCHAR1SX_NODETYP
MAIL_HOSTSAPconnect: Host Name of Mail MTA SX_MLHOSTCHAR100RFCHOST
MAIL_PORTSAPconnect: Port Number of Mail MTA SX_MLPORTCHAR32RFCNAME
CODEPAGESAP Character Set ID CPCODEPAGENUMC4TCP00CPCODEPAGE
F_ESMTPSAPconnect: Node Supports ESMTP SX_ESMTPCHAR1SX_BOOLEAN
PASSWORDSAPconnect: Password SX_PASSWRDCHAR20SX_PASSWRD
ENCODINGSAPconnect: Coding Procedure for Message Text SX_ENCODINGCHAR1SX_ENCODING
RESPONSE_TYPESAPconnect: Type of Confirmation (Successful, with Errors) SX_RSPTYPECHAR1SX_RSPTYPE
RESPONSE_PATTSAPconnect: Text Pattern in a Confirmation SX_RSPPATTCHAR80
SMTPUSERUser Name SX_USERCHAR40
STARTTLSTransport Layer Security (TLS) SX_STARTTLSNUMC1SX_STARTTLS
HOSTMATCHTLS: Check Host Name of Server Certificate SX_HOSTMATCHCHAR1SX_BOOLEAN
TRUSTCHECKTLS: Check Server Certificate SX_TRUSTCHECKCHAR1SX_BOOLEAN
TLSIDENTClient Identity SX_TLSIDENTCHAR6SSFAPPLSSL

Key field Non-key field



How do I retrieve data from SAP table SXNODES using ABAP code

The following ABAP code Example will allow you to do a basic selection on SXNODES to SELECT all data from the table
DATA: WA_SXNODES TYPE SXNODES.

SELECT SINGLE *
FROM SXNODES
INTO CORRESPONDING FIELDS OF WA_SXNODES
WHERE...

How to access SAP table SXNODES

Within an ECC or HANA version of SAP you can also view further information about SXNODES and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!