I_BPAddlCustMblPhNumberTP

BO view for Mob Ph of MLTAS Customers | view: IBPADDCMPNTP | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR2BUT020MDG_MLT_ASSGMNTBUT000KNA1
Column Name Description
BusinessPartner Business Partner Number
Customer Customer 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
Column Name Description Domain name
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • I_BPADDLCUSTMBLPHNUMBERTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPADDLCUSTMBLPHNUMBERTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPADDLCUSTMBLPHNUMBERTP.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPADDLCUSTMBLPHNUMBERTP.MANDT == ADRC.CLIENT
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • I_BPADDLCUSTMBLPHNUMBERTP.MANDT == T005.MANDT
  • I_BPADDLCUSTMBLPHNUMBERTP.MOBILEPHONECOUNTRY == T005.LAND1
Person number
  • ?
  • ?
  • Person Number
  • Client
  • I_BPADDLCUSTMBLPHNUMBERTP.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BPADDLCUSTMBLPHNUMBERTP.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_BPADDLCUSTMBLPHNUMBERTP.PERSON == ADRP.PERSNUMBER
  • I_BPADDLCUSTMBLPHNUMBERTP.MANDT == ADRP.CLIENT