SAP Table ADR2S - Shadow Table: Telephone Numbers (Business Address Services)

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
TRKORR X TRKORR CHAR 3 20 0 Request/Task
ADDRNUMBER X AD_ADDRNUM CHAR 23 10 0 Address number
PERSNUMBER X AD_PERSNUM CHAR 33 10 0 ADRP Person number
DATE_FROM X AD_DATE_FR DATS 43 8 0 Valid-from date - in current Release only 00010101 possible
CONSNUMBER X AD_CONSNUM NUMC 51 3 0 Sequence number
COUNTRY AD_COMCTRY CHAR 54 3 0 T005 Country for telephone/fax number
FLGDEFAULT AD_FLGDFNR CHAR 57 1 0 Standard Sender Address in this Communication Type
FLG_NOUSE AD_FLNOUSE CHAR 58 1 0 Flag: This Communication Number is Not Used
HOME_FLAG AD_FLGHOME CHAR 59 1 0 Recipient address in this communication type (mail sys.grp)
TEL_NUMBER AD_TLNMBR CHAR 60 30 0 Telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS CHAR 90 10 0 Telephone no.: Extension
TELNR_LONG AD_TELNRLG CHAR 100 30 0 Complete Number: Dialling Code+Number+Extension
TELNR_CALL AD_TELNRCL CHAR 130 30 0 Telephone number for determining caller
DFT_RECEIV AD_FLGSMS CHAR 160 1 0 Indicator: Telephone is SMS-Enabled
R3_USER AD_FLGMOB CHAR 161 1 0 Indicator: Telephone is a Mobile Telephone
VALID_FROM AD_VALFROM CHAR 162 14 0 Communication Data: Valid From (YYYYMMDDHHMMSS)
VALID_TO AD_VALTO CHAR 176 14 0 Communication Data: Valid To (YYYYMMDDHHMMSS)

673941Unicode conversion for address tables (ADRC, ADRP)