The ADR3 table in SAP ERP or S/4HANA stores Fax Numbers (Business Address Services) data. There are total 19 fields in ADR3 table. The Fax Numbers (Business Address Services) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ADR3 table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.
SAP ADR3 Table Fields
Following is the list of fields that are available in SAP ADR3 table. The primary key fields of the table are CLIENT (Client), ADDRNUMBER (Address Number), PERSNUMBER (Person Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| ADDRNUMBER | Address Number | AD_ADDRNUM | ADRC | CHAR (10) |
| PERSNUMBER | Person Number | AD_PERSNUM | ADRP | CHAR (10) |
| 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 | T005 | CHAR (3) |
| 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) | |
| FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR (30) | |
| FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR (10) | |
| FAXNR_LONG | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR (30) | |
| FAXNR_CALL | Fax number for finding sender | AD_FAXNRCL | CHAR (30) | |
| FAX_GROUP | Fax group (G3, G4, …) | AD_FXGRP | CHAR (1) | |
| DFT_RECEIV | Flag: Recipient is standard recipient for this number | AD_DFTRCNR | CHAR (1) | |
| R3_USER | Flag: Connected to an SAP System | AD_R3_USER | CHAR (1) | |
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR (14) | |
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR (14) | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) |
