SAP Table ADR2S2 - Shadow Table 2: Telephone Nos (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
TABLENAME X AD_APPLTAB CHAR 3 10 0 Application table logical name (address management)
FIELDNAME X AD_APPLFLD CHAR 13 10 0 Application table address where-used list logical field name
OBJKEY X AD_OBJKEY CHAR 23 70 0 Address owner object ID
DATE_FROM X AD_DATE_FR DATS 93 8 0 Valid-from date - in current Release only 00010101 possible
CONSNUMBER X AD_CONSNUM NUMC 101 3 0 Sequence number
COUNTRY AD_COMCTRY CHAR 104 3 0 T005 Country for telephone/fax number
FLGDEFAULT AD_FLGDFNR CHAR 107 1 0 Standard Sender Address in this Communication Type
FLG_NOUSE AD_FLNOUSE CHAR 108 1 0 Flag: This Communication Number is Not Used
HOME_FLAG AD_FLGHOME CHAR 109 1 0 Recipient address in this communication type (mail sys.grp)
TEL_NUMBER AD_TLNMBR CHAR 110 30 0 Telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS CHAR 140 10 0 Telephone no.: Extension
TELNR_LONG AD_TELNRLG CHAR 150 30 0 Complete Number: Dialling Code+Number+Extension
TELNR_CALL AD_TELNRCL CHAR 180 30 0 Telephone number for determining caller
DFT_RECEIV AD_FLGSMS CHAR 210 1 0 Indicator: Telephone is SMS-Enabled
R3_USER AD_FLGMOB CHAR 211 1 0 Indicator: Telephone is a Mobile Telephone
VALID_FROM AD_VALFROM CHAR 212 14 0 Communication Data: Valid From (YYYYMMDDHHMMSS)
VALID_TO AD_VALTO CHAR 226 14 0 Communication Data: Valid To (YYYYMMDDHHMMSS)

673941Unicode conversion for address tables (ADRC, ADRP)
385440Repairing inconsistencies in Customizing addresses