E-Mail Addresses (Business Address Services) — the per-communication-type child of ADRC holding e-mail (SMTP) addresses for a given ADDRNUMBER, sibling to ADR2 (telephone) and ADR3 (fax), pointed at by ADRC's FLAGCOMM6 flag. This is the table an ESG or interaction-record column extending contact-channel data would attach alongside, without altering ADRC itself. SAP's real ADR6 carries all its fields; this definition carries the table complete, as it is a small check/detail table.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| DML_NUM key | domicilium numerus | Address number | AD_ADDRNUM | CHAR 10 | ADRC |
| PSN_NUM key | persona numerus | Person number | AD_PERSNUM | CHAR 10 | ADRP |
| VLA_DIE_EMS key | validus ab dies emissio | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS 8 | — |
| ORD_NUM key | ordo numerus | Sequence Number | AD_CONSNUM | NUMC 3 | — |
| SGN_DML | signum domicilium | Flag: this address is the default address | AD_FLGDFAD | CHAR 1 | — |
| SGN_NUM | signum numerus | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR 1 | — |
| DML_GEN | domicilium genus | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR 1 | — |
| DML | domicilium | E-Mail Address | AD_SMTPADR | CHAR 241 | — |
| DML_CMP | domicilium campus | E-Mail Address Search Field | AD_SMTPAD2 | CHAR 20 | — |
| SGN_NRM_DML | signum norma domicilium | Flag: Recipient is standard recipient for this address | AD_DFTRCAD | CHAR 1 | — |
| SGN | signum | Flag: Connected to an SAP System | AD_R3_USER | CHAR 1 | — |
| ENCODE | Desired Data Coding (E-Mail) | AD_ENCODE | CHAR 1 | — | |
| SGN2 | signum | Flag: Receiver can receive TNEF coding via SMTP | AD_TNEF6 | CHAR 1 | — |
| VLA | validus ab | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR 14 | — |
| VLD | validus ad | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR 14 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
CLIENT | T000 | MANDT |
ADDRNUMBER | ADRC | ADDRNUMBER |
PERSNUMBER | ADRP | PERSNUMBER |