I_WorkforcePersonSkillTag

DDL: I_WORKFORCEPERSONSKILLTAG Type: view_entity COMPOSITE Package: VDM_WFD_WORK_FORCE

Workforce Person Skill Tag

I_WorkforcePersonSkillTag is a Composite CDS View that provides data about "Workforce Person Skill Tag" in SAP S/4HANA. It reads from 2 data sources (I_WorkerCentralPerson, I_EmployeeskillTags) and exposes 6 fields with key fields WorkforcePersonExternalID, WorkforcePersonSkillTagID. It has 2 associations to related views. Part of development package VDM_WFD_WORK_FORCE.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_WorkerCentralPerson _Person from
I_EmployeeskillTags _SkillTag inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = _Person.BusinessPartner
[1..1] I_WorkforcePerson_1 _WorkforcePerson _WorkforcePerson.WorkforcePersonExternalID = _Person.WorkforcePersonExternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Workforce Person Skill Tag view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #NONE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkforcePersonExternalID I_WorkerCentralPerson WorkforcePersonExternalID
KEY WorkforcePersonSkillTagID I_EmployeeskillTags EmployeeSkillTagID
BusinessPartner I_WorkerCentralPerson BusinessPartner
WorkforcePersonTagText I_EmployeeskillTags EmployeeSkillTagName
_WorkforcePerson _WorkforcePerson
_BusinessPartner _BusinessPartner 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Workforce Person Skill Tag'
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType.dataClass: #MIXED,
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #XL
}
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern:#NONE
define view entity I_WorkforcePersonSkillTag
  as select from I_WorkerCentralPerson as _Person

    inner join   I_EmployeeskillTags   as _SkillTag on _SkillTag.PersonnelNumber = _Person.CentralPerson
    association [0..1] to I_BusinessPartner       as _BusinessPartner on _BusinessPartner.BusinessPartner = _Person.BusinessPartner
    association [1..1] to I_WorkforcePerson_1    as _WorkforcePerson on _WorkforcePerson.WorkforcePersonExternalID = _Person.WorkforcePersonExternalID
    
{
  key _Person.WorkforcePersonExternalID,
  key _SkillTag.EmployeeSkillTagID   as WorkforcePersonSkillTagID,
      _Person.BusinessPartner,
      _SkillTag.EmployeeSkillTagName as WorkforcePersonTagText,
      
      /*Associations */
      _WorkforcePerson,
      _BusinessPartner

}
where _SkillTag.EmployeeSkillTagType = 'U'

Learn More