ADR12

FTP and URL (Business Address Services) | #masterdata | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
ADDRNUMBER FK Address Number
PERSNUMBER FK Person Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
CONSNUMBER Sequence Number
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
FLGDEFAULT Flag: this address is the default address Show values
FLG_NOUSE Flag: This Communication Number is Not Used Show values
HOME_FLAG Recipient address in this communication type (mail sys.grp) Show values
URI_TYPE URI type flag Show values
DFT_RECEIV Flag: Recipient is standard recipient for this address Show values
Column Name Description Domain name
URI_SRCH URI address search field CHAR50
URI_LENGTH URI field length AD_URILNG
URI_ADDR Universal Resource Identifier (URI) AD_URI
Master Data Relations Join Conditions
Address number
  • Address Number
  • ?
  • ?
  • ADR12.CLIENT == ADRC.CLIENT
  • ADR12.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADR12.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADR12.[column in domain "AD_NATION"] == ADRC.NATION
Client ADR12.CLIENT == T000.MANDT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • ADR12.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADR12.[column in domain "AD_NATION"] == ADRP.NATION
  • ADR12.CLIENT == ADRP.CLIENT
  • ADR12.PERSNUMBER == ADRP.PERSNUMBER