P_EMPCONSUMPTION

Employee Consumption View | view: PEMPCONSUMPTION | Extraction: Not supported | Component: HCM Business Partner Integration
Tables used: /SHCM/HRP5092BUT050USR21
Column Name Description
Employee Identification Number
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Start Date
ValidityEndDate End Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
currentdate null
currtimestmp null
EmployeeInternalID Business Partner Number BU_PARTNER
PersonnelNumber Object ID HROBJID
FormOfAddress Form-of-Address Key AD_TITLE
FamilyName Last 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
EmployeeFullName Full Name TEXT80
CorrespondenceLanguage Business Partner: Correspondence Language SPRAS
GenderCode Single-Character Flag CHAR1
Person Person Number AD_PERSNUM
BusinessPartnerUUID Business Partner GUID SYSUUID
EmployeeImageURL EMPLOYEE_IMAGE_URL /SHCM/EMPLOYEE_IMAGE_URL
BusinessPartnerRole BP Role BU_ROLE
SupplierText null
EmployeeText null
MainEmploymentInternalID null
ContentType null
ManagerFullName null
ManagerEmployee null
Job null
Costcenter null
Department null
CompanyCode null
CompanyName null
ControllingArea null
ServiceCostLevel null
ServiceCostLevelName null
EmploymentStatus null
EmployeeExtID null
SupplierTxt null
CostLevel null
CostLevel_fc null
AuthorizationGroup Authorization Group BU_AUGRP
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • P_EMPCONSUMPTION.SUPPLIER == BUT000.PARTNER
  • P_EMPCONSUMPTION.MANDT == BUT000.CLIENT
Address key assignment to users
  • Client
  • User ID
  • P_EMPCONSUMPTION.MANDT == USR02.MANDT
  • P_EMPCONSUMPTION.USERID == USR02.BNAME