/BSNAGT/I_ADRP

ADRP | view: /BSNAGT/IV_ADRP | TRAN | Extraction: Not supported | Component: Connector for SAP Multi-Bank Connectivity
Tables used: ADRP
Column Name Description
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
_dataaging Data Filter Value for Data Aging
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
Language /BSNAGT/I_ADRP.LANGU == T002.SPRAS
Country/Region for Name Format Rule
  • Country/Region for Name Format Rule
  • Client
  • /BSNAGT/I_ADRP.NAMCOUNTRY == T005.LAND1
  • /BSNAGT/I_ADRP.MANDT == T005.MANDT
Version ID for International Addresses /BSNAGT/I_ADRP.NATION == TSADV.NATION
Source of person data
  • Personal data source (key)
  • Client
  • /BSNAGT/I_ADRP.PERSORIGIN == TSAD6.ORIGIN
  • /BSNAGT/I_ADRP.MANDT == TSAD6.CLIENT
Person group /BSNAGT/I_ADRP.PERS_GROUP == TSAD8.PERS_GROUP
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • /BSNAGT/I_ADRP.PREFIX1 == TSAD4.PREFIX_KEY
  • /BSNAGT/I_ADRP.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • /BSNAGT/I_ADRP.MANDT == TSAD4.CLIENT
  • /BSNAGT/I_ADRP.PREFIX2 == TSAD4.PREFIX_KEY
Value for Gender /BSNAGT/I_ADRP.SEX == TSAD15.GENDER
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • /BSNAGT/I_ADRP.TITLE == TSAD3.TITLE
  • /BSNAGT/I_ADRP.MANDT == TSAD3.CLIENT
Academic Title: Key
  • Academic Title: Key
  • Client
  • /BSNAGT/I_ADRP.TITLE_ACA1 == TSAD2.TITLE_KEY
  • /BSNAGT/I_ADRP.MANDT == TSAD2.CLIENT
Second academic title (key)
  • Client
  • Second academic title (key)
  • /BSNAGT/I_ADRP.MANDT == TSAD2.CLIENT
  • /BSNAGT/I_ADRP.TITLE_ACA2 == TSAD2.TITLE_KEY
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • /BSNAGT/I_ADRP.TITLE_SPPL == TSAD5.TITLE_KEY
  • /BSNAGT/I_ADRP.MANDT == TSAD5.CLIENT
Other Relations | to Master Data Relations ↑ Join Conditions
Name format
  • Country/Region for Name Format Rule
  • Name format
  • Client
  • /BSNAGT/I_ADRP.NAMCOUNTRY == T005N.LAND1
  • /BSNAGT/I_ADRP.NAMEFORMAT == T005N.NAMEFORMAT
  • /BSNAGT/I_ADRP.MANDT == T005N.MANDT