I_WorkforcePersonSkillTags

DDL: I_WORKFORCEPERSONSKILLTAGS SQL: IWFPERSSKILLTAGS Type: view COMPOSITE
10 Fields 2 Data Sources 2 Associations

Workforce Person Skill Tags

I_WorkforcePersonSkillTags (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Workforce Person · Human Resources

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 10 fields with key fields Person, WorkforcePersonSkillTagID. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Human Resources
Purpose
This CDS view helps to retrieve the skill tag data related to a workforce person. This CDS view provides the data to answer the following business questions: How can I retrieve the skill tags data related to the workforce person based on the Person and workforce person skill tag ID?

Prerequisites
Authorizations To use this CDS view, the following business catalogs need to be assigned to a user: BEGRU_BUPA_GRP (Authorization Group for Business Partners) B_BUP_DCPD (Business Partner Processing)

Structure
Important Fields Important fields in this view include the following: Field Name Description WorkforcePersonSkillTagID GUID in 'RAW' format WorkforcePersonSkillTagType Tag Type WorkforcePersonSkillTagName Employee Tag SystemOfRecordID System ID LastChangeDate Time Stamp in Long Form LastChangedByUser User Name AuthorizationGroup Authorization Group

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

Related Information
The following fields are created in the CDS view in accordance with BP data controller adoption: DataControllerSet, DataController1, DataController2, DataController3, DataController4, DataController5, DataController6, DataController7, DataController8, DataController9, DataController10. Note These fields may be visible in the interface of the CDS view. However, they are meant only for internal-SAP consumption and must not be consumed externally for any purposes. For more information about BP data controller authorization, refer to Assign Data Controller .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessHuman Resources
Application ComponentCA-WFD
CapabilitiesData Source for Data Extraction
PackageHuman Resources for SAP S/4HANA Cloud Private Edition

Documentation

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 (12)

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
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 (10)

KeyFieldSource TableSource FieldDescription
KEY Person I_HrRelation HumRsceRelatedObjectId ID of Related Object
KEY WorkforcePersonSkillTagID I_EmployeeskillTags EmployeeSkillTagID GUID in 'RAW' format
WorkforcePersonSkillTagType I_EmployeeskillTags EmployeeSkillTagType Tag Type
WorkforcePersonSkillTagName I_EmployeeskillTags EmployeeSkillTagName Tag
SystemOfRecordID I_EmployeeskillTags SystemOfRecordID System ID
LastChangeDate I_EmployeeskillTags LastChangeDate UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
LastChangedByUser I_EmployeeskillTags LastChangedByUser User Name
AuthorizationGroup _BusinessPartner AuthorizationGroup Authorization Group
_CreatedByUser _CreatedByUser
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkforcePersonSkillTags.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWFPERSSKILLTAGS

CREATE VIEW I_WorkforcePersonSkillTags AS
SELECT
  RelationCP_BP.HumRsceRelatedObjectId AS Person,
  Tags.EmployeeSkillTagID AS WorkforcePersonSkillTagID,
  Tags.EmployeeSkillTagType AS WorkforcePersonSkillTagType,
  Tags.EmployeeSkillTagName AS WorkforcePersonSkillTagName,
  Tags.SystemOfRecordID AS SystemOfRecordID,
  Tags.LastChangeDate AS LastChangeDate,
  Tags.LastChangedByUser AS LastChangedByUser,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup
FROM I_EmployeeskillTags AS Tags
INNER JOIN I_HrRelation AS RelationCP_BP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _CreatedByUser ON LastChangedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON Person = _BusinessPartner.BusinessPartner  -- association [1]
;

Learn More