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 |
Possible values
|
||||||||
FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | 0 |
Possible values
|
||||||||
HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
R3_USER | Flag: Connected to an SAP System | AD_R3_USER | CHAR | 1 | 0 |
Possible values
|
||||||||
ENCODE | Desired Data Coding (E-Mail) | AD_ENCODE | CHAR | 1 | 0 |
Possible values
|
||||||||
TNEF | Flag: Receiver can receive TNEF coding via SMTP | AD_TNEF6 | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |