I_PersonWorkplaceAddress

Corporate Workplace Address of a Person | view: IWORKPLACEADDR | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADRP, ADCP
Column Name Description
AddressID FK Address Number
AddressPersonID FK 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
WorkplaceBuilding Building (number or code) TEXT10
WorkplaceFloor Floor in building TEXT10
WorkplaceRoomNumber Room or Apartment Number TEXT10
WorkplaceFunctionalTitleName Function TEXT40
WorkplaceDepartmentName Department TEXT40
WorkplaceCorrespncShortName Short name for correspondence TEXT10
WorkplaceInhouseMail Internal Mail Postal Code TEXT10
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD2.CLIENT
  • I_PERSONWORKPLACEADDRESS.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD2.CLIENT
  • I_PERSONWORKPLACEADDRESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY
Address key
  • ?
  • Address Number
  • Client
  • Version ID for International Addresses
  • I_PERSONWORKPLACEADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_PERSONWORKPLACEADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_PERSONWORKPLACEADDRESS.MANDT == ADRC.CLIENT
  • I_PERSONWORKPLACEADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Key of person
  • ?
  • Client
  • Person Number
  • Version ID for International Addresses
  • I_PERSONWORKPLACEADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_PERSONWORKPLACEADDRESS.MANDT == ADRP.CLIENT
  • I_PERSONWORKPLACEADDRESS.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_PERSONWORKPLACEADDRESS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
Version ID for International Addresses I_PERSONWORKPLACEADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Language I_PERSONWORKPLACEADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • I_PERSONWORKPLACEADDRESS.FAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD4.CLIENT
  • I_PERSONWORKPLACEADDRESS.FAMILYNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD3.CLIENT
  • I_PERSONWORKPLACEADDRESS.FORMOFADDRESS == TSAD3.TITLE
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • I_PERSONWORKPLACEADDRESS.PERSONNAMESUPPLEMENTCODE == TSAD5.TITLE_KEY
  • I_PERSONWORKPLACEADDRESS.MANDT == TSAD5.CLIENT
Standard communication type I_PERSONWORKPLACEADDRESS.WORKPLACEPRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE