SAP table ADR6 (E-Mail Addresses (Business Address Services))
SAP table ADR6 has 5 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,DATE_FROM,CONSNUMBER.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| CLIENT |
Client |
CLNT |
3 |
0 |
T000
|
MANDT
|
|
| ADDRNUMBER |
Address Number |
CHAR |
10 |
0 |
ADRC
|
AD_ADDRNUM
|
|
| PERSNUMBER |
Person Number |
CHAR |
10 |
0 |
ADRP
|
AD_PERSNUM
|
|
| DATE_FROM |
Valid-from date - in current Release only 00010101 possible |
DATS |
8 |
0 |
|
AD_DATE_FR
|
|
| CONSNUMBER |
Sequence Number |
NUMC |
3 |
0 |
|
AD_CONSNUM
|
|
| FLGDEFAULT |
Flag: this address is the default address |
CHAR |
1 |
0 |
|
AD_FLGDFAD
|
|
| FLG_NOUSE |
Flag: This Communication Number is Not Used |
CHAR |
1 |
0 |
|
AD_FLNOUSE
|
|
| HOME_FLAG |
Recipient address in this communication type (mail sys.grp) |
CHAR |
1 |
0 |
|
AD_FLGHOME
|
|
| SMTP_ADDR |
E-Mail Address |
CHAR |
241 |
0 |
|
AD_SMTPADR
|
|
| SMTP_SRCH |
E-Mail Address Search Field |
CHAR |
20 |
0 |
|
AD_SMTPAD2
|
|
| DFT_RECEIV |
Flag: Recipient is standard recipient for this address |
CHAR |
1 |
0 |
|
AD_DFTRCAD
|
|
| R3_USER |
Flag: Connected to an SAP System |
CHAR |
1 |
0 |
|
AD_R3_USER
|
|
| ENCODE |
Required Data Encoding (E-Mail) |
CHAR |
1 |
0 |
|
AD_ENCODE
|
|
| TNEF |
Flag: Receiver can receive TNEF encoding by SMTP |
CHAR |
1 |
0 |
|
AD_TNEF6
|
|
| VALID_FROM |
Communication Data: Valid From (YYYYMMDDHHMMSS) |
CHAR |
14 |
0 |
|
AD_VALFROM
|
|
| VALID_TO |
Communication Data: Valid To (YYYYMMDDHHMMSS) |
CHAR |
14 |
0 |
|
AD_VALTO
|
|
| _DATAAGING |
Data Filter Value for Data Aging |
DATS |
8 |
0 |
|
DATA_TEMPERATURE
|
|
ADR6 foreign key relationships
| Table |
Field |
Check Table |
|
Check Field |
| 0 ADR6 |
ADDRNUMBER |
ADRC |
Addresses (Business Address Services) |
DATE_FROM |
| 0 ADR6 |
ADDRNUMBER |
ADRC |
Addresses (Business Address Services) |
NATION |
| 1 ADR6 |
CLIENT |
T000 |
Clients |
MANDT |
| 0 ADR6 |
PERSNUMBER |
ADRP |
Persons (Business Address Services) |
PERSNUMBER |
| 0 ADR6 |
PERSNUMBER |
ADRP |
Persons (Business Address Services) |
DATE_FROM |
| 0 ADR6 |
PERSNUMBER |
ADRP |
Persons (Business Address Services) |
NATION |