ADRVPS

Shadow Table: Where-Used List for Persons (BAS) | #masterdata | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
TRKORR Request/Task
PERSNUMBER FK Person Number
CONSNUMBER Where-used list serial number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PERS_ADDR Flag: Personal address used for person Show values
OWNER Flag: Reference of Owner Object of Address Show values
Column Name Description Domain name
APPL_TABLE Application table logical name (address management) CHAR10
APPL_FIELD Application table personal reference logical field name CHAR10
APPL_KEY Application table key (incl. client) TEXT120
Master Data Relations Join Conditions
Address number to which the person reference relates
  • Address number to which the person reference relates
  • ?
  • ?
  • ADRVPS.CLIENT == ADRC.CLIENT
  • ADRVPS.ADDRNUMBER == ADRC.ADDRNUMBER
  • ADRVPS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ADRVPS.[column in domain "AD_NATION"] == ADRC.NATION
Client ADRVPS.CLIENT == T000.MANDT
Person number
  • ?
  • ?
  • Client
  • Person Number
  • ADRVPS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • ADRVPS.[column in domain "AD_NATION"] == ADRP.NATION
  • ADRVPS.CLIENT == ADRP.CLIENT
  • ADRVPS.PERSNUMBER == ADRP.PERSNUMBER
Person Groups ADRVPS.PERS_GROUP == TSAD8.PERS_GROUP