I_Addressindependentemail

Core view Addr Indep Email | view: IADDRINDEMAIL | Extraction: Not supported | Component: SAP Business Partner
Tables used: ADR6
Column Name Description
AddressID FK Address Number
Person FK Person 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
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_ADDRESSINDEPENDENTEMAIL.ADDRESSID == ADRC.ADDRNUMBER
  • I_ADDRESSINDEPENDENTEMAIL.MANDT == ADRC.CLIENT
  • I_ADDRESSINDEPENDENTEMAIL.[column in domain "AD_NATION"] == ADRC.NATION
  • I_ADDRESSINDEPENDENTEMAIL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Person number
  • Client
  • Person Number
  • ?
  • ?
  • I_ADDRESSINDEPENDENTEMAIL.MANDT == ADRP.CLIENT
  • I_ADDRESSINDEPENDENTEMAIL.PERSON == ADRP.PERSNUMBER
  • I_ADDRESSINDEPENDENTEMAIL.[column in domain "AD_NATION"] == ADRP.NATION
  • I_ADDRESSINDEPENDENTEMAIL.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM