I_EmployeeDetails

Employee Details | view: IEMPLOYEEDETAILS | Extraction: Not supported | Component: HCM Business Partner Integration
Column Name Description
PersonnelNumber Object ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
EmployeeInternalID Business Partner Number BU_PARTNER
Employee Identification Number CHAR60
FormOfAddress Form-of-Address Key AD_TITLE
FormOfAddressName Title text TEXT30
FamilyName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
MiddleName Middle name or second forename of a person BU_NAME
AdditionalFamilyName Other Last Name of a Person BU_NAME
AcademicTitle Academic Title: Key AD_TITLE1
AcademicTitleName Academic Title: Written Form TEXT20
FamilyNamePrefix Name Prefix (Key) AD_PREFIX
FamilyNamePrefixName Name prefix TEXT20
Initials "Middle Initial" or personal initials CHAR10
EmployeeFullName Full Name TEXT80
CorrespondenceLanguage Business Partner: Correspondence Language SPRAS
CorrespondenceLanguageName Name of Language SPTXT16
GenderCode Single-Character Flag CHAR1
GenderCodeName Gender Name DDTEXT
EmployeeImageURL EMPLOYEE_IMAGE_URL /SHCM/EMPLOYEE_IMAGE_URL
BusinessPartnerRole BP Role BU_ROLE
BusinessPartnerRoleName BP Role Title TEXT25
Master Data Relations Join Conditions
Address key assignment to users
  • User ID
  • Client
  • I_EMPLOYEEDETAILS.USERID == USR02.BNAME
  • I_EMPLOYEEDETAILS.MANDT == USR02.MANDT