ADRT

Communication Data Text (Business Address Services) | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
ADDRNUMBER FK Address Number
PERSNUMBER FK Person Number
COMM_TYPE FK Communication Method (Key) (Business Address Services)
DATE_FROM Valid-from date - in current Release only 00010101 possible
CONSNUMBER Sequence Number
LANGU FK Language Key
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
_DATAAGING Data Filter Value for Data Aging
Column Name Description
Column Name Description Domain name
REMARK Communication link notes TEXT50
Master Data Relations Join Conditions
Address number
  • Address Number
  • ?
  • ?
  • ADRT.CLIENT == ADRC.CLIENT
  • ADRT.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADRT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADRT.[column in domain "AD_NATION"] == ADRC.NATION
Client ADRT.CLIENT == T000.MANDT
Communication Method ADRT.COMM_TYPE == TSAC.COMM_TYPE
Language ADRT.LANGU == T002.SPRAS
Person number
  • ?
  • ?
  • Client
  • Person Number
  • ADRT.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADRT.[column in domain "AD_NATION"] == ADRP.NATION
  • ADRT.CLIENT == ADRP.CLIENT
  • ADRT.PERSNUMBER == ADRP.PERSNUMBER