ADR2 - Telephone Numbers (Business Address Services)

Telephone Numbers (Business Address Services) information is stored in SAP table ADR2.
It is part of development package SZAD in software component BC-SRV-ADR. This development package consists of objects that can be grouped under "SAP Technology - Business Services: Address Management".

Fields for table ADR2

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
ADDRNUMBER	Address Number	X	AD_ADDRNUM	CHAR	20	ADRC
PERSNUMBER	Person Number	X	AD_PERSNUM	CHAR	20	ADRP
DATE_FROM	Valid-from date - in current Release only 00010101 possible	X	AD_DATE_FR	DATS	16
CONSNUMBER	Sequence Number	X	AD_CONSNUM	NUMC	6
COUNTRY	Country/Region for Telephone/Fax Number		AD_COMCTRY	CHAR	6	T005
FLGDEFAULT	Standard Sender Address in this Communication Type		AD_FLGDFNR	CHAR	2
FLG_NOUSE	Flag: This Communication Number is Not Used		AD_FLNOUSE	CHAR	2
HOME_FLAG	Recipient address in this communication type (mail sys.grp)		AD_FLGHOME	CHAR	2
TEL_NUMBER	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
TEL_EXTENS	Telephone no.: Extension		AD_TLXTNS	CHAR	20
TELNR_LONG	Complete Number: Dialling Code+Number+Extension		AD_TELNRLG	CHAR	60
TELNR_CALL	Telephone number for determining caller		AD_TELNRCL	CHAR	60
DFT_RECEIV	Indicator: Telephone is SMS-Enabled		AD_FLGSMS	CHAR	2
R3_USER	Indicator: Telephone is a Mobile Telephone		AD_FLGMOB	CHAR	2
VALID_FROM	Communication Data: Valid From (YYYYMMDDHHMMSS)		AD_VALFROM	CHAR	28
VALID_TO	Communication Data: Valid To (YYYYMMDDHHMMSS)		AD_VALTO	CHAR	28
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16