I_PersonAddress

Address of a Person | view: IPERSONADDRESS | Extraction: Not supported | Component: Address Management/Business Address
Tables used: ADRP, ADCP, ADRC
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
AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
RegionalStructureCheckStatus City file test status Show values
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
CityName City TEXT40
DistrictName District TEXT40
VillageName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
StreetName Street TEXT60
StreetPrefixName1 Street 2 TEXT40
StreetPrefixName2 Street 3 TEXT40
StreetSuffixName1 Street 4 TEXT40
StreetSuffixName2 Street 5 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
TaxJurisdiction Tax Jurisdiction AD_TXJCD
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
CareOfName c/o name TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
SecondaryRegion County code for county CNTY_CODE
SecondaryRegionName County TEXT40
TertiaryRegion Township code for Township TWSHP_CODE
TertiaryRegionName Township TEXT40
Master Data Relations Join Conditions
Academic Title: Key
  • Client
  • Academic Title: Key
  • I_PERSONADDRESS.MANDT == TSAD2.CLIENT
  • I_PERSONADDRESS.ACADEMICTITLE == TSAD2.TITLE_KEY
Second academic title (key)
  • Client
  • Second academic title (key)
  • I_PERSONADDRESS.MANDT == TSAD2.CLIENT
  • I_PERSONADDRESS.ACADEMICTITLE2 == TSAD2.TITLE_KEY
Address key
  • ?
  • Address Number
  • Client
  • Version ID for International Addresses
  • I_PERSONADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_PERSONADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_PERSONADDRESS.MANDT == ADRC.CLIENT
  • I_PERSONADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Key of person
  • Person Number
  • ?
  • Client
  • Version ID for International Addresses
  • I_PERSONADDRESS.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_PERSONADDRESS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_PERSONADDRESS.MANDT == ADRP.CLIENT
  • I_PERSONADDRESS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
Version ID for International Addresses I_PERSONADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Client
  • Address time zone
  • I_PERSONADDRESS.MANDT == TTZZ.CLIENT
  • I_PERSONADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
City code for city/street file
  • City code for city/street file
  • Country/Region Key
  • Client
  • I_PERSONADDRESS.CITYNUMBER == ADRCITY.CITY_CODE
  • I_PERSONADDRESS.COUNTRY == ADRCITY.COUNTRY
  • I_PERSONADDRESS.MANDT == ADRCITY.CLIENT
Language I_PERSONADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Country/Region Key
  • Client
  • I_PERSONADDRESS.COUNTRY == T005.LAND1
  • I_PERSONADDRESS.MANDT == T005.MANDT
Address Delivery service type text table
  • ?
  • Type of Delivery Service
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • I_PERSONADDRESS.FAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • I_PERSONADDRESS.MANDT == TSAD4.CLIENT
2nd name prefix (key)
  • Client
  • 2nd name prefix (key)
  • I_PERSONADDRESS.MANDT == TSAD4.CLIENT
  • I_PERSONADDRESS.FAMILYNAMESECONDPREFIX == TSAD4.PREFIX_KEY
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_PERSONADDRESS.MANDT == TSAD3.CLIENT
  • I_PERSONADDRESS.FORMOFADDRESS == TSAD3.TITLE
Name supplement, e.g. noble title (key)
  • Name supplement, e.g. noble title (key)
  • Client
  • I_PERSONADDRESS.PERSONNAMESUPPLEMENTCODE == TSAD5.TITLE_KEY
  • I_PERSONADDRESS.MANDT == TSAD5.CLIENT
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • I_PERSONADDRESS.MANDT == TSAD12.CLIENT
  • I_PERSONADDRESS.POBOXADDRNONDELIVERABLEREASON == TSAD12.UNDELIVER
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_PERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_PERSONADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • I_PERSONADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_PERSONADDRESS.MANDT == T005S.MANDT
  • I_PERSONADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Communication Method I_PERSONADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_PERSONADDRESS.COUNTRY == T005S.LAND1
  • I_PERSONADDRESS.MANDT == T005S.MANDT
  • I_PERSONADDRESS.REGION == T005S.BLAND
Street Number for City/Street File
  • Country/Region Key
  • Client
  • Street Number for City/Street File
Non-Delivery Reason
  • Client
  • Street Address Undeliverable Flag
  • I_PERSONADDRESS.MANDT == TSAD12.CLIENT
  • I_PERSONADDRESS.STREETADDRNONDELIVERABLEREASON == TSAD12.UNDELIVER
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • I_PERSONADDRESS.COUNTRY == TZONE.LAND1
  • I_PERSONADDRESS.MANDT == TZONE.MANDT
  • I_PERSONADDRESS.TRANSPORTZONE == TZONE.ZONE1