I_Employee

Employee | view: IEMPLOYEE | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: /SHCM/HRP5092USR21
Column Name Description
PersonnelNumber Object ID
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Start Date
ValidityEndDate End Date
CreationDate Date on which the object was created
CreationTime Time at which the object was created
LastChangeDate Date when object was last changed
LastChangeTime Time at which object was last changed
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
EmployeeInternalID Business Partner Number BU_PARTNER
Employee Identification Number CHAR60
FormOfAddress Form-of-Address Key AD_TITLE
FamilyName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
GivenName 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
FamilyNamePrefix Name Prefix (Key) AD_PREFIX
Initials "Middle Initial" or personal initials CHAR10
FullName Full Name TEXT80
EmployeeFullName Full Name TEXT80
CorrespondenceLanguage Business Partner: Correspondence Language SPRAS
GenderCode Single-Character Flag CHAR1
BusinessPartnerRole BP Role BU_ROLE
Person Person Number AD_PERSNUM
BusinessPartnerUUID Business Partner GUID SYSUUID
EmployeeImageURL EMPLOYEE_IMAGE_URL /SHCM/EMPLOYEE_IMAGE_URL
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
AuthorizationGroup Authorization Group BU_AUGRP
Master Data Relations Join Conditions
Address key assignment to users
  • User ID
  • User ID
  • Client
  • I_EMPLOYEE.BUSINESSUSER == USR02.BNAME
  • I_EMPLOYEE.USERID == USR02.BNAME
  • I_EMPLOYEE.MANDT == USR02.MANDT
Address key assignment to users
  • User ID
  • User ID
  • Client
  • I_EMPLOYEE.BUSINESSUSER == USR02.BNAME
  • I_EMPLOYEE.USERID == USR02.BNAME
  • I_EMPLOYEE.MANDT == USR02.MANDT