I_BPEmplWorkplaceAddrTP

Business Partner Employee Workplace address - TP | view: IBPWPADDRTP | Extraction: Not supported | Component: Business Partners
Tables used: ADR6ADR3ADRPADR2ADCPADRCMOM052BUT000
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
BusinessPartnerUUID Business Partner GUID SYSUUID
AddressPersonID Person Number AD_PERSNUM
StreetName Street TEXT60
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode City postal code CHAR10
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
EmailAddress E-Mail Address AD_SMTPADR
WorkplaceBuilding Building (number or code) TEXT10
WorkplaceFloor Floor in building TEXT10
WorkplaceDepartmentName Department TEXT40
WorkplaceFunctionalTitleName Function TEXT40
WorkplaceRoomNumber Room or Apartment Number TEXT10
Master Data Relations Join Conditions
Address Number
  • ?
  • ?
  • Client
  • Address Number
  • I_BPEMPLWORKPLACEADDRTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPEMPLWORKPLACEADDRTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPEMPLWORKPLACEADDRTP.MANDT == ADRC.CLIENT
  • I_BPEMPLWORKPLACEADDRTP.ADDRESSID == ADRC.ADDRNUMBER
Address time zone
  • Client
  • Address time zone
  • I_BPEMPLWORKPLACEADDRTP.MANDT == TTZZ.CLIENT
  • I_BPEMPLWORKPLACEADDRTP.ADDRESSTIMEZONE == TTZZ.TZONE
Authorization Group
  • ?
  • Authorization Group
  • Client
  • I_BPEMPLWORKPLACEADDRTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_BPEMPLWORKPLACEADDRTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_BPEMPLWORKPLACEADDRTP.MANDT == TB037.CLIENT
Country key
  • Country/Region Key
  • Client
  • I_BPEMPLWORKPLACEADDRTP.COUNTRY == T005.LAND1
  • I_BPEMPLWORKPLACEADDRTP.MANDT == T005.MANDT
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_BPEMPLWORKPLACEADDRTP.COUNTRY == T005S.LAND1
  • I_BPEMPLWORKPLACEADDRTP.MANDT == T005S.MANDT
  • I_BPEMPLWORKPLACEADDRTP.REGION == T005S.BLAND