I_AddressEmailAddress_2

Email Address | view: IADDREMAILADDR2 | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADR6
Column Name Description
AddressID FK Address Number
AddressPersonID FK Person Number
CommMediumSequenceNumber Sequence Number
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
ValidityEndDate null
Column Name Description
EmailAddressIsCurrentDefault Flag: this address is the default address Show values
Column Name Description Domain name
EmailAddress E-Mail Address AD_SMTPADR
Master Data Relations Join Conditions
Address number
  • Client
  • ?
  • ?
  • Address Number
  • I_ADDRESSEMAILADDRESS_2.MANDT == ADRC.CLIENT
  • I_ADDRESSEMAILADDRESS_2.[column in domain "AD_NATION"] == ADRC.NATION
  • I_ADDRESSEMAILADDRESS_2.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_ADDRESSEMAILADDRESS_2.ADDRESSID == ADRC.ADDRNUMBER
Person number
  • Client
  • ?
  • ?
  • Person Number
  • I_ADDRESSEMAILADDRESS_2.MANDT == ADRP.CLIENT
  • I_ADDRESSEMAILADDRESS_2.[column in domain "AD_NATION"] == ADRP.NATION
  • I_ADDRESSEMAILADDRESS_2.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSEMAILADDRESS_2.ADDRESSPERSONID == ADRP.PERSNUMBER