SAP Table ADR2
Telephone Numbers (Business Address Services)
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table ADR2 (Telephone Numbers (Business Address Services)) is a standard table in SAP ERP. It belongs to the package SZAD.
Technical Information
| Table | ADR2 |
| Short Text | Telephone Numbers (Business Address Services) |
| Package | SZAD |
| Table Type | Transparent Table |
Fields for Table ADR2
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| ADDRNUMBER | ✔ | Address number | AD_ADDRNUM | CHAR | 10 | ADRC |
| PERSNUMBER | ✔ | Person number | AD_PERSNUM | CHAR | 10 | ADRP |
| DATE_FROM | ✔ | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | |
| CONSNUMBER | ✔ | Sequence Number | AD_CONSNUM | NUMC | 3 | |
| COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | T005 | |
| FLGDEFAULT | Standard Sender Address in this Communication Type | AD_FLGDFNR | CHAR | 1 | ||
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | ||
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 1 | ||
| TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | ||
| TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | ||
| TELNR_LONG | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR | 30 | ||
| TELNR_CALL | Telephone number for determining caller | AD_TELNRCL | CHAR | 30 | ||
| DFT_RECEIV | Indicator: Telephone is SMS-Enabled | AD_FLGSMS | CHAR | 1 | ||
| R3_USER | Indicator: Telephone is a Mobile Telephone | AD_FLGMOB | CHAR | 1 | ||
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR | 14 | ||
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR | 14 |