I_WorkForcePersonMappings

DDL: I_WORKFORCEPERSONMAPPINGS Type: view_entity COMPOSITE

Workforce Person Mappings

I_WorkForcePersonMappings 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 16 fields with key field WorkforceAssignment. It has 3 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkAssignmentKeyMapping WorkforceKeyMapping from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _WorkForcePersonBPDetails $projection.BusinessPartner = _WorkForcePersonBPDetails.BusinessPartner
[1..1] I_WorkForcePersonBPToSupplier _WorkForcePersonBPToSupplier $projection.BusinessPartner = _WorkForcePersonBPToSupplier.BusinessPartner
[1..1] I_WorkForcePersonBPToSupplier _WorkassignmentBPToSupplier $projection.EmploymentBusinessPartner = _WorkassignmentBPToSupplier.BusinessPartner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workforce Person Mappings view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignment I_WorkAssignmentKeyMapping WorkAssignment
WorkforceAssgmtStartDate I_WorkAssignmentKeyMapping WorkAssignmentStartDate
BusinessPartner I_WorkAssignmentKeyMapping BusinessPartner
CentralPerson I_WorkAssignmentKeyMapping CentralPerson
WorkforcePersonID I_WorkAssignmentKeyMapping WorkforcePersonID
WorkforcePersonExternalID I_WorkAssignmentKeyMapping WorkforcePersonExternalID
WorkforceAssignmentExternalID I_WorkAssignmentKeyMapping WorkAssignmentExternalID
Country2DigitISOCode I_WorkAssignmentKeyMapping Country2DigitISOCode
FirstName BusinessUserBasic FirstName
LastName BusinessUserBasic LastName
PersonFullName BusinessUserBasic PersonFullName
UserID BusinessUserBasic UserID
EmploymentBusinessPartner BupaIdentification BusinessPartner
SupplierendasSupplier
_WorkForcePersonBPDetails _WorkForcePersonBPDetails
_BusinessPartner BupaIdentification _BusinessPartner 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Person Mappings'
@VDM.viewType: #COMPOSITE
@ObjectModel:{
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #L
}
define view entity I_WorkForcePersonMappings
  as select from           I_WorkAssignmentKeyMapping as WorkforceKeyMapping
    left outer to one join I_BusinessUserBasic        as BusinessUserBasic  on WorkforceKeyMapping.BusinessPartner = BusinessUserBasic.BusinessPartner

    left outer to one join I_BuPaIdentification       as BupaIdentification on  WorkforceKeyMapping.WorkAssignment      = BupaIdentification.BPIdentificationNumber
                                                                            and BupaIdentification.BPIdentificationType = 'HCM033'

  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.EmploymentBusinessPartner = _WorkassignmentBPToSupplier.BusinessPartner
{
      // Keymap

  key WorkforceKeyMapping.WorkAssignment           as WorkforceAssignment,
      WorkforceKeyMapping.WorkAssignmentStartDate  as WorkforceAssgmtStartDate,
      WorkforceKeyMapping.BusinessPartner,
      WorkforceKeyMapping.CentralPerson,
      WorkforceKeyMapping.WorkforcePersonID,
      WorkforceKeyMapping.WorkforcePersonExternalID,
      WorkforceKeyMapping.WorkAssignmentExternalID as WorkforceAssignmentExternalID,
      WorkforceKeyMapping.Country2DigitISOCode,

      //  BP

      BusinessUserBasic.FirstName,
      BusinessUserBasic.LastName,
      BusinessUserBasic.PersonFullName,

      //  User

      BusinessUserBasic.UserID,

      //  Employments

      BupaIdentification.BusinessPartner           as EmploymentBusinessPartner,

      // Supplier

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

      // Associations //

      _WorkForcePersonBPDetails,
      BupaIdentification._BusinessPartner

}
where
  WorkforceKeyMapping.IsBlocked = ' ';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUPAIDENTIFICATION",
"I_BUSINESSUSERBASIC",
"I_WORKASSIGNMENTKEYMAPPING",
"I_WORKFORCEPERSONBPTOSUPPLIER"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[
"I_BUPAIDENTIFICATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More