SAP Table ADR2
Telephone Numbers (Business Address Services)
ADR2 (Telephone Numbers (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 ADR2 to other SAP tables.
ADR2 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 | ||||||||||||||
|
COUNTRY
Country for telephone/fax number
|
AD_COMCTRY | T005 |
CHAR
|
3 | 0 | |||||||||||||
|
FLGDEFAULT
Standard Sender Address in this Communication Type
|
AD_FLGDFNR |
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 | ||||||||||||||
|
||||||||||||||||||
|
TEL_NUMBER
Telephone no.: dialling code+number
|
AD_TLNMBR |
CHAR
|
30 | 0 | ||||||||||||||
|
TEL_EXTENS
Telephone no.: Extension
|
AD_TLXTNS |
CHAR
|
10 | 0 | ||||||||||||||
|
TELNR_LONG
Complete number: dialling code+number+extension
|
AD_TELNRLG |
CHAR
|
30 | 0 | ||||||||||||||
|
TELNR_CALL
Telephone number for determining caller
|
AD_TELNRCL |
CHAR
|
30 | 0 | ||||||||||||||
|
DFT_RECEIV
Indicator: Telephone is SMS-Enabled
|
AD_FLGSMS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
R3_USER
Indicator: Telephone is a Mobile Telephone
|
AD_FLGMOB |
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 | ||||||||||||||
ADR2 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ADR2 | ADDRNUMBER | ADR2 | CLIENT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| ADR2 | ADDRNUMBER | ADR2 | ADDRNUMBER |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| ADR2 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| ADR2 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| ADR2 | CLIENT | ADR2 | CLIENT |
T000
Clients
|
MANDT |
| ADR2 | COUNTRY | ADR2 | CLIENT |
T005
Countries
|
MANDT |
| ADR2 | COUNTRY | ADR2 | COUNTRY |
T005
Countries
|
LAND1 |
| ADR2 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
DATE_FROM | |
| ADR2 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
NATION | |
| ADR2 | PERSNUMBER | ADR2 | CLIENT |
ADRP
Persons (Business Address Services)
|
CLIENT |
| ADR2 | PERSNUMBER | ADR2 | PERSNUMBER |
ADRP
Persons (Business Address Services)
|
PERSNUMBER |