P_Emplprivpostaddr

Employee Postal Address | view: PEMPLPRVPOSTADDR | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: ADRC
Column Name Description
AddressID Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
CityName City TEXT40
HomeCityName City (different from postal city) TEXT40
District District TEXT40
PostalCode City postal code CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
CareOfName c/o name TEXT40
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • P_EMPLPRIVPOSTADDR.COUNTRY == T005.LAND1
  • P_EMPLPRIVPOSTADDR.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • P_EMPLPRIVPOSTADDR.COUNTRY == T005S.LAND1
  • P_EMPLPRIVPOSTADDR.MANDT == T005S.MANDT
  • P_EMPLPRIVPOSTADDR.REGION == T005S.BLAND