SAP table SXNODES (SAPconnect: Communication nodes)

SAP table SXNODES has 2 primary key fields being MANDT,NODE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

SXNODES foreign key relationships

Table Field Check Table Check Field
0 SXNODES CODEPAGE TCP00 SAP code page catalog CPCODEPAGE
1 SXNODES COUNTRY T005 Countries MANDT
1 SXNODES COUNTRY T005 Countries LAND1
0 SXNODES MANDT T000 Clients MANDT
1 SXNODES R_NODE SXNODES SAPconnect: Communication nodes MANDT