SAP Table ADR7
Remote Mail Addresses (SAP - SAP - Communication; BAS)
ADR7 (Remote Mail Addresses (SAP - SAP - Communication; BAS)) 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 ADR7 to other SAP tables.
ADR7 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 name is the default name | AD_FLGDFNM | 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
|
||||||
| SYMB_DEST | Symbolic destination | AD_SYMBDST | CHAR | 10 | 0 | |||||||
| RECVR_TYPE | Recipient type (not currently used) | AD_RCVRTYP | CHAR | 1 | 0 | |||||||
| UMAND | RML- Client (Remote Mail, SAP - SAP - Communication) | AD_UMAND | CHAR | 3 | 0 | |||||||
| UNAME | RML Name (Remote Mail, SAP - SAP - Communication) | AD_UNAME | CHAR | 12 | 0 | |||||||
| DFT_RECEIV | Flag: Recipient is the standard recipient for this name | AD_DFTRCNM | CHAR | 1 | 0 |
Possible values
|
||||||
| R3_USER | Flag: Connected to an SAP System | AD_R3_USER | 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 | |||||||
ADR7 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADR7 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADR7 | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADR7 | ADDRNUMBER | ADR7 | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADR7 | ADDRNUMBER | ADR7 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADR7 | CLIENT | ADR7 | CLIENT | T000 | Clients | MANDT |
| ADR7 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | NATION | |
| ADR7 | PERSNUMBER | ADR7 | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| ADR7 | PERSNUMBER | ADR7 | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| ADR7 | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
