A_AddressEmailAddress

Email Address | view: AADDREMAILADDR | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR6BUT000BUT020
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
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
EmailAddress E-Mail Address AD_SMTPADR
SearchEmailAddress E-Mail Address Search Field CHAR20
AddressCommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • Client
  • Address Number
  • ?
  • ?
  • A_ADDRESSEMAILADDRESS.MANDT == ADRC.CLIENT
  • A_ADDRESSEMAILADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • A_ADDRESSEMAILADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
  • A_ADDRESSEMAILADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Authorization Group
  • Client
  • Authorization Group
  • ?
  • A_ADDRESSEMAILADDRESS.MANDT == TB037.CLIENT
  • A_ADDRESSEMAILADDRESS.AUTHORIZATIONGROUP == TB037.AUGRP
  • A_ADDRESSEMAILADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Business Partner Number
  • Client
  • Business Partner Number
  • A_ADDRESSEMAILADDRESS.MANDT == BUT000.CLIENT
  • A_ADDRESSEMAILADDRESS.BUSINESSPARTNER == BUT000.PARTNER
Person number
  • Client
  • Person Number
  • ?
  • ?
  • A_ADDRESSEMAILADDRESS.MANDT == ADRP.CLIENT
  • A_ADDRESSEMAILADDRESS.PERSON == ADRP.PERSNUMBER
  • A_ADDRESSEMAILADDRESS.[column in domain "AD_NATION"] == ADRP.NATION
  • A_ADDRESSEMAILADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM