ADRPS

Shadow Table: Persons (Business Address Services) | #masterdata | #language | Component: Address Management/Business Address
Column Name Description
CLIENT FK Client
TRKORR Request/Task
PERSNUMBER Person Number
DATE_FROM Valid-from date - in current Release only 00010101 possible
NATION FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
DATE_FROM Valid-from date - in current Release only 00010101 possible
DATE_TO Valid-to date in current Release only 99991231 possible
Column Name Description
CONVERTED Status of Field 'Full Name' NAME_TEXT Show values
FLAGGROUPS Flag: There are other person group assignments Show values
FLPERSTEL Flag: person has personal telephone numbers Show values
FLPERSCOMM Flag: Person has personal comm. numbers (apart from Tel.) Show values
UUID_BELATED Indicator: UUID created later Show values
ID_CATEGORY Category of an Address ID Show values
ADRP_ERR_STATUS Error Status of Address Show values
Column Name Description Domain name
NAME_FIRST First name TEXT40
NAME_LAST Last name TEXT40
NAME2 Name of person at birth TEXT40
NAMEMIDDLE Middle name or second forename of a person TEXT40
NAME_LAST2 Other Last Name of a Person TEXT40
NAME_TEXT Full Name of Person TEXT80
NICKNAME Nickname or name used TEXT40
INITIALS "Middle Initial" or personal initials CHAR10
PROFESSION Profession TEXT40
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR20
ADDR_COMP (not used) AD_ADDRNUM
ADDR_PERS (not used) AD_ADDRNUM
MC_NAMEFIR First Name in Uppercase for Search Help CHAR25
MC_NAMELAS Last Name in Uppercase for Search Help CHAR25
MC_NAME2 Field NAME2 in Uppercase for Matchcode CHAR25
LANGU_CREA Address record creation original language SPRAS
ADRP_UUID UUID Used in the Address SYSUUID
Master Data Relations Join Conditions
Client ADRPS.CLIENT == T000.MANDT
Language ADRPS.LANGU == T002.SPRAS
Country/Region for Name Format Rule
  • Country/Region for Name Format Rule
  • Client
  • ADRPS.NAMCOUNTRY == T005.LAND1
  • ADRPS.CLIENT == T005.MANDT
Version ID for International Addresses ADRPS.NATION == TSADV.NATION
Source of person data
  • ADRPS.CLIENT == TSAD6.CLIENT
  • ADRPS.PERSORIGIN == TSAD6.ORIGIN
Person group ADRPS.PERS_GROUP == TSAD8.PERS_GROUP
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • ADRPS.PREFIX1 == TSAD4.PREFIX_KEY
  • ADRPS.CLIENT == TSAD4.CLIENT
2nd name prefix (key)
  • 2nd name prefix (key)
  • Client
  • ADRPS.PREFIX2 == TSAD4.PREFIX_KEY
  • ADRPS.CLIENT == TSAD4.CLIENT
Value Help for Gender ADRPS.SEX == TSAD15.GENDER
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • ADRPS.TITLE == TSAD3.TITLE
  • ADRPS.CLIENT == TSAD3.CLIENT
Academic Title: Key
  • ADRPS.CLIENT == TSAD2.CLIENT
  • ADRPS.TITLE_ACA1 == TSAD2.TITLE_KEY
Second academic title (key)
  • ADRPS.CLIENT == TSAD2.CLIENT
  • ADRPS.TITLE_ACA2 == TSAD2.TITLE_KEY
Name supplement, e.g. noble title (key)
  • ADRPS.CLIENT == TSAD5.CLIENT
  • ADRPS.TITLE_SPPL == TSAD5.TITLE_KEY
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Country/Region for Name Format Rule
  • Name format
  • ADRPS.CLIENT == T005N.MANDT
  • ADRPS.NAMCOUNTRY == T005N.LAND1
  • ADRPS.NAMEFORMAT == T005N.NAMEFORMAT