1. Home
  2. Resources
  3. SAP Tables
  4. ADR2 - Telephone Numbers (Business Address Services)

SAP Table ADR2

Telephone Numbers (Business Address Services)

ADR2 (Telephone Numbers (Business Address Services)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADR2 to other SAP tables.

ADR2 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ADDRNUMBER Address number AD_ADDRNUM ADRC CHAR 10 0
PERSNUMBER Person number AD_PERSNUM ADRP CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
CONSNUMBER Sequence Number AD_CONSNUM NUMC 3 0
COUNTRY Country for telephone/fax number AD_COMCTRY T005 CHAR 3 0
FLGDEFAULT Standard Sender Address in this Communication Type AD_FLGDFNR CHAR 1 0
X Yes
NULL No
FLG_NOUSE Flag: This Communication Number is Not Used AD_FLNOUSE CHAR 1 0
X Yes
NULL No
HOME_FLAG Recipient address in this communication type (mail sys.grp) AD_FLGHOME CHAR 1 0
X Yes
NULL No
TEL_NUMBER Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
TEL_EXTENS Telephone no.: Extension AD_TLXTNS CHAR 10 0
TELNR_LONG Complete number: dialling code+number+extension AD_TELNRLG CHAR 30 0
TELNR_CALL Telephone number for determining caller AD_TELNRCL CHAR 30 0
DFT_RECEIV Indicator: Telephone is SMS-Enabled AD_FLGSMS CHAR 1 0
NULL Telephone is Not SMS-Enabled
X Telephone is SMS-Enabled
R3_USER Indicator: Telephone is a Mobile Telephone AD_FLGMOB CHAR 1 0
NULL 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) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0

ADR2 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADR2 ADDRNUMBER * ADRC Addresses (Business Address Services) NATION
ADR2 ADDRNUMBER ADR2 CLIENT ADRC Addresses (Business Address Services) CLIENT
ADR2 ADDRNUMBER ADR2 ADDRNUMBER ADRC Addresses (Business Address Services) ADDRNUMBER
ADR2 ADDRNUMBER * ADRC Addresses (Business Address Services) DATE_FROM
ADR2 CLIENT ADR2 CLIENT T000 Clients MANDT
ADR2 COUNTRY ADR2 CLIENT T005 Countries MANDT
ADR2 COUNTRY ADR2 COUNTRY T005 Countries LAND1
ADR2 PERSNUMBER ADR2 CLIENT ADRP Persons (Business Address Services) CLIENT
ADR2 PERSNUMBER ADR2 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
ADR2 PERSNUMBER * ADRP Persons (Business Address Services) DATE_FROM
ADR2 PERSNUMBER * ADRP Persons (Business Address Services) NATION