SAP Table ADSMTP

SMTP Addresses Data Transfer Structure (Bus. Addr. Services)

ADSMTP (SMTP Addresses Data Transfer Structure (Bus. Addr. Services)) 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 ADSMTP to other SAP tables.

ADSMTP table fields

Field Data element Checktable Datatype Length Decimals
CONSNUMBER Sequence Number AD_CONSNUM NUMC 3 0
FLGDEFAULT Standard Sender Address in this Communication Type AD_FLGDFNR CHAR 1 0
X Yes
NULL No
FLG_NOUSE Flag: This Communication Number is Not Used AD_FLNOUSE CHAR 1 0
X Yes
NULL No
HOME_FLAG Recipient address in this communication type (mail sys.grp) AD_FLGHOME CHAR 1 0
X Yes
NULL No
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR 241 0
SMTP_SRCH E-Mail Address Search Field AD_SMTPAD2 CHAR 20 0
DFT_RECEIV Flag: Recipient is standard recipient for this number AD_DFTRCNR CHAR 1 0
X Yes
NULL No
R3_USER Flag: Connected to an SAP System AD_R3_USER CHAR 1 0
X Yes
NULL No
ENCODE Desired Data Coding (E-Mail) AD_ENCODE CHAR 1 0
0 NONE
1 MIME
2 UUENCODE
TNEF Flag: Receiver can receive TNEF coding via SMTP AD_TNEF6 CHAR 1 0
X Yes
NULL No
REMARK Communication link notes AD_REMARK2 CHAR 50 0
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0
UPDATEFLAG Change operation code ('I'nsert, 'U'pdate, 'D'elete) AD_OP_CODE CHAR 1 0
I Insert
U Update
D Delete
NULL No change