SAP Table ADR3
Fax Numbers (Business Address Services)
ADR3 (Fax 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 ADR3 to other SAP tables.
ADR3 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 | ||||||||
|
||||||||||||
|
FAX_NUMBER
Fax number: dialling code+number
|
AD_FXNMBR |
CHAR
|
30 | 0 | ||||||||
|
FAX_EXTENS
Fax no.: Extension
|
AD_FXXTNS |
CHAR
|
10 | 0 | ||||||||
|
FAXNR_LONG
Complete number: dialling code+number+extension
|
AD_FXNRLNG |
CHAR
|
30 | 0 | ||||||||
|
FAXNR_CALL
Fax number for finding sender
|
AD_FAXNRCL |
CHAR
|
30 | 0 | ||||||||
|
FAX_GROUP
Fax group (G3, G4, ...)
|
AD_FXGRP |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DFT_RECEIV
Flag: Recipient is standard recipient for this number
|
AD_DFTRCNR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
R3_USER
Flag: Connected to an SAP System
|
AD_R3_USER |
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 | ||||||||
ADR3 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ADR3 | ADDRNUMBER | ADR3 | CLIENT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| ADR3 | ADDRNUMBER | ADR3 | ADDRNUMBER |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| ADR3 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| ADR3 | ADDRNUMBER | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| ADR3 | CLIENT | ADR3 | CLIENT |
T000
Clients
|
MANDT |
| ADR3 | COUNTRY | ADR3 | CLIENT |
T005
Countries
|
MANDT |
| ADR3 | COUNTRY | ADR3 | COUNTRY |
T005
Countries
|
LAND1 |
| ADR3 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
DATE_FROM | |
| ADR3 | PERSNUMBER | * |
ADRP
Persons (Business Address Services)
|
NATION | |
| ADR3 | PERSNUMBER | ADR3 | CLIENT |
ADRP
Persons (Business Address Services)
|
CLIENT |
| ADR3 | PERSNUMBER | ADR3 | PERSNUMBER |
ADRP
Persons (Business Address Services)
|
PERSNUMBER |