SAP Table ADR2

Telephone Numbers (Business Address Services)

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