SAP Table ADR6

E-Mail Addresses (Business Address Services)

ADR6 (E-Mail Addresses (Business Address 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 ADR6 to other SAP tables.

ADR6 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ADDRNUMBER Address number AD_ADDRNUM ADRC CHAR 10 0
PERSNUMBER Person number AD_PERSNUM ADRP CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
CONSNUMBER Sequence Number AD_CONSNUM NUMC 3 0
FLGDEFAULT Flag: this address is the default address AD_FLGDFAD 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 address AD_DFTRCAD 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
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0

ADR6 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADR6 ADDRNUMBER * ADRC Addresses (Business Address Services) DATE_FROM
ADR6 ADDRNUMBER * ADRC Addresses (Business Address Services) NATION
ADR6 ADDRNUMBER ADR6 CLIENT ADRC Addresses (Business Address Services) CLIENT
ADR6 ADDRNUMBER ADR6 ADDRNUMBER ADRC Addresses (Business Address Services) ADDRNUMBER
ADR6 CLIENT ADR6 CLIENT T000 Clients MANDT
ADR6 PERSNUMBER * ADRP Persons (Business Address Services) NATION
ADR6 PERSNUMBER ADR6 CLIENT ADRP Persons (Business Address Services) CLIENT
ADR6 PERSNUMBER ADR6 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
ADR6 PERSNUMBER * ADRP Persons (Business Address Services) DATE_FROM