P_EmployeeUnion

Employee union view | view: PEMPLOYEEUNION | Extraction: Not supported | Component: HCM Business Partner Integration
Column Name Description
PersonnelNumber FK 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
FamilyName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
LastName Search Help Field 1 (Name 1/Last Name) CHAR35
BusinessPartnerName Search Help Field 2 (Name 2/First Name) CHAR35
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
Initials "Middle Initial" or personal initials CHAR10
FullName Full Name TEXT80
EmployeeFullName Full Name TEXT80
GenderCode null
BusinessUser null
UserID null
EmployeeImageURL null
BusinessPartnerRole BP Role BU_ROLE
Person Person Number AD_PERSNUM
BusinessPartnerUUID Business Partner GUID SYSUUID
CreatedByUser User who created the object USNAM
LastChangedByUser Last user to change object USNAM
Master Data Relations Join Conditions
Academic Title: Key
  • Academic Title: Key
  • Client
  • P_EMPLOYEEUNION.ACADEMICTITLE == TSAD2.TITLE_KEY
  • P_EMPLOYEEUNION.MANDT == TSAD2.CLIENT
Authorization Group
  • Authorization Group
  • ?
  • Client
  • P_EMPLOYEEUNION.AUTHORIZATIONGROUP == TB037.AUGRP
  • P_EMPLOYEEUNION.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_EMPLOYEEUNION.MANDT == TB037.CLIENT
Correspondence Language P_EMPLOYEEUNION.CORRESPONDENCELANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • P_EMPLOYEEUNION.FAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_EMPLOYEEUNION.MANDT == TSAD4.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • P_EMPLOYEEUNION.MANDT == TSAD3.CLIENT
  • P_EMPLOYEEUNION.FORMOFADDRESS == TSAD3.TITLE
Object ID
  • Client
  • ?
  • ?
  • Object ID
  • P_EMPLOYEEUNION.MANDT == PLOGI.MANDT
  • P_EMPLOYEEUNION.[column in domain "PLVAR"] == PLOGI.PLVAR
  • P_EMPLOYEEUNION.[column in domain "OTYPE"] == PLOGI.OTYPE
  • P_EMPLOYEEUNION.PERSONNELNUMBER == PLOGI.OBJID