I_WorkforcePersonDet

Retrive Workforce Person Details | view: IWRKFRCPERSNDET | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Tables used: BUT0IDBUT000USR21
Column Name Description
Person Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PersonExternalID Identification Number CHAR60
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
MiddleName Middle name or second forename of a person BU_NAME
AdditionalLastName Other Last Name of a Person BU_NAME
PersonFullName Full Name TEXT80
BusinessPartnerUUID Business Partner GUID SYSUUID
Master Data Relations Join Conditions
Authorization Group
  • Authorization Group
  • Client
  • ?
  • I_WORKFORCEPERSONDET.AUTHORIZATIONGROUP == TB037.AUGRP
  • I_WORKFORCEPERSONDET.MANDT == TB037.CLIENT
  • I_WORKFORCEPERSONDET.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
Address key assignment to users
  • User ID
  • Client
  • I_WORKFORCEPERSONDET.USERID == USR02.BNAME
  • I_WORKFORCEPERSONDET.MANDT == USR02.MANDT