P_Empfactsheet_Tags

DDL: P_EMPFACTSHEET_TAGS SQL: PEMPFSTAG Type: view CONSUMPTION Package: VDM_SHCM_EMPLOYEE
8 Fields 1 Data Sources

Employee Factsheet CDS - Tags

P_Empfactsheet_Tags is a Consumption CDS View that provides data about "Employee Factsheet CDS - Tags" in SAP S/4HANA. It reads from 1 data source (I_EmployeeskillTags) and exposes 8 fields with key fields PersonnelNumber, EmployeeSkillTagID. Part of development package VDM_SHCM_EMPLOYEE.

Data Sources (1)

SourceAliasJoin Type
I_EmployeeskillTags Tags from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName PEMPFSTAG view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employee Factsheet CDS - Tags view
Search.searchable false view
UI.headerInfo.typeName Tag view
UI.headerInfo.typeName_AsOTR 40F2E93067D51EE594A7622CCB4AF3A9 view
UI.headerInfo.typeNamePlural Tags view
UI.headerInfo.typeNamePlural_AsOTR 40F2E93067D51EE594A7622CCB4AF3A9 view
UI.badge.headLine.type #STANDARD view
UI.badge.headLine.value EmployeeSkillTagName view
UI.badge.title.type #STANDARD view
UI.badge.title.value EmployeeSkillTagName view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber I_EmployeeskillTags PersonnelNumber Personnel No.
KEY EmployeeSkillTagID I_EmployeeskillTags EmployeeSkillTagID Template GUID
EmployeeSkillTagType I_EmployeeskillTags EmployeeSkillTagType Tag Type
EmployeeSkillTagName I_EmployeeskillTags EmployeeSkillTagName Tag
SystemOfRecordID I_EmployeeskillTags SystemOfRecordID System ID
LastChangeDate I_EmployeeskillTags LastChangeDate Time Stamp
LastChangedByUser I_EmployeeskillTags LastChangedByUser User Name
LastChangedByUserFullName User Name

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 P_Empfactsheet_Tags.
-- 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: PEMPFSTAG

CREATE VIEW P_Empfactsheet_Tags AS
SELECT
  Tags.PersonnelNumber AS PersonnelNumber,
  Tags.EmployeeSkillTagID AS EmployeeSkillTagID,
  Tags.EmployeeSkillTagType AS EmployeeSkillTagType,
  Tags.EmployeeSkillTagName AS EmployeeSkillTagName,
  Tags.SystemOfRecordID AS SystemOfRecordID,
  Tags.LastChangeDate AS LastChangeDate,
  Tags.LastChangedByUser AS LastChangedByUser,
  Tags._CreatedByUser.UserDescription AS LastChangedByUserFullName
FROM I_EmployeeskillTags AS Tags
;

Learn More