I_BPMobilePhoneNumber

Mobile Phone Number core view | view: IBPMOBILEPHNO | ATTR | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADR2BUT020BUT000
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Person FK Person Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsDefaultPhoneNumber Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
PhoneNumberType Indicator: Telephone is a Mobile Telephone Show values
PhoneIsSMSEnabled Indicator: Telephone is SMS-Enabled Show values
CommNumberIsNotUsed Flag: This Communication Number is Not Used Show values
Column Name Description Domain name
CompleteTelephoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
ValidityStartDateTime Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
ValidityEndDateTime Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • Client
  • Address Number
  • ?
  • ?
  • I_BPMOBILEPHONENUMBER.MANDT == ADRC.CLIENT
  • I_BPMOBILEPHONENUMBER.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPMOBILEPHONENUMBER.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPMOBILEPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Business Partner Number
  • Client
  • Business Partner Number
  • I_BPMOBILEPHONENUMBER.MANDT == BUT000.CLIENT
  • I_BPMOBILEPHONENUMBER.BUSINESSPARTNER == BUT000.PARTNER
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • I_BPMOBILEPHONENUMBER.MANDT == T005.MANDT
  • I_BPMOBILEPHONENUMBER.MOBILEPHONECOUNTRY == T005.LAND1
Person number
  • Client
  • Person Number
  • ?
  • ?
  • I_BPMOBILEPHONENUMBER.MANDT == ADRP.CLIENT
  • I_BPMOBILEPHONENUMBER.PERSON == ADRP.PERSNUMBER
  • I_BPMOBILEPHONENUMBER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BPMOBILEPHONENUMBER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM