SAP table ADR2 (Telephone Numbers (Business Address Services))

SAP table ADR2 has 5 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,DATE_FROM,CONSNUMBER.

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

ADR2 foreign key relationships

Table Field Check Table Check Field
0 ADR2 ADDRNUMBER ADRC Addresses (Business Address Services) DATE_FROM
0 ADR2 ADDRNUMBER ADRC Addresses (Business Address Services) NATION
1 ADR2 CLIENT T000 Clients MANDT
0 ADR2 COUNTRY T005 Countries MANDT
0 ADR2 COUNTRY T005 Countries LAND1
1 ADR2 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
1 ADR2 PERSNUMBER ADRP Persons (Business Address Services) DATE_FROM
1 ADR2 PERSNUMBER ADRP Persons (Business Address Services) NATION