C_HCMProcOrgUntListForAdmintr

DDL: C_HCMPROCORGUNTLISTFORADMINTR Type: view_entity CONSUMPTION
17 Fields 1 Data Sources

Org Units managed by a HR Administrator

C_HCMProcOrgUntListForAdmintr is a Consumption CDS View that provides data about "Org Units managed by a HR Administrator" in SAP S/4HANA. It reads from 1 data source (I_HCMObject) and exposes 17 fields with key fields HCMPlanVersion, HCMObjectType, HCMOrganizationalUnit, 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 Org Units managed by a HR Administrator view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S 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_ORGLIST_ADMIN view

Fields (17)

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

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_HCMProcOrgUntListForAdmintr.
-- 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_HCMProcOrgUntListForAdmintr AS
SELECT
  HCMPlanVersion,
  HCMObjectType,
  HCMObjectID AS HCMOrganizationalUnit,
  HCMPlanningStatus,
  StartDate,
  EndDate,
  Language,
  HCMSequentialNumber,
  HCMInfoType,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordReason,
  HCMInfoTypeRecordIsHistorical,
  HCMInfoTypeTextModule,
  HCMObjectShortText,
  HCMObjectText AS HCMOrganizationalUnitName,
  HCMObjectDelimitDate
FROM I_HCMObject
;

Learn More