back to top

SAP ADR2 Table – Telephone Numbers (Business Address Services)

The ADR2 table in SAP ERP or S/4HANA stores Telephone Numbers (Business Address Services) data. There are total 18 fields in ADR2 table. The Telephone 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 ADR2 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 ADR2 Table Fields

Following is the list of fields that are available in SAP ADR2 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)
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)
_DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATS (8)