I_EMPLOYEESKILLTAGS

CDS View

Employee Skill Tags

I_EMPLOYEESKILLTAGS is a CDS View in S/4HANA. Employee Skill Tags. It contains 8 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 8 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PersnWrkAgrmtTagForOPg view from CONSUMPTION Person Work Agreement Tag Details for Object Page
I_EmployeeOp view left_outer BASIC Employee CDS view for OP
I_WorkerSearch view left_outer COMPOSITE Workforce CDS view for OP
I_WorkforcePersonSkillTags view from COMPOSITE Workforce Person Skill Tags
P_Empfactsheet_Tags view from CONSUMPTION Employee Factsheet CDS - Tags
R_WorkforceTagTP view_entity from TRANSACTIONAL Workforce Tag data TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY EmployeeSkillTagID EmployeeSkillTagID,WorkforcePersonSkillTagID,WorkforcePersonTagUUID 4
KEY PersonnelNumber PersonnelNumber 3
_CreatedByUser _CreatedByUser 1
EmployeeSkillTagName EmployeeSkillTagName,WorkforcePersonSkillTagName,WorkforcePersonTagText 5
EmployeeSkillTagType EmployeeSkillTagType,WorkforcePersonSkillTagType,WorkforcePersonTagTypeValue 4
LastChangeDate LastChangeDate,LastChangeDateTime 3
LastChangedByUser LastChangedByUser 4
SystemOfRecordID SystemOfRecordID 4 
@AbapCatalog.sqlViewName: 'IEMPLSKILLTGS'
@EndUserText.label: 'Employee Skill Tags'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #XXL

define view I_EmployeeskillTags as 
  select from /shcm/d_ee_tag as Tags 
  association [0..1] to I_User as _CreatedByUser on $projection.LastChangedByUser = _CreatedByUser.UserID
  {
  
  key Tags.personnelnumber as PersonnelNumber,
  key Tags.tag_id          as EmployeeSkillTagID,
    Tags.tag_type          as EmployeeSkillTagType,
    Tags.tag               as EmployeeSkillTagName,
    Tags.system_of_record  as SystemOfRecordID,
    Tags.changed_on        as LastChangeDate,
    Tags.changed_by        as LastChangedByUser,
    _CreatedByUser //Added to display User Full Name from CE1708

  
  }         
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SHCM/D_EE_TAG"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More