I_AddressPersonName

Person Name | view: IADDRPERSONNAME | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADRP
Column Name Description
AddressPersonID Person Number
AddressRepresentationCode FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
GivenName First name TEXT40
FamilyName Last name TEXT40
PersonBirthName Name of person at birth TEXT40
PersonMiddleName Middle name or second forename of a person TEXT40
SecondFamilyName Other Last Name of a Person TEXT40
PersonNickname Nickname or name used TEXT40
NameInitials "Middle Initial" or personal initials CHAR10
PersonFullName Full Name of Person TEXT80
AddressPersonSearchTerm1 Search Term 1 CHAR20
AddressPersonSearchTerm2 Search Term 2 CHAR20
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_ADDRESSPERSONNAME.MANDT == TSAD2.CLIENT
  • I_ADDRESSPERSONNAME.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Second academic title (key)
  • Client
  • I_ADDRESSPERSONNAME.ACADEMICTITLE2 == TSAD2.TITLE_KEY
  • I_ADDRESSPERSONNAME.MANDT == TSAD2.CLIENT
Version ID for International Addresses I_ADDRESSPERSONNAME.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Language I_ADDRESSPERSONNAME.CORRESPONDENCELANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • I_ADDRESSPERSONNAME.FAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • I_ADDRESSPERSONNAME.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_ADDRESSPERSONNAME.MANDT == TSAD4.CLIENT
  • I_ADDRESSPERSONNAME.FAMILYNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • I_ADDRESSPERSONNAME.FORMOFADDRESS == TSAD3.TITLE
  • I_ADDRESSPERSONNAME.MANDT == TSAD3.CLIENT
Name supplement, e.g. noble title (key)
  • Client
  • Name supplement, e.g. noble title (key)
  • I_ADDRESSPERSONNAME.MANDT == TSAD5.CLIENT
  • I_ADDRESSPERSONNAME.PERSONNAMESUPPLEMENTCODE == TSAD5.TITLE_KEY