I_WORKFORCEPERSON_1

CDS View

Workforce Person

I_WORKFORCEPERSON_1 is a CDS View in S/4HANA. Workforce Person. It contains 17 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 17 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_EntProjProfnlSrvcTeamMbrVH view_entity from CONSUMPTION Professional Service Project Members

Fields (17)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
AuthorizationGroup AuthorizationGroup 1
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
FirstName FirstName 1
FullName PersonFullName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastName LastName 1 
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Workforce Person'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL

}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity I_WorkforcePerson_1
  as select distinct from I_WorkforcePersonKeyMap as Worker
    inner join            I_BusinessPartner       as BusinessPartner on BusinessPartner.BusinessPartner = Worker.BusinessPartner

  association [1..*] to I_WorkAssignment_1 as _WorkAssignment on $projection.WorkforcePersonExternalID = _WorkAssignment.WorkforcePersonExternalID
  association [0..1] to E_BP_D             as _BPExtension    on $projection.BusinessPartner = _BPExtension.BusinessPartner
{

  key Worker.WorkforcePersonExternalID,
      Worker.BusinessPartner,
      BusinessPartner.FirstName,
      BusinessPartner.MiddleName,
      BusinessPartner.LastName,
      BusinessPartner.PersonFullName           as FullName,
      BusinessPartner.BusinessPartnerBirthName as BirthName,
      BusinessPartner.Initials,
      BusinessPartner.CorrespondenceLanguage   as NativePreferredLanguage,
      @Semantics.booleanIndicator: true
      BusinessPartner.IsBusinessPurposeCompleted,
      BusinessPartner.DataControllerSet,
      BusinessPartner.DataController1,
      BusinessPartner.DataController2,
      BusinessPartner.DataController3,
      BusinessPartner.DataController4,
      BusinessPartner.DataController5,
      BusinessPartner.DataController6,
      BusinessPartner.DataController7,
      BusinessPartner.DataController8,
      BusinessPartner.DataController9,
      BusinessPartner.DataController10,
      BusinessPartner.AuthorizationGroup,


      /*Associations */
      _WorkAssignment

}

Learn More