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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
FLG_NOUSE
Flag: This Communication Number is Not Used
|
AD_FLNOUSE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
HOME_FLAG
Recipient address in this communication type (mail sys.grp)
|
AD_FLGHOME |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
|
R3_USER
Flag: Connected to an SAP System
|
AD_R3_USER |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
ENCODE
Desired Data Coding (E-Mail)
|
AD_ENCODE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
TNEF
Flag: Receiver can receive TNEF coding via SMTP
|
AD_TNEF6 |
CHAR
|
1 | 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 | ||||||||||
ADR6 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ADR6 | ADDRNUMBER | ADR6 | CLIENT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| ADR6 | ADDRNUMBER | ADR6 | ADDRNUMBER |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| ADR6 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| ADR6 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| ADR6 | CLIENT | ADR6 | CLIENT |
T000
Clients
|
MANDT |
| ADR6 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
DATE_FROM | |
| 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 |