I_WorkplaceAddress

Employee Workplace Address | view: IEMPWPADDR | ATTR | Extraction: Full only | Component: Business Partner Foundation
Tables used: ADCPADR2ADR3ADR6BUT000MOM052
Column Name Description
BusinessPartnerUUID Business Partner GUID
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
ValidityEndDate null
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
NormalizedPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
MobilePhoneNumber Telephone no.: dialling code+number CHAR30
MblNormalizedPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
FaxAreaCodeSubscriberNumber Fax number: dialling code+number CHAR30
FaxExtensionNumber Fax no.: Extension CHAR10
InternationalFaxNumber Complete number: dialling code+number+extension CHAR30
DefaultEmailAddress E-Mail Address AD_SMTPADR
Building Building (number or code) TEXT10
RoomNumber Room or Apartment Number TEXT10
Floor Floor in building TEXT10
FunctionalTitlename Function TEXT40
Department Department TEXT40
Master Data Relations Join Conditions
Address key
  • ?
  • Client
  • Address Number
  • ?
  • I_WORKPLACEADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_WORKPLACEADDRESS.MANDT == ADRC.CLIENT
  • I_WORKPLACEADDRESS.ADDRESSID == ADRC.ADDRNUMBER
  • I_WORKPLACEADDRESS.[column in domain "AD_NATION"] == ADRC.NATION
Authorization Group
  • ?
  • Authorization Group
  • Client
  • I_WORKPLACEADDRESS.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_WORKPLACEADDRESS.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_WORKPLACEADDRESS.MANDT == TB037.CLIENT
Standard communication type I_WORKPLACEADDRESS.COMMUNICATIONMEDIUMTYPE == TSAC.COMM_TYPE
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_WORKPLACEADDRESS.MANDT == T005.MANDT
  • I_WORKPLACEADDRESS.FAXNUMBERCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_WORKPLACEADDRESS.MANDT == T005.MANDT
  • I_WORKPLACEADDRESS.FAXNUMBERCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1
Country key
  • Client
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • I_WORKPLACEADDRESS.MANDT == T005.MANDT
  • I_WORKPLACEADDRESS.FAXNUMBERCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.DESTINATIONLOCATIONCOUNTRY == T005.LAND1
  • I_WORKPLACEADDRESS.MBLPHONEDESTINATIONLOCCOUNTRY == T005.LAND1