I_WorkforcePersonSkillTagDEX

DDL: I_WORKFORCEPERSONSKILLTAGDEX Type: view_entity COMPOSITE Package: VDM_WFD_WORK_FORCE

Workforce Person Skill Tag

I_WorkforcePersonSkillTagDEX 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 7 fields with key fields CentralPerson, WorkforcePersonSkillTagID. It has 2 associations to related views. Part of development package VDM_WFD_WORK_FORCE.

2 data source(s) 7 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] I_WorkforcePersonDEX_1 _WorkforcePerson _WorkforcePerson.WorkforcePersonExternalID = Person.WorkforcePersonExternalID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Workforce Person Skill Tag view
VDM.viewType #COMPOSITE view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name WorkforcePersonSkillTags view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CentralPerson I_WorkerCentralPerson CentralPerson
KEY WorkforcePersonSkillTagID I_EmployeeskillTags EmployeeSkillTagID
WorkforcePersonExternalID I_WorkerCentralPerson WorkforcePersonExternalID
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
@Analytics.dataExtraction: {
            enabled: true,
            delta.changeDataCapture:
    {
            mapping:[
               {
                    table: '/shcm/d_ee_tag', 
                    role: #MAIN,
                    viewElement: ['CentralPerson','WorkforcePersonSkillTagID'],
                    tableElement: ['personnelnumber','tag_id']
                },
                  {
                  table : 'wfd_d_keymap',
                  role: #LEFT_OUTER_TO_ONE_JOIN,
                  viewElement: [ 'CentralPerson' ],
                  tableElement: [ 'workforce_assgmt_id' ]
                  }
            ]
        }
    }

@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities:[ #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.sapObjectNodeType.name:'WorkforcePersonSkillTags'


define view entity I_WorkforcePersonSkillTagDEX
  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] to I_WorkforcePersonDEX_1 as _WorkforcePerson on _WorkforcePerson.WorkforcePersonExternalID = Person.WorkforcePersonExternalID

{
  key Person.CentralPerson,
  key SkillTag.EmployeeSkillTagID   as WorkforcePersonSkillTagID,
      Person.WorkforcePersonExternalID,
      Person.BusinessPartner,
      SkillTag.EmployeeSkillTagName as WorkforcePersonTagText,
      

      /*Associations */
      _WorkforcePerson,
      _BusinessPartner

}
where
  SkillTag.EmployeeSkillTagType = 'U'

Learn More