I_HCMProfileRoot

DDL: I_HCMPROFILEROOT Type: view_entity TRANSACTIONAL
63 Fields 1 Data Sources 1 Associations

My Profile Root

I_HCMProfileRoot is a Transactional CDS View that provides data about "My Profile Root" in SAP S/4HANA. It reads from 1 data source (I_HCMEmployee) and exposes 63 fields with key field HCMPersonnelNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_HCMEmployee _Employee from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_HCM_ESSPersonalDataTP _ESSPersonalData _ESSPersonalData.HCMPersonnelNumber = $projection.HCMPersonnelNumber and _ESSPersonalData.StartDate <= $session.system_date and _ESSPersonalData.EndDate >= $session.system_date and _ESSPersonalData.HCMRecordIsLocked = ' '

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label My Profile Root view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber I_HCMEmployee HCMPersonnelNumber Personnel No.
HCMEmployeeName I_HCMEmployee HCMEmployeeName Empl./appl.name
CompanyCode I_HCMEmployee CompanyCode Receiver Company Code
HCMPersonnelArea I_HCMEmployee HCMPersonnelArea Personnel area
HCMPersonnelSubarea I_HCMEmployee HCMPersonnelSubarea Pers. subarea
HCMEmployeeGroup I_HCMEmployee HCMEmployeeGroup EE group
HCMEmployeeSubgroup I_HCMEmployee HCMEmployeeSubgroup EE subgroup
ControllingArea I_HCMEmployee ControllingArea Controlling Area
CostCenter I_HCMEmployee CostCenter Cost Center
HCMOrganizationalUnit I_HCMEmployee HCMOrganizationalUnit Org. Unit
HCMPosition I_HCMEmployee HCMPosition
HCMJob I_HCMEmployee HCMJob
HCMPayrollArea I_HCMEmployee HCMPayrollArea
HCMGrpgValForPersAssignments _Contract HCMGrpgValForPersAssignments Grouping Value
HCMEmplHasSidelineJobAllowance _Contract HCMEmplHasSidelineJobAllowance
HCMEmplHasCompetitionClause _Contract HCMEmplHasCompetitionClause
HCMContinuedPayDuration _Contract HCMContinuedPayDuration
HCMContinuedPayDurationUnit _Contract HCMContinuedPayDurationUnit
HCMContinuedPaySpecialRuleCode _Contract HCMContinuedPaySpecialRuleCode
HCMSickPaySupplementDuration _Contract HCMSickPaySupplementDuration
HCMSickPaySuplmntDurationUnit _Contract HCMSickPaySuplmntDurationUnit
HCMProbationPeriodDuration _Contract HCMProbationPeriodDuration
HCMProbationPeriodDurationUnit _Contract HCMProbationPeriodDurationUnit
HCMNoticePeriodForEmployerCode _Contract HCMNoticePeriodForEmployerCode
HCMNoticePeriodForEmployeeCode _Contract HCMNoticePeriodForEmployeeCode
HCMWorkPermitExpirationDate _Contract HCMWorkPermitExpirationDate
HCMEntryDate _Contract HCMEntryDate
HCMCorporationEntryDate _Contract HCMCorporationEntryDate
HCMCorporationCode _Contract HCMCorporationCode
HCMContractType _Contract HCMContractType
HCMContractStartDate _Contract HCMContractStartDate
HCMContractEndDate _Contract HCMContractEndDate
WeeklyWorkdays _PlannedWorkingTime WeeklyWorkdays
WeeklyWorkingHours _PlannedWorkingTime WeeklyWorkingHours Working Hours
EmploymentPercent _PlannedWorkingTime EmploymentPercent Emplymt Percentage
HCMEmployeeFormOfAddressKey _ESSPersonalData HCMEmployeeFormOfAddressKey Form of Address
HCMEmployeeFirstName _ESSPersonalData HCMEmployeeFirstName First Name
HCMEmployeeLastName _ESSPersonalData HCMEmployeeLastName Last Name
HCMEmployeeBirthDate _ESSPersonalData HCMEmployeeBirthDate Date of birth
HCMEmployeeCommLanguage _ESSPersonalData HCMEmployeeCommLanguage Communication L
HCMEmployeeNationality _ESSPersonalData HCMEmployeeNationality Nationality
HCMEmployeeMaritalStatus _ESSPersonalData HCMEmployeeMaritalStatus Marital stat.
HCMEmplCurMaritalStsValdFrmDte _ESSPersonalData HCMEmplCurMaritalStsValdFrmDte Since
HCMEmployeeNumberOfChildren _ESSPersonalData HCMEmployeeNumberOfChildren No.of children
HCMManagerPersonnelNumber
HCMManagerName
HCMCountryRegionGrouping
_CompanyCode I_HCMEmployee _CompanyCode
_ControllingArea I_HCMEmployee _ControllingArea
_CostCenter I_HCMEmployee _CostCenter
_EmployeeOfficeAddress I_HCMEmployee _EmployeeOfficeAddress
_EmployeeTimeZone I_HCMEmployee _EmployeeTimeZone
_HCMEmployeeGroup I_HCMEmployee _HCMEmployeeGroup
_HCMEmployeeSubgroup I_HCMEmployee _HCMEmployeeSubGroup
_HCMPayrollArea I_HCMEmployee _HCMPayrollArea
_HCMPersonnelArea I_HCMEmployee _HCMPersonnelArea
_HCMPersonnelSubarea I_HCMEmployee _HCMPersonnelSubarea
_InternalData I_HCMEmployee _InternalData
_ManagerOfEmployee I_HCMEmployee _ManagerOfEmployee
_ContractType _Contract _ContractType
_NoticePeriodEmployee _Contract _NoticePeriodEmployee
_UnitOfMeasureProbPeriodUnit _Contract _UnitOfMeasureProbPeriodUnit
_ESSPersonalData _ESSPersonalData

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_HCMProfileRoot.
-- 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_HCMProfileRoot AS
SELECT
  _Employee.HCMPersonnelNumber AS HCMPersonnelNumber,
  _Employee.HCMEmployeeName AS HCMEmployeeName,
  _Employee.CompanyCode AS CompanyCode,
  _Employee.HCMPersonnelArea AS HCMPersonnelArea,
  _Employee.HCMPersonnelSubarea AS HCMPersonnelSubarea,
  _Employee.HCMEmployeeGroup AS HCMEmployeeGroup,
  _Employee.HCMEmployeeSubgroup AS HCMEmployeeSubgroup,
  _Employee.ControllingArea AS ControllingArea,
  _Employee.CostCenter AS CostCenter,
  _Employee.HCMOrganizationalUnit AS HCMOrganizationalUnit,
  _Employee.HCMPosition AS HCMPosition,
  _Employee.HCMJob AS HCMJob,
  _Employee.HCMPayrollArea AS HCMPayrollArea,
  _Contract.HCMGrpgValForPersAssignments AS HCMGrpgValForPersAssignments,
  _Contract.HCMEmplHasSidelineJobAllowance AS HCMEmplHasSidelineJobAllowance,
  _Contract.HCMEmplHasCompetitionClause AS HCMEmplHasCompetitionClause,
  _Contract.HCMContinuedPayDuration AS HCMContinuedPayDuration,
  _Contract.HCMContinuedPayDurationUnit AS HCMContinuedPayDurationUnit,
  _Contract.HCMContinuedPaySpecialRuleCode AS HCMContinuedPaySpecialRuleCode,
  _Contract.HCMSickPaySupplementDuration AS HCMSickPaySupplementDuration,
  _Contract.HCMSickPaySuplmntDurationUnit AS HCMSickPaySuplmntDurationUnit,
  _Contract.HCMProbationPeriodDuration AS HCMProbationPeriodDuration,
  _Contract.HCMProbationPeriodDurationUnit AS HCMProbationPeriodDurationUnit,
  _Contract.HCMNoticePeriodForEmployerCode AS HCMNoticePeriodForEmployerCode,
  _Contract.HCMNoticePeriodForEmployeeCode AS HCMNoticePeriodForEmployeeCode,
  _Contract.HCMWorkPermitExpirationDate AS HCMWorkPermitExpirationDate,
  _Contract.HCMEntryDate AS HCMEntryDate,
  _Contract.HCMCorporationEntryDate AS HCMCorporationEntryDate,
  _Contract.HCMCorporationCode AS HCMCorporationCode,
  _Contract.HCMContractType AS HCMContractType,
  _Contract.HCMContractStartDate AS HCMContractStartDate,
  _Contract.HCMContractEndDate AS HCMContractEndDate,
  _PlannedWorkingTime.WeeklyWorkdays AS WeeklyWorkdays,
  _PlannedWorkingTime.WeeklyWorkingHours AS WeeklyWorkingHours,
  _PlannedWorkingTime.EmploymentPercent AS EmploymentPercent,
  _ESSPersonalData.HCMEmployeeFormOfAddressKey AS HCMEmployeeFormOfAddressKey,
  _ESSPersonalData.HCMEmployeeFirstName AS HCMEmployeeFirstName,
  _ESSPersonalData.HCMEmployeeLastName AS HCMEmployeeLastName,
  _ESSPersonalData.HCMEmployeeBirthDate AS HCMEmployeeBirthDate,
  _ESSPersonalData.HCMEmployeeCommLanguage AS HCMEmployeeCommLanguage,
  _ESSPersonalData.HCMEmployeeNationality AS HCMEmployeeNationality,
  _ESSPersonalData.HCMEmployeeMaritalStatus AS HCMEmployeeMaritalStatus,
  _ESSPersonalData.HCMEmplCurMaritalStsValdFrmDte AS HCMEmplCurMaritalStsValdFrmDte,
  _ESSPersonalData.HCMEmployeeNumberOfChildren AS HCMEmployeeNumberOfChildren,
  _Employee._ManagerOfEmployee.HCMManagerPersonnelNumber AS HCMManagerPersonnelNumber,
  _Employee._ManagerOfEmployee._Manager.HCMEmployeeName AS HCMManagerName,
  _Employee._HCMPersonnelArea.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  _Employee._CompanyCode AS _CompanyCode,
  _Employee._ControllingArea AS _ControllingArea,
  _Employee._CostCenter AS _CostCenter,
  _Employee._EmployeeOfficeAddress AS _EmployeeOfficeAddress,
  _Employee._EmployeeTimeZone AS _EmployeeTimeZone,
  _Employee._HCMEmployeeGroup AS _HCMEmployeeGroup,
  _Employee._HCMEmployeeSubGroup AS _HCMEmployeeSubgroup,
  _Employee._HCMPayrollArea AS _HCMPayrollArea,
  _Employee._HCMPersonnelArea AS _HCMPersonnelArea,
  _Employee._HCMPersonnelSubarea AS _HCMPersonnelSubarea,
  _Employee._InternalData AS _InternalData,
  _Employee._ManagerOfEmployee AS _ManagerOfEmployee,
  _Contract._ContractType AS _ContractType,
  _Contract._NoticePeriodEmployee AS _NoticePeriodEmployee,
  _Contract._UnitOfMeasureProbPeriodUnit AS _UnitOfMeasureProbPeriodUnit
FROM I_HCMEmployee AS _Employee
LEFT OUTER JOIN I_HCM_ESSPersonalDataTP AS _ESSPersonalData ON _ESSPersonalData.HCMPersonnelNumber = HCMPersonnelNumber AND _ESSPersonalData.StartDate <= $session.system_date AND _ESSPersonalData.EndDate >= $session.system_date AND _ESSPersonalData.HCMRecordIsLocked = ' '  -- association [0..1]
;

Learn More