I_WorkforcePersonSkillTags

DDL: I_WORKFORCEPERSONSKILLTAGS SQL: IWFPERSSKILLTAGS Type: view COMPOSITE Package: VDM_SHCM_EMPLOYEE_V2

Workforce Person Skill Tags

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

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_HrRelation RelationCP_BP inner
I_EmployeeskillTags Tags from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.LastChangedByUser = _CreatedByUser.UserID
[1] I_BusinessPartner _BusinessPartner $projection.Person = _BusinessPartner.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IWFPERSSKILLTAGS view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name WorkforcePerson view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Workforce Person Skill Tags view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Person I_HrRelation HumRsceRelatedObjectId
KEY WorkforcePersonSkillTagID I_EmployeeskillTags EmployeeSkillTagID
WorkforcePersonSkillTagType I_EmployeeskillTags EmployeeSkillTagType
WorkforcePersonSkillTagName I_EmployeeskillTags EmployeeSkillTagName
SystemOfRecordID I_EmployeeskillTags SystemOfRecordID
LastChangeDate I_EmployeeskillTags LastChangeDate
LastChangedByUser I_EmployeeskillTags LastChangedByUser
AuthorizationGroup _BusinessPartner AuthorizationGroup
_CreatedByUser _CreatedByUser
_BusinessPartner _BusinessPartner
BusinessPartner _BusinessPartner BusinessPartner 
@AbapCatalog.sqlViewName: 'IWFPERSSKILLTAGS'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.sapObjectNodeType.name:'WorkforcePerson'
@AbapCatalog.compiler.compareFilter: true
//@AccessControl.personalData.blocking: #REQUIRED

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Workforce Person Skill Tags'
@Metadata.ignorePropagatedAnnotations:true
@Analytics.dataExtraction.enabled: true
@ObjectModel.supportedCapabilities: [#EXTRACTION_DATA_SOURCE] 
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view I_WorkforcePersonSkillTags
  as select from I_EmployeeskillTags as Tags
  
    inner join   I_HrRelation        as RelationCP_BP on  RelationCP_BP.HumRsceObjectId            = Tags.PersonnelNumber
                                                      and RelationCP_BP.HumRsceRelshpSpecification = 'B'
                                                      and RelationCP_BP.HumRsceRelationship        = '207'
                                                      and RelationCP_BP.EndDate                    = '99991231'
  association [0..1] to I_User            as _CreatedByUser   on $projection.LastChangedByUser = _CreatedByUser.UserID

  association [1]    to I_BusinessPartner as _BusinessPartner on $projection.Person = _BusinessPartner.BusinessPartner
{

  key RelationCP_BP.HumRsceRelatedObjectId as Person,
  key Tags.EmployeeSkillTagID              as WorkforcePersonSkillTagID,
      Tags.EmployeeSkillTagType            as WorkforcePersonSkillTagType,
      Tags.EmployeeSkillTagName            as WorkforcePersonSkillTagName,
      Tags.SystemOfRecordID,
      Tags.LastChangeDate,
      Tags.LastChangedByUser,
      _BusinessPartner.AuthorizationGroup,
      _CreatedByUser, //Added to display User Full Name from CE1708,

      _BusinessPartner,
      @Consumption.hidden:true
      @UI.hidden:true
      _BusinessPartner.BusinessPartner as BusinessPartner

}

Learn More