I_BPEmailAddressTP

Business Partner Email BO view | view: IBPEMAILADDRTP | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR6BUT020BUT000
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
OrdinalNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsDefaultEmailAddress Flag: this address is the default address Show values
IsHomeEmailAddress Recipient address in this communication type (mail sys.grp) Show values
Column Name Description Domain name
EmailAddress E-Mail Address AD_SMTPADR
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • Address Number
  • Client
  • ?
  • ?
  • I_BPEMAILADDRESSTP.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPEMAILADDRESSTP.MANDT == ADRC.CLIENT
  • I_BPEMAILADDRESSTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPEMAILADDRESSTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Business Partner Number
  • Client
  • Business Partner Number
  • I_BPEMAILADDRESSTP.MANDT == BUT000.CLIENT
  • I_BPEMAILADDRESSTP.BUSINESSPARTNER == BUT000.PARTNER