I_HCMEmployeeSubgroup

DDL: I_HCMEMPLOYEESUBGROUP Type: view_entity BASIC

HCM Employee Subgroup

I_HCMEmployeeSubgroup is a Basic CDS View (Dimension) that provides data about "HCM Employee Subgroup" in SAP S/4HANA. It reads from 1 data source (t503k) and exposes 2 fields with key field HCMEmployeeSubgroup. It has 1 association to related views. It is exposed through 5 OData services (UI_HCMACTUALACTIVITIES, UI_HCMACTUALACTIVITIES_EMP, UI_HCMCOMPLIANCE, ...). It is used in 3 Fiori applications: HCM Processes (S/4HANA), Timesheet Analytics - Activities (S/4HANA), Timesheet Analytics - My Activities (S/4HANA).

Data Sources (1)

SourceAliasJoin Type
t503k t503k from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_HCMEmployeeSubgroupText _Text $projection.HCMEmployeeSubgroup = _Text.HCMEmployeeSubgroup

Annotations (13)

NameValueLevelField
EndUserText.label HCM Employee Subgroup view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey HCMEmployeeSubgroup view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Search.searchable true view
VDM.viewType #BASIC view

OData Services (5)

ServiceBindingVersionContractRelease
UI_HCMACTUALACTIVITIES UI_HCMACTUALACTIVITIES V2 C1 NOT_RELEASED
UI_HCMACTUALACTIVITIES_EMP UI_HCMACTUALACTIVITIES_EMP V2 C1 NOT_RELEASED
UI_HCMCOMPLIANCE UI_HCMCOMPLIANCE_V2 V2 C1 NOT_RELEASED
UI_HCMCOMPLIANCE_EMP UI_HCMCOMPLIANCE_EMP_V2 V2 C1 NOT_RELEASED
UI_HCMPROCESS UI_HCMPROCESS V2 C1 NOT_RELEASED

Fiori Apps (3)

App IDApp NameTypeDescription
F6686 HCM Processes (S/4HANA) Analytical Analytical app that allows Manager or Time Administrator to drill down on activities by various dimensions
F6687 Timesheet Analytics - Activities (S/4HANA) Analytical Analytical app that allows Manager or Time Administrator to drill down on activities by various dimensions
F7189 Timesheet Analytics - My Activities (S/4HANA) Analytical Analytical app that allows Employee to drill down on activities by various dimensions

HCM Processes (S/4HANA)

Business Role: Others

With this app, you as an authorized user can view all the Human Resources (HR) processes within your area of responsibility. You can also analyze the HR processes based on different KPIs such as time to complete the processes, average processing time, average retention time and average execution time.

Timesheet Analytics - Activities (S/4HANA)

Business Role: Manager - HR Info

With this feature, you as an authorized user can view all timesheet records within your area of responsibility. You can also analyze the timesheet records based on different attributes such as attendance or absence type, cost center, project, network or controlling area, for example.

Timesheet Analytics - My Activities (S/4HANA)

Business Role: Employee - HR Info

With this feature, you as an employee can view all of your timesheet records. You can also analyze the timesheet records based on different attributes such as attendance or absence type, cost center, project, network or controlling area, for example.

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY HCMEmployeeSubgroup persk EE subgroup
_Text _Text

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_HCMEmployeeSubgroup.
-- 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.

CREATE VIEW I_HCMEmployeeSubgroup AS
SELECT
  persk AS HCMEmployeeSubgroup
FROM t503k
LEFT OUTER JOIN I_HCMEmployeeSubgroupText AS _Text ON HCMEmployeeSubgroup = _Text.HCMEmployeeSubgroup  -- association [0..*]
;