1. Home
  2. Resources
  3. SAP Tables
  4. SXNODES - SAPconnect: Communication nodes

SAP Table SXNODES

SAPconnect: Communication nodes

SXNODES (SAPconnect: Communication nodes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SXNODES to other SAP tables.

SXNODES table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
NODE Name of SAPconnect Node or Telephony Server SX_NODE_ID CHAR 6 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
R_NODE Name of SAPconnect Node or Telephony Server SX_NODE_ID SXNODES CHAR 6 0
R_ADMIN RML Name (Remote Mail, SAP - SAP - Communication) AD_UNAME CHAR 12 0
R3_SYSTEM Name of SAP System SYSYSID CHAR 8 0
R3_CLIENT Client MANDT CLNT 3 0
DESCRIP Comment CHAR50 CHAR 50 0
PREFERENCE Node Can Resolve Path Reference SX_PREF CHAR 1 0
X True
NULL False
ACTIVE SAPconnect: Node is ready for use SX_ACTIVE CHAR 1 0
NULL Off
X On
RETRY_HOUR SAPconnect: Maximum Repetition Time (hours) SXRETRYHOU NUMC 3 0
RETRY_MIN SAPconnect: Maximum Repetition Time (Minutes) SXRETRYMIN NUMC 3 0
LSTCHGUSER Last Changed by AS4USER CHAR 12 0
LSTCHGDATE Date of Last Change AS4DATE DATS 8 0
F_DO_MON Node/server is to be monitored by the alert monitor F_DO_MON CHAR 1 0
X True
NULL False
F_EXTFCTS Node supports extended functions (as of 4.5B) F_EXTFCTS CHAR 1 0
X True
NULL False
ES_VERSION SAPconnect: Version number of external server software SX_VERSION CHAR 8 0
RFCDEST Logical Destination (Specified in Function Call) RFCDEST RFCDES CHAR 32 0
NODE_TYPE SAPconnect: Node Type (RFC,SMTP) SX_NODETYP CHAR 1 0
NULL RFC Connection
S SMTP Connection
H HTTP Connection
MAIL_HOST SAPconnect: Host Name of Mail MTA SX_MLHOST CHAR 100 0
MAIL_PORT SAPconnect: Port Number of Mail MTA SX_MLPORT CHAR 32 0
CODEPAGE SAP Character Set ID CPCODEPAGE TCP00 NUMC 4 0
F_ESMTP SAPconnect: Node Supports ESMTP SX_ESMTP CHAR 1 0
X True
NULL False
PASSWORD SAPconnect: Password SX_PASSWRD CHAR 20 0
ENCODING SAPconnect: Coding Procedure for Message Text SX_ENCODING CHAR 1 0
NULL No Coding
B Base 64
Q Quoted Printable
RESPONSE_TYPE SAPconnect: Type of Confirmation (Successful, with Errors) SX_RSPTYPE CHAR 1 0
I Success (Constant SX_INF_TYPE)
E Error (Constant SX_ERR_TYPE)
RESPONSE_PATT SAPconnect: Text Pattern in a Confirmation SX_RSPPATT CHAR 80 0
SMTPUSER User Name SX_USER CHAR 40 0
STARTTLS Transport Layer Security (TLS) SX_STARTTLS NUMC 1 0
0 Do not use TLS
1 Use TLS, if possible
2 Mandatory to use TLS
HOSTMATCH TLS: Check Host Name of Server Certificate SX_HOSTMATCH CHAR 1 0
X True
NULL False
TRUSTCHECK TLS: Check Server Certificate SX_TRUSTCHECK CHAR 1 0
X True
NULL False
TLSIDENT Client Identity SX_TLSIDENT CHAR 6 0

SXNODES foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SXNODES CODEPAGE SXNODES CODEPAGE TCP00 SAP code page catalog CPCODEPAGE
SXNODES COUNTRY SXNODES MANDT T005 Countries MANDT
SXNODES COUNTRY SXNODES COUNTRY T005 Countries LAND1
SXNODES MANDT SXNODES MANDT T000 Clients MANDT
SXNODES RFCDEST SXNODES RFCDEST RFCDES Destination table for Remote Function Call RFCDEST
SXNODES R_NODE SXNODES R_NODE SXNODES SAPconnect: Communication nodes NODE
SXNODES R_NODE SXNODES MANDT SXNODES SAPconnect: Communication nodes MANDT