I_WorkforcePersonSkillTags

@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
@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] 
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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_EMPLOYEESKILLTAGS",
"I_HRRELATION"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/