I_BPAddressIndependentEmail

Root View for Address Independent Email for BP app | view: IBPADDRINDEMAIL | Extraction: Not supported | Component: Business Partners
Tables used: ADRTADR6BUT000
Column Name Description
BusinessPartner Business Partner Number
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
OrdinalNumberForEdit Sequence Number NUMC3
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
  • ?
  • ?
  • Address Number
  • Address Number
  • Client
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPADDRESSINDEPENDENTEMAIL.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPADDRESSINDEPENDENTEMAIL.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • I_BPADDRESSINDEPENDENTEMAIL.MANDT == ADRC.CLIENT
Address number
  • ?
  • ?
  • Address Number
  • Address Number
  • Client
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPADDRESSINDEPENDENTEMAIL.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPADDRESSINDEPENDENTEMAIL.ADDRESSIDFOREDIT == ADRC.ADDRNUMBER
  • I_BPADDRESSINDEPENDENTEMAIL.MANDT == ADRC.CLIENT
Authorization Group
  • ?
  • Authorization Group
  • Client
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BPADDRESSINDEPENDENTEMAIL.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_BPADDRESSINDEPENDENTEMAIL.MANDT == TB037.CLIENT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_NATION"] == ADRP.NATION
  • I_BPADDRESSINDEPENDENTEMAIL.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_BPADDRESSINDEPENDENTEMAIL.MANDT == ADRP.CLIENT
  • I_BPADDRESSINDEPENDENTEMAIL.PERSON == ADRP.PERSNUMBER