R_WorkforcePersonSummary

DDL: R_WORKFORCEPERSONSUMMARY Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL

Workforce Person Summary

R_WorkforcePersonSummary is a Composite CDS View that provides data about "Workforce Person Summary" in SAP S/4HANA. It reads from 1 data source (R_WorkforcePerson) and exposes 29 fields with key field PersonUUID. It has 1 association to related views. Part of development package WFD_WORKER_FACTSHEET_BL.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
R_WorkforcePerson R_WorkforcePerson from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_WorkAssignment _WorkAssignment $projection.PersonUUID = _WorkAssignment.PersonUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Workforce Person Summary view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PersonUUID R_WorkforcePerson PersonUUID
PersonExternalID R_WorkforcePerson PersonExternalID
Person R_WorkforcePerson Person
FirstName R_WorkforcePerson FirstName
LastName R_WorkforcePerson LastName
EmailAddress R_WorkforcePerson EmailAddress
MobilePhoneNumber R_WorkforcePerson MobilePhoneNumber
MblPhoneDestinationLocCountry R_WorkforcePerson MblPhoneDestinationLocCountry
PhoneNumber R_WorkforcePerson PhoneNumber
PhoneNumberExtension R_WorkforcePerson PhoneNumberExtension
DestinationLocationCountry R_WorkforcePerson DestinationLocationCountry
MblNormalizedPhoneNumber
NormalizedPhoneNumber
AuthorizationGroup R_WorkforcePerson AuthorizationGroup
IsBusinessPurposeCompleted R_WorkforcePerson IsBusinessPurposeCompleted
WorkerIsInactive WorkerStatus WorkerIsInactive
DataControllerSet R_WorkforcePerson DataControllerSet
DataController1 R_WorkforcePerson DataController1
DataController2 R_WorkforcePerson DataController2
DataController3 R_WorkforcePerson DataController3
DataController4 R_WorkforcePerson DataController4
DataController5 R_WorkforcePerson DataController5
DataController6 R_WorkforcePerson DataController6
DataController7 R_WorkforcePerson DataController7
DataController8 R_WorkforcePerson DataController8
DataController9 R_WorkforcePerson DataController9
DataController10 R_WorkforcePerson DataController10
_WorkforcePerson _WorkforcePerson
_WorkAssignment _WorkAssignment 
//@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Workforce Person Summary'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]

define view entity R_WorkforcePersonSummary
  as select from           R_WorkforcePerson
    left outer to one join I_WorkerStatus as WorkerStatus on R_WorkforcePerson.PersonUUID = WorkerStatus.BusinessPartnerUUID
  association [0..*] to R_WorkAssignment                  as _WorkAssignment  on $projection.PersonUUID = _WorkAssignment.PersonUUID
  association        to parent R_WorkforcePersonFactSheet as _WorkforcePerson on $projection.PersonUUID = _WorkforcePerson.PersonUUID
{
  key R_WorkforcePerson.PersonUUID,
      R_WorkforcePerson.PersonExternalID,
      R_WorkforcePerson.Person,
      R_WorkforcePerson.FirstName,
      R_WorkforcePerson.LastName,
      R_WorkforcePerson.EmailAddress,
      R_WorkforcePerson.MobilePhoneNumber,
      R_WorkforcePerson.MblPhoneDestinationLocCountry,
      R_WorkforcePerson.PhoneNumber,
      R_WorkforcePerson.PhoneNumberExtension,
      R_WorkforcePerson.DestinationLocationCountry,
      R_WorkforcePerson._WorkplaceAddress.MblNormalizedPhoneNumber,
      R_WorkforcePerson._WorkplaceAddress.NormalizedPhoneNumber,
      R_WorkforcePerson.AuthorizationGroup,
      @Semantics.booleanIndicator
      R_WorkforcePerson.IsBusinessPurposeCompleted,
      @Semantics.booleanIndicator
      WorkerStatus.WorkerIsInactive       as WorkerIsInactive,
      R_WorkforcePerson.DataControllerSet as DataControllerSet,
      R_WorkforcePerson.DataController1   as DataController1,
      R_WorkforcePerson.DataController2   as DataController2,
      R_WorkforcePerson.DataController3   as DataController3,
      R_WorkforcePerson.DataController4   as DataController4,
      R_WorkforcePerson.DataController5   as DataController5,
      R_WorkforcePerson.DataController6   as DataController6,
      R_WorkforcePerson.DataController7   as DataController7,
      R_WorkforcePerson.DataController8   as DataController8,
      R_WorkforcePerson.DataController9   as DataController9,
      R_WorkforcePerson.DataController10  as DataController10,
      _WorkforcePerson,
      _WorkAssignment
}

Learn More