P_MobileNumbers

Mobile Numbers | view: PMOBILENUMBERS | Extraction: Not supported | Component: Maintenance Notifications
Tables used: ADR2
Column Name Description
ADDRNUMBER FK Address Number
PERSNUMBER FK Person Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
CONSNUMBER Sequence Number
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
_DATAAGING Data Filter Value for Data Aging
Column Name Description
FLGDEFAULT Standard Sender Address in this Communication Type Show values
FLG_NOUSE Flag: This Communication Number is Not Used Show values
HOME_FLAG Recipient address in this communication type (mail sys.grp) Show values
DFT_RECEIV Indicator: Telephone is SMS-Enabled Show values
R3_USER Indicator: Telephone is a Mobile Telephone Show values
Column Name Description Domain name
TEL_NUMBER Telephone no.: dialling code+number CHAR30
TEL_EXTENS Telephone no.: Extension CHAR10
TELNR_LONG Complete Number: Dialling Code+Number+Extension CHAR30
TELNR_CALL Telephone number for determining caller CHAR30
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • P_MOBILENUMBERS.[column in domain "AD_NATION"] == ADRC.NATION
  • P_MOBILENUMBERS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_MOBILENUMBERS.ADDRNUMBER == ADRC.ADDRNUMBER
  • P_MOBILENUMBERS.MANDT == ADRC.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • P_MOBILENUMBERS.MANDT == T005.MANDT
  • P_MOBILENUMBERS.COUNTRY == T005.LAND1
Person number
  • ?
  • ?
  • Client
  • Person Number
  • P_MOBILENUMBERS.[column in domain "AD_NATION"] == ADRP.NATION
  • P_MOBILENUMBERS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_MOBILENUMBERS.MANDT == ADRP.CLIENT
  • P_MOBILENUMBERS.PERSNUMBER == ADRP.PERSNUMBER