I_BPAddlSuplrEmailAddressTP

BO view for email for MLTAS suppliers | view: IBPADDSEATP | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR6BUT020MDG_MLT_ASSGMNTBUT000LFA1
Column Name Description
BusinessPartner Business Partner Number
Supplier Account Number of Supplier
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
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Address number
  • Client
  • ?
  • ?
  • Address Number
  • I_BPADDLSUPLREMAILADDRESSTP.MANDT == ADRC.CLIENT
  • I_BPADDLSUPLREMAILADDRESSTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPADDLSUPLREMAILADDRESSTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPADDLSUPLREMAILADDRESSTP.ADDRESSID == ADRC.ADDRNUMBER