C_HCMProcPosListForAdmintr

DDL: C_HCMPROCPOSLISTFORADMINTR Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Positions managed by a HR Administrator

C_HCMProcPosListForAdmintr is a Consumption CDS View that provides data about "Positions managed by a HR Administrator" in SAP S/4HANA. It reads from 1 data source (I_HCMObject) and exposes 22 fields with key fields HCMPlanVersion, HCMObjectType, HCMPosition, HCMPlanningStatus, StartDate.

Data Sources (1)

SourceAliasJoin Type
I_HCMObject I_HCMObject from

Parameters (1)

NameTypeDefault
P_HCMProcessEffectiveDate sydatum

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Positions managed by a HR Administrator view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view
Feature SW:H4S4_SFWS_SC_01 view
ObjectModel.query.implementedBy ABAP:CL_CE_HRFIO_ASR_POSLIST_ADMIN view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY HCMPlanVersion I_HCMObject HCMPlanVersion Plan version
KEY HCMObjectType I_HCMObject HCMObjectType Type of Val.
KEY HCMPosition I_HCMObject HCMObjectID Work Center
KEY HCMPlanningStatus I_HCMObject HCMPlanningStatus System status
KEY StartDate I_HCMObject StartDate Valid From
KEY EndDate I_HCMObject EndDate Term to
KEY Language I_HCMObject Language Report Text Language
KEY HCMSequentialNumber I_HCMObject HCMSequentialNumber IT record no.
HCMInfoType I_HCMObject HCMInfoType Prefix
LastChangedDate I_HCMObject LastChangedDate Created On
LastChangedByUser I_HCMObject LastChangedByUser User Name
HCMInfoTypeRecordReason I_HCMObject HCMInfoTypeRecordReason Reason for inclusion
HCMInfoTypeRecordIsHistorical I_HCMObject HCMInfoTypeRecordIsHistorical Historical rec.
HCMInfoTypeTextModule I_HCMObject HCMInfoTypeTextModule Text Module
HCMObjectShortText I_HCMObject HCMObjectShortText Shortened form
HCMObjectText I_HCMObject HCMObjectText Text
HCMObjectDelimitDate I_HCMObject HCMObjectDelimitDate Delimit date
HCMRelatedObjectType HCMObjectRelationship HCMRelatedObjectType
HCMOrganizationalUnit
HCMOrganizationalUnitName
HCMPositionVacancyStatus HCMPositionVacancy HCMPositionVacancyStatus
HCMPositionVacancyStatusText

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 C_HCMProcPosListForAdmintr.
-- 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.
-- Parameters: P_HCMProcessEffectiveDate : sydatum

CREATE VIEW C_HCMProcPosListForAdmintr AS
SELECT
  I_HCMObject.HCMPlanVersion AS HCMPlanVersion,
  I_HCMObject.HCMObjectType AS HCMObjectType,
  I_HCMObject.HCMObjectID AS HCMPosition,
  I_HCMObject.HCMPlanningStatus AS HCMPlanningStatus,
  I_HCMObject.StartDate AS StartDate,
  I_HCMObject.EndDate AS EndDate,
  I_HCMObject.Language AS Language,
  I_HCMObject.HCMSequentialNumber AS HCMSequentialNumber,
  I_HCMObject.HCMInfoType AS HCMInfoType,
  I_HCMObject.LastChangedDate AS LastChangedDate,
  I_HCMObject.LastChangedByUser AS LastChangedByUser,
  I_HCMObject.HCMInfoTypeRecordReason AS HCMInfoTypeRecordReason,
  I_HCMObject.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  I_HCMObject.HCMInfoTypeTextModule AS HCMInfoTypeTextModule,
  I_HCMObject.HCMObjectShortText AS HCMObjectShortText,
  I_HCMObject.HCMObjectText AS HCMObjectText,
  I_HCMObject.HCMObjectDelimitDate AS HCMObjectDelimitDate,
  HCMObjectRelationship.HCMRelatedObjectType AS HCMRelatedObjectType,
  cast( HCMObjectRelationship.HCMRelatedObjectID as orgeh ) AS HCMOrganizationalUnit,
  cast( '' as stext ) AS HCMOrganizationalUnitName,
  HCMPositionVacancy.HCMPositionVacancyStatus AS HCMPositionVacancyStatus,
  cast( '' as char30 ) AS HCMPositionVacancyStatusText
FROM I_HCMObject
;

Learn More