I_WorkforcePersonMapping

DDL: I_WORKFORCEPERSONMAPPING Type: view_entity COMPOSITE Package: WFD_BL_PERSISTENCE

Workforce Person Mappings

I_WorkforcePersonMapping is a Composite CDS View that provides data about "Workforce Person Mappings" in SAP S/4HANA. It reads from 1 data source (I_WorkAssignmentKeyMapping) and exposes 15 fields with key fields WorkAssignmentExternalID, Country2DigitISOCode. It has 4 associations to related views. Part of development package WFD_BL_PERSISTENCE.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkAssignmentKeyMapping WorkforceKeyMapping from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_BusinessUserBasic _BusinessUserBasic WorkforceKeyMapping.BusinessPartner = _BusinessUserBasic.BusinessPartner
[1..1] I_BusinessPartner _WorkForcePersonBPDetails $projection.BusinessPartner = _WorkForcePersonBPDetails.BusinessPartner
[1..1] I_WorkForcePersonBPToSupplier _WorkForcePersonBPToSupplier $projection.BusinessPartner = _WorkForcePersonBPToSupplier.BusinessPartner
[1..1] I_WorkForcePersonBPToSupplier _WorkassignmentBPToSupplier $projection.WorkAssignmentBusinessPartner = _WorkassignmentBPToSupplier.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Workforce Person Mappings view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
KEY Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
WorkAssignmentStartDate I_WorkAssignmentKeyMapping WorkAssignmentStartDate
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
BusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
WorkforcePersonID I_WorkAssignmentKeyMapping WorkforcePersonID
FirstName _WorkForcePersonBPDetails FirstName
LastName _WorkForcePersonBPDetails LastName
PersonFullName _WorkForcePersonBPDetails PersonFullName
UserID _BusinessUserBasic UserID
WorkAssignmentBusinessPartner BupaIdentification BusinessPartner
SupplierendasSupplier
IsBlocked I_WorkAssignmentKeyMapping IsBlocked
_WorkForcePersonBPDetails _WorkForcePersonBPDetails
Person _WorkForcePersonBPDetails BusinessPartner 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Workforce Person Mappings'
@VDM.viewType: #COMPOSITE
@ObjectModel:{
  usageType.dataClass: #MASTER,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L
}
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity I_WorkforcePersonMapping
  as select from           I_WorkAssignmentKeyMapping as WorkforceKeyMapping
    left outer to one join I_BuPaIdentification       as BupaIdentification on  WorkforceKeyMapping.WorkAssignment      = BupaIdentification.BPIdentificationNumber
                                                                            and BupaIdentification.BPIdentificationType = 'HCM033'
  association [1..1] to I_BusinessUserBasic           as _BusinessUserBasic           on WorkforceKeyMapping.BusinessPartner = _BusinessUserBasic.BusinessPartner
  association [1..1] to I_BusinessPartner             as _WorkForcePersonBPDetails    on $projection.BusinessPartner = _WorkForcePersonBPDetails.BusinessPartner
  association [1..1] to I_WorkForcePersonBPToSupplier as _WorkForcePersonBPToSupplier on $projection.BusinessPartner = _WorkForcePersonBPToSupplier.BusinessPartner
  association [1..1] to I_WorkForcePersonBPToSupplier as _WorkassignmentBPToSupplier  on $projection.WorkAssignmentBusinessPartner = _WorkassignmentBPToSupplier.BusinessPartner
{
  key WorkforceKeyMapping.WorkAssignmentExternalID,
  key WorkforceKeyMapping.Country2DigitISOCode,
      WorkforceKeyMapping.WorkAssignmentStartDate,
      WorkforceKeyMapping.WorkforcePersonExternalID,
      WorkforceKeyMapping.BusinessPartner,
      WorkforceKeyMapping.WorkforcePersonID,

      //  BP

      _WorkForcePersonBPDetails.FirstName,
      _WorkForcePersonBPDetails.LastName,
      _WorkForcePersonBPDetails.PersonFullName,

      //  User

      _BusinessUserBasic.UserID,

      //  Employments

      BupaIdentification.BusinessPartner as WorkAssignmentBusinessPartner,

      // Supplier

      case WorkforceKeyMapping.WorkforceBPModelType
      when 'O' then _WorkForcePersonBPToSupplier.Supplier
      else _WorkassignmentBPToSupplier.Supplier
      end                                as Supplier,

      WorkforceKeyMapping.IsBlocked,
      

      
      // Associations //

      _WorkForcePersonBPDetails,
      
      @Consumption.hidden:true
      @UI.hidden:true
      _WorkForcePersonBPDetails.BusinessPartner as Person
}

Learn More