SAP Table CRMT_BSP_ADMOB

Dialog Structure for Mobile Telephone Numbers

CRMT_BSP_ADMOB (Dialog Structure for Mobile Telephone Numbers) 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 CRMT_BSP_ADMOB to other SAP tables.

CRMT_BSP_ADMOB table fields

Field Data element Checktable Datatype Length Decimals
OBJECT_KEY Object Key CRMT_BSP_OBJECTKEY CHAR 100 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
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
MOB_NUMBER First Mobile Telephone No.: Dialing Code + Number AD_MBNMBR1 CHAR 30 0
MOB_EXTENS First Mobile Telephone No.: Extension AD_MBXTNS1 CHAR 10 0
TELEFTO Country telephone/fax dialling code SKTELFTO CHAR 4 0
DATE_FROM Communication data: Start date AD_SCDFROM DATS 8 0
DATE_TO Communication data: End date AD_SCDTO DATS 8 0
DEF_FROM Communication data: Start date default flag AD_SCDEFFR DATS 8 0
DEF_TO Communication data: End date default flag AD_SCDEFTO DATS 8 0
MORE_DEF Communication data: More periods exist as default number AD_SCMDEF CHAR 1 0
X Yes
NULL No
HOME_FROM Communication data: Start date flag 'Home Address' AD_SCHOMFR DATS 8 0
HOME_TO Communication data: End date flag 'Home Address' AD_SCHOMTO DATS 8 0
MORE_HOME Comm. data: More periods exist as home address AD_SCMHOM CHAR 1 0
X Yes
NULL No

CRMT_BSP_ADMOB foreign key relationships

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