R_WorkforcePersonTag_1

@EndUserText.label: 'WorkforcePerson Tags Basic View'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_WorkforcePersonTag_1
  as select from /shcm/d_ee_tag     as Tags
    inner join   R_WorkAssignment_1 as workAssignment on Tags.personnelnumber = workAssignment.WorkAssignment

////  association [0..1] to I_User                    as _CreatedByUser on  $projection.WrkfrcPersnTagLastChgdByUserID = _CreatedByUser.UserID

  //  association [1..1] to R_Workassignment_1 as _WorkAssignment on $projection.WorkAssignment = _WorkAssignment.WorkAssignment


  // Extension


//  association [1]    to E_WorkforcePersonTag_1 as _Extension     on  $projection.WorkAssignment            = _Extension.WorkAssignment

//                                                                    and $projection.WorkforcePersonSkillTagID  = _Extension.WorkforcePersonSkillTagID 


{
  key Tags.personnelnumber as WorkAssignment,
  key Tags.tag_id          as WorkforcePersonSkillTagID ,
      Tags.tag_type        as WorkforcePersonSkillTagType,
      Tags.tag             as WorkforcePersonTagText,
//      Tags.changed_on      as WrkfrcPersnTagLastChgdDteTime,

//      Tags.changed_by      as WrkfrcPersnTagLastChgdByUserID,


      workAssignment.WorkAssignmentExternalID,
      workAssignment.Country2DigitISOCode,
      workAssignment.WorkforcePersonExternalID


      /*Association*/
////      _CreatedByUser //Added to display User Full Name from CE1708

      //      _WorkAssignment


}