1. Home
  2. Resources
  3. SAP Tables
  4. ADTEL - Telephone Number Data Transfer Structure (BAS)

SAP Table ADTEL

Telephone Number Data Transfer Structure (BAS)

ADTEL (Telephone Number Data Transfer Structure (BAS)) 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 ADTEL to other SAP tables.

ADTEL table fields

Field Data element Checktable Datatype Length Decimals
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
REMARK Communication link notes AD_REMARK2 CHAR 50 0
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0
UPDATEFLAG Change operation code ('I'nsert, 'U'pdate, 'D'elete) AD_OP_CODE CHAR 1 0
I Insert
U Update
D Delete
NULL No change

ADTEL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADTEL COUNTRY * T005 Countries MANDT
ADTEL COUNTRY ADTEL COUNTRY T005 Countries LAND1