R_WORKFORCEPERSON
Workforce Person data
R_WORKFORCEPERSON is a CDS View in S/4HANA. Workforce Person data. It contains 41 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_WorkPersonDetail | view | inner | CONSUMPTION | Fetch work person info for Guided Buying |
| R_WorkforcePersonFactSheet | view_entity | from | COMPOSITE | Worker Data |
| R_WorkforcePersonSummary | view_entity | from | COMPOSITE | Workforce Person Summary |
| R_WorkforcePersonTP | view_entity | from | TRANSACTIONAL | Workforce Person TP |
Fields (41)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PersonUUID | PersonUUID | 2 |
| _EntrySourceText | _EntrySourceText | 1 | |
| AcademicTitle | AcademicTitle | 1 | |
| AcademicTitle2 | AcademicTitle2 | 1 | |
| AdditionalLastName | AdditionalLastName | 1 | |
| AuthorizationGroup | AuthorizationGroup | 2 | |
| BusinessPartnerBirthName | BusinessPartnerBirthName | 1 | |
| BusinessPartnerNicknameLabel | BusinessPartnerNicknameLabel | 1 | |
| BusinessPartnerSupplementName | BusinessPartnerSupplementName | 1 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 1 | |
| DataController1 | DataController1 | 2 | |
| DataController10 | DataController10 | 2 | |
| DataController2 | DataController2 | 2 | |
| DataController3 | DataController3 | 2 | |
| DataController4 | DataController4 | 2 | |
| DataController5 | DataController5 | 2 | |
| DataController6 | DataController6 | 2 | |
| DataController7 | DataController7 | 2 | |
| DataController8 | DataController8 | 2 | |
| DataController9 | DataController9 | 2 | |
| DataControllerSet | DataControllerSet | 2 | |
| DestinationLocationCountry | DestinationLocationCountry | 2 | |
| EmailAddress | EmailAddress | 2 | |
| FirstName | FirstName | 2 | |
| FormOfAddress | FormOfAddress | 1 | |
| Initials | Initials | 1 | |
| IsBusinessPurposeCompleted | IsBusinessPurposeCompleted | 2 | |
| LastChangeDateTime | LastChangeDateTime | 2 | |
| LastName | LastName | 2 | |
| LastNamePrefix | LastNamePrefix | 1 | |
| LastNameSecondPrefix | LastNameSecondPrefix | 1 | |
| MblPhoneDestinationLocCountry | MblPhoneDestinationLocCountry | 2 | |
| MiddleName | MiddleName | 1 | |
| MobilePhoneNumber | MobilePhoneNumber | 2 | |
| Person | Person | 2 | |
| PersonExternalID | PersonExternalID | 2 | |
| PersonFullName | PersonFullName | 1 | |
| PhoneNumber | PhoneNumber | 2 | |
| PhoneNumberExtension | PhoneNumberExtension | 2 | |
| UserID | UserID | 1 | |
| WorkforcePersonEntrySource | WorkforcePersonEntrySource | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Person data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #XL,
dataClass: #MASTER
}
//@AccessControl.privilegedAssociations: [ '_BPDataControllerUsage' ]
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@Consumption.dbHints: [ '&PREFER_JOIN_WITH_FDA 0&', 'USE_HEX_PLAN' ]
define view entity R_WorkforcePerson
as select from I_BusinessPartner as _BP
//In-order to filter role category 'B'
inner join R_BPUsrRoleCount as _BPUsrRoleCount on _BP.BusinessPartnerUUID = _BPUsrRoleCount.BusinessPartnerUUID
and _BPUsrRoleCount.TotalNumberOfBPRole >= 1
left outer to one join bpu000 as _EntrySource on _EntrySource.partner = _BP.BusinessPartner
association [0..1] to I_FormOfAddressText as _FormOfAddressText on _FormOfAddressText.FormOfAddress = _BP.FormOfAddress
and _FormOfAddressText.Language = $session.system_language
association [0..1] to I_LanguageText as _CorrespondenceLanguage on _CorrespondenceLanguage.LanguageCode = _BP.CorrespondenceLanguage
and _CorrespondenceLanguage.Language = $session.system_language
association [0..1] to I_AcademicTitleText as _AcademicTitle1 on _AcademicTitle1.AcademicTitle = _BP.AcademicTitle
and _AcademicTitle1.Language = $session.system_language
association [0..1] to I_AcademicTitleText as _AcademicTitle2 on _AcademicTitle2.AcademicTitle = _BP.AcademicTitle2
and _AcademicTitle2.Language = $session.system_language
association [0..1] to I_CountryText as _DestinationLocationCountry on $projection.DestinationLocationCountry = _DestinationLocationCountry.Country
and _DestinationLocationCountry.Language = $session.system_language
association [0..1] to I_CountryText as _MblPhoneDestinationLocCountry on $projection.MblPhoneDestinationLocCountry = _MblPhoneDestinationLocCountry.Country
and _MblPhoneDestinationLocCountry.Language = $session.system_language
// association [0..1] to R_PreferredPhoneTypeText as _PreferredPhoneTypeText on $projection.PreferredPhoneType = _PreferredPhoneTypeText.PreferredPhoneType
// and _PreferredPhoneTypeText.Language = $session.system_language
// and $projection.PreferredPhoneType <> ''
association [0..1] to R_WorkforcePersonEntrySourceVH as _EntrySourceText on $projection.WorkforcePersonEntrySource = _EntrySourceText.WorkforcePersonEntrySource
association [1..1] to R_BPUsrPersonExternalID as _PersIdentifier on $projection.Person = _PersIdentifier.BusinessPartner
association [0..1] to I_WorkplaceAddress as _WorkplaceAddress on $projection.PersonUUID = _WorkplaceAddress.BusinessPartnerUUID
// association [0..1] to R_WrkfrcPersonWorkplaceAddress as _WorkplaceAddress on $projection.PersonUUID = _WorkplaceAddress.BusinessPartnerUUID
association [0..1] to I_BusinessUserBasic as _BusinessUserBasic on $projection.Person = _BusinessUserBasic.BusinessPartner
association [1..1] to C_BPUsrChangeDocument as _ChangeDoc on $projection.PersonUUID = _ChangeDoc.BusinessPartnerUUID
association [0..*] to R_WorkAssignmentTP as _WorkAssignment on $projection.PersonUUID = _WorkAssignment.PersonUUID
{
key _BP.BusinessPartnerUUID as PersonUUID,
_BP.BusinessPartner as Person,
_PersIdentifier.BPIdentificationNumber as PersonExternalID,
_BP.FirstName,
_BP.LastName,
_BP.MiddleName,
_BP.AdditionalLastName,
_BP.PersonFullName,
_BP.AuthorizationGroup,
_BP.FormOfAddress,
_BP.CorrespondenceLanguage,
_BP.LastNamePrefix,
_BP.LastNameSecondPrefix,
_BP.BusinessPartnerBirthName,
_BP.BusinessPartnerNicknameLabel,
_BP.AcademicTitle,
_BP.AcademicTitle2,
_BP.Initials,
_BP.BusinessPartnerSupplementName as BusinessPartnerSupplementName,
cast ( '' as bu_partnerrole) as BusinessPartnerRole,
@Semantics.booleanIndicator
_BP.IsBusinessPurposeCompleted,
@Semantics.systemDateTime.lastChangedAt: true
cast (dats_tims_to_tstmp( _BP.LastChangeDate,
_BP.LastChangeTime,
abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_lastchangedon) as LastChangeDateTime,
// _PersIdentifier,
_WorkplaceAddress.DefaultEmailAddress as EmailAddress,
_WorkplaceAddress.MobilePhoneNumber as MobilePhoneNumber,
_WorkplaceAddress.MblPhoneDestinationLocCountry as MblPhoneDestinationLocCountry,
_WorkplaceAddress.PhoneNumber as PhoneNumber,
_WorkplaceAddress.PhoneNumberExtension as PhoneNumberExtension,
_WorkplaceAddress.DestinationLocationCountry as DestinationLocationCountry,
// _WorkplaceAddress.PhoneNumberType as PreferredPhoneType,
_BusinessUserBasic.UserID as UserID,
cast( cast( _ChangeDoc.BPAddressChangeDocObject as char24 preserving type ) as char90 ) as BPAddressChangeDocObject,
case _EntrySource.entry_source
when 'E'
then 'W'
else
_EntrySource.entry_source
end as WorkforcePersonEntrySource,
_BP.DataControllerSet,
_BP.DataController1,
_BP.DataController2,
_BP.DataController3,
_BP.DataController4,
_BP.DataController5,
_BP.DataController6,
_BP.DataController7,
_BP.DataController8,
_BP.DataController9,
_BP.DataController10,
//Associations//
_WorkAssignment,
_WorkplaceAddress,
_FormOfAddressText,
_CorrespondenceLanguage,
_AcademicTitle1,
_AcademicTitle2,
_DestinationLocationCountry,
_MblPhoneDestinationLocCountry,
_EntrySourceText
// _PreferredPhoneTypeText
}
where
_BP.BusinessPartnerCategory = '1'