I_EMPLOYEESKILLTAGS

CDS View
8 Fields 6 CDS Views

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.

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Employee Skill Tags
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EMPLOYEESKILLTAGS (
    EMPLOYEESKILLTAGID,
    PERSONNELNUMBER,
    _CREATEDBYUSER,
    EMPLOYEESKILLTAGNAME,
    EMPLOYEESKILLTAGTYPE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    SYSTEMOFRECORDID,
    PRIMARY KEY (EMPLOYEESKILLTAGID, PERSONNELNUMBER)
);

Learn More