SAP Table ADR2S

Shadow Table: Telephone Numbers (Business Address Services)

The table ADR2S (Shadow Table: Telephone Numbers (Business Address Services)) is a standard table in SAP ERP. It belongs to the package SZAD.

Technical Information

Table	ADR2S
Short Text	Shadow Table: Telephone Numbers (Business Address Services)
Package	SZAD
Table Type	Transparent Table

Fields for Table ADR2S

Field Name	Key	Description	Data Element	Type	Length	Check Table
CLIENT	✔	Client	MANDT	CLNT	3	T000
TRKORR	✔	Request/Task	TRKORR	CHAR	20	*
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