I_BPEmailAddress

Business Partner Email Core View | view: IBPEMAILADDR | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADR6BUT020BUT000
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
OrdinalNumber Sequence Number
Person FK Person 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
CommNumberIsNotUsed Flag: This Communication Number is Not Used Show values
Column Name Description Domain name
EmailAddress E-Mail Address AD_SMTPADR
ValidityStartDateTime Communication Data: Valid From (YYYYMMDDHHMMSS) TIMESTMP
ValidityEndDateTime Communication Data: Valid To (YYYYMMDDHHMMSS) TIMESTAMP
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • I_BPEMAILADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPEMAILADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPEMAILADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPEMAILADDRESS.MANDT == ADRC.CLIENT
Business Partner Number
  • Business Partner Number
  • Client
  • I_BPEMAILADDRESS.BUSINESSPARTNER == BUT000.PARTNER
  • I_BPEMAILADDRESS.MANDT == BUT000.CLIENT
Person number
  • ?
  • ?
  • Person Number
  • Client
  • I_BPEMAILADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BPEMAILADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_BPEMAILADDRESS.PERSON == ADRP.PERSNUMBER
  • I_BPEMAILADDRESS.MANDT == ADRP.CLIENT