I_AddressCommunicationRemark_2

Remark for Communication Data | view: IADDRCOMMREMARK2 | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADRT
Column Name Description
AddressID FK Address Number
AddressPersonID FK Person Number
CommunicationMediumType FK Communication Method (Key) (Business Address Services)
CommMediumSequenceNumber Sequence Number
Language FK Language Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CommunicationRemarkText Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • ?
  • ?
  • Address Number
  • Client
  • I_ADDRESSCOMMUNICATIONREMARK_2.[column in domain "AD_NATION"] == ADRC.NATION
  • I_ADDRESSCOMMUNICATIONREMARK_2.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_ADDRESSCOMMUNICATIONREMARK_2.ADDRESSID == ADRC.ADDRNUMBER
  • I_ADDRESSCOMMUNICATIONREMARK_2.MANDT == ADRC.CLIENT
Person number
  • ?
  • ?
  • Person Number
  • Client
  • I_ADDRESSCOMMUNICATIONREMARK_2.[column in domain "AD_NATION"] == ADRP.NATION
  • I_ADDRESSCOMMUNICATIONREMARK_2.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSCOMMUNICATIONREMARK_2.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_ADDRESSCOMMUNICATIONREMARK_2.MANDT == ADRP.CLIENT
Communication Method I_ADDRESSCOMMUNICATIONREMARK_2.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Language I_ADDRESSCOMMUNICATIONREMARK_2.LANGUAGE == T002.SPRAS