I_AddressWorkplaceDetails

Person Workplace Address Details | view: IADDRWORKPLACE | Extraction: Not supported | Component: Address Management/Business Address
Tables used: 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
AddressIsWorkplaceAddress Indicator: The address is a workplace address Show values
Column Name Description Domain name
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
Address key
  • ?
  • Address Number
  • Version ID for International Addresses
  • Client
  • I_ADDRESSWORKPLACEDETAILS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_ADDRESSWORKPLACEDETAILS.ADDRESSID == ADRC.ADDRNUMBER
  • I_ADDRESSWORKPLACEDETAILS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
  • I_ADDRESSWORKPLACEDETAILS.MANDT == ADRC.CLIENT
Key of person
  • ?
  • Version ID for International Addresses
  • Client
  • Person Number
  • I_ADDRESSWORKPLACEDETAILS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_ADDRESSWORKPLACEDETAILS.ADDRESSREPRESENTATIONCODE == ADRP.NATION
  • I_ADDRESSWORKPLACEDETAILS.MANDT == ADRP.CLIENT
  • I_ADDRESSWORKPLACEDETAILS.ADDRESSPERSONID == ADRP.PERSNUMBER
Version ID for International Addresses I_ADDRESSWORKPLACEDETAILS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Standard communication type I_ADDRESSWORKPLACEDETAILS.WORKPLACEPRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE