C_BPEmplWorkplaceAddr

Business Partner Employee Workplace address | view: CBPEMPWORKADDR | 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
EmailAddress E-Mail Address AD_SMTPADR
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
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
  • ?
  • ?
  • C_BPEMPLWORKPLACEADDR.MANDT == ADRC.CLIENT
  • C_BPEMPLWORKPLACEADDR.ADDRESSID == ADRC.ADDRNUMBER
  • C_BPEMPLWORKPLACEADDR.[column in domain "AD_NATION"] == ADRC.NATION
  • C_BPEMPLWORKPLACEADDR.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Address time zone
  • Client
  • Address time zone
  • C_BPEMPLWORKPLACEADDR.MANDT == TTZZ.CLIENT
  • C_BPEMPLWORKPLACEADDR.ADDRESSTIMEZONE == TTZZ.TZONE
Authorization Group
  • Authorization Group
  • Client
  • ?
  • C_BPEMPLWORKPLACEADDR.AUTHORIZATIONGROUP == TB037.AUGRP
  • C_BPEMPLWORKPLACEADDR.MANDT == TB037.CLIENT
  • C_BPEMPLWORKPLACEADDR.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Country key
  • Client
  • Country/Region Key
  • C_BPEMPLWORKPLACEADDR.MANDT == T005.MANDT
  • C_BPEMPLWORKPLACEADDR.COUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • C_BPEMPLWORKPLACEADDR.MANDT == T005S.MANDT
  • C_BPEMPLWORKPLACEADDR.REGION == T005S.BLAND
  • C_BPEMPLWORKPLACEADDR.COUNTRY == T005S.LAND1