I_HCMPosition

DDL: I_HCMPOSITION Type: view_entity BASIC
19 Fields 1 Data Sources 2 Associations 3 OData Services 2 Fiori Apps

HCM Position

I_HCMPosition is a Basic CDS View (Dimension) that provides data about "HCM Position" in SAP S/4HANA. It reads from 1 data source (t528b) and exposes 19 fields with key fields HCMObjectType, HCMPosition, EndDate. It has 2 associations to related views. It is exposed through 3 OData services (UI_HCMAPPROVETIMESHEET, UI_HCMMYTIMESHEET, UI_HCMMYTIMESHEET). It is used in 2 Fiori applications: Approve Timesheets (S/4HANA / Version 4), My Timesheet (S/4HANA / Version 4).

Data Sources (1)

SourceAliasJoin Type
t528b t528b from

Associations (2)

CardinalityTargetAliasCondition
[1] I_HCMObjectType _HCMObjectType $projection.HCMObjectType = _HCMObjectType.HCMObjectType
[0..*] I_HCMPositionText _Text $projection.HCMPosition = _Text.HCMPosition and $projection.HCMObjectType = _Text.HCMObjectType and $projection.EndDate = _Text.EndDate

Annotations (14)

NameValueLevelField
EndUserText.label HCM Position view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Consumption.filter.businessDate.at true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey HCMPosition 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 (3)

ServiceBindingVersionContractRelease
UI_HCMAPPROVETIMESHEET UI_HCMAPPROVETIMESHEET V2 C1 NOT_RELEASED
UI_HCMMYTIMESHEET API_HCMMYTIMESHEET V2 C2 NOT_RELEASED
UI_HCMMYTIMESHEET UI_HCMMYTIMESHEET V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F2585A Approve Timesheets (S/4HANA / Version 4) Analytical With this app, you as a manager can quickly view all pending approvals of your direct reports and approve timesheets using desktop or mobile devices.
F3074A My Timesheet (S/4HANA / Version 4) Transactional You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device.

Approve Timesheets (S/4HANA / Version 4)

Business Role: Manager - HR Info

With this app, you as a manager can quickly view all pending approvals of your direct reports and approve timesheets using desktop, tablet or mobile devices. This app provides the following key features: Review timesheets for all your employees and view time entry compliance at a glance. View all time entries pending approval or that have already been approved. Filter time entries based on a date range, on specific attributes, or per employee. View designation and contact information of each employee. Approve or reject records by week.

My Timesheet (S/4HANA / Version 4)

Business Role: Employee - HR Info

You, as an employee, can use this app to manage your time entries quickly and efficiently using a desktop or a mobile device. You can use this app to do the following: enter time records for the chosen personnel assignment using form entry or assignments. create or import assignments and manage them. create and manage assignment groups. use horizontal or grid view for time entries. view the calendar for a chosen month on a desktop device, and for a given week on a mobile device. copy and paste time records. access the to-do list. switch between the allowed data entry profiles for a given time entry.

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY HCMObjectType otype Type of Val.
KEY HCMPosition plans Position
KEY EndDate endda Valid To
StartDate begda Valid From
HCMCountryRegionGrouping molga Reserved Field/Unused Field of Length 2
PayScaleType trfar P.scale type
PayScaleArea trfgb PS Area
HCMEmployeeSubgroupGrouping trfkz ESG for CAP
PayScaleGroup trfgr Pay Scale Group
PayScaleLevel trfst PS level
HCMShiftWorkMethod1 arbws Work method
HCMShiftWorkMethod2 awtgr Work method
HCMEmployeeGenderKey gesch Gender
HCMJob stell Job
HCMHeavyLaborPosition schwa HeavyLaborPos.
HCMMaintenanceInOrgMgmt maint OM
HCMOrganizationalUnit orgeh Org. Unit
_HCMObjectType _HCMObjectType
_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_HCMPosition.
-- 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_HCMPosition AS
SELECT
  otype AS HCMObjectType,
  plans AS HCMPosition,
  endda AS EndDate,
  begda AS StartDate,
  molga AS HCMCountryRegionGrouping,
  trfar AS PayScaleType,
  trfgb AS PayScaleArea,
  trfkz AS HCMEmployeeSubgroupGrouping,
  trfgr AS PayScaleGroup,
  trfst AS PayScaleLevel,
  arbws AS HCMShiftWorkMethod1,
  awtgr AS HCMShiftWorkMethod2,
  gesch AS HCMEmployeeGenderKey,
  stell AS HCMJob,
  schwa AS HCMHeavyLaborPosition,
  maint AS HCMMaintenanceInOrgMgmt,
  orgeh AS HCMOrganizationalUnit
FROM t528b
LEFT OUTER JOIN I_HCMObjectType AS _HCMObjectType ON HCMObjectType = _HCMObjectType.HCMObjectType  -- association [1]
LEFT OUTER JOIN I_HCMPositionText AS _Text ON HCMPosition = _Text.HCMPosition AND HCMObjectType = _Text.HCMObjectType AND EndDate = _Text.EndDate  -- association [0..*]
;

Learn More