I_HCMProcess

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_HCMProcess.
-- 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_HCMProcess AS
SELECT
  HCMProcessUUID,
  HCMProcessReferenceNumber,
  HCMProcessNameCode,
  HCMProcessInitiatorUserID,
  HCMProcessInitiatorRole,
  HCMProcessRecruitingScenario,
  HCMProcessStatus,
  HCMProcessApplicationType,
  HCMProcessAffectedObject,
  HCMProcessStartDate,
  HCMProcessStartTime,
  HCMProcessStartDateTime,
  HCMProcessStartTimeDiff,
  HCMProcessCompletionDate,
  HCMProcessCompletionTime,
  HCMProcessCompltnDateTime,
  case HCMProcessCompltnDateTime when 0 then cast(tstmp_seconds_between( HCMProcessStartDateTime, tstmp_current_utctimestamp() , 'NULL') as abap.fltp) / 3600.0 else cast(tstmp_seconds_between( HCMProcessStartDateTime , HCMProcessCompltnDateTime , 'NULL') as abap.fltp) / 3600.0 end as HCMProcExecutionDuration AS 0endasHCMProcExecutionDuration,
  case HCMProcessCompltnDateTime when 0 then cast(tstmp_seconds_between( HCMProcessStartDateTime , tstmp_current_utctimestamp() , 'NULL') as abap.fltp) / 3600.0 / 24.0 else cast(tstmp_seconds_between( HCMProcessStartDateTime , HCMProcessCompltnDateTime , 'NULL') as abap.fltp) / 3600.0 / 24.0 end as HCMProcExecutionTimeInDays AS 0endasHCMProcExecutionTimeInDays,
  cast('H' as msehi) AS HCMProcExecutionDurationUnit,
  cast('TAG' as msehi) AS HCMProcExecutionTimeInDaysUnit,
  HCMProcessCompltnTimeDiff,
  HCMProcessNumberOfAttachments,
  HCMProcessHasError,
  HCMProcessObjectVersionValue,
  HCMProcessBusinessUserID,
  HCMProcAffcdObjDesc,
  HCMProcessAffectedObjectType,
  HCMProcessGroupReferenceNumber,
  HCMProcessGroup,
  HCMProcessEffectiveDate,
  cast(1 as asr_number_of_processes) AS HCMNmbrOfProcesses,
  _HCMPosition.HCMOrganizationalUnit AS HCMPositionOrganizationalUnit,
  _HCMOrglAssgmt.HCMPersonnelArea AS HCMPersonnelArea,
  _HCMOrglAssgmt.HCMPersonnelSubarea AS HCMPersonnelSubarea,
  _HCMOrglAssgmt.HCMEmployeeGroup AS HCMEmployeeGroup,
  _HCMOrglAssgmt.HCMEmployeeSubgroup AS HCMEmployeeSubgroup,
  _HCMOrglAssgmt.HCMOrganizationalUnit AS HCMEmployeeOrganizationalUnit,
  _HCMOrglAssgmt.CompanyCode AS HCMEmployeeCompanyCode,
  _HCMOrglAssgmt.HCMPosition AS HCMEmployeePosition,
  _HCMOrglAssgmt._HCMPersonnelArea.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  _HCMCurrentPayrollStatus.HCMEmployeeBlockingDate AS HCMEmployeeBlockingDate,
  _HCMProcessNameText.HCMProcessDescription AS HCMProcessDescription,
  _HCMProcessAdditionalInfo.HCMProcessProcessingDuration AS HCMProcessProcessingDuration,
  _HCMProcessAdditionalInfo.HCMProcessRetentionDuration AS HCMProcessRetentionDuration,
  _HCMProcessAdditionalInfo.HCMProcessProcgTimeUnit AS HCMProcessProcgTimeUnit,
  _HCMProcessAdditionalInfo.HCMProcessRetentionTimeUnit AS HCMProcessRetentionTimeUnit,
  _ProcessStart.CalendarMonth AS HCMProcStartMonth,
  _ProcessStart.CalendarQuarter AS HCMProcStartQuarter,
  _ProcessStart.CalendarWeek AS HCMProcStartWeek
FROM I_HCMProcessBasic
LEFT OUTER JOIN I_HCMProcessAdditionalInfo AS _HCMProcessAdditionalInfo ON HCMProcessUUID = _HCMProcessAdditionalInfo.HCMProcessUUID  -- association [1..1]
LEFT OUTER JOIN I_HCMProcessScenario AS _HCMProcessScenario ON HCMProcessUUID = _HCMProcessScenario.HCMProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessStepDetails AS _HCMProcessStepDetails ON HCMProcessUUID = _HCMProcessStepDetails.HCMProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _OrgUnit ON HCMProcessAffectedObject = _OrgUnit.HCMOrganizationalUnit AND HCMProcessAffectedObjectType = 'O'  -- association [1..1]
LEFT OUTER JOIN I_HCMPosition AS _HCMPosition ON HCMProcessAffectedObject = _HCMPosition.HCMPosition AND HCMProcessAffectedObjectType = 'S'  -- association [0..*]
LEFT OUTER JOIN I_HCMOrganizationalAssignment AS _HCMOrglAssgmt ON HCMProcessAffectedObject = _HCMOrglAssgmt.HCMPersonnelNumber AND HCMProcessAffectedObjectType = 'P' AND HCMProcessStartDate between _HCMOrglAssgmt.StartDate AND _HCMOrglAssgmt.EndDate  -- association [0..*]
LEFT OUTER JOIN I_HCMCurrentBasicPay AS _HCMCurrentBasicPay ON HCMProcessAffectedObject = _HCMCurrentBasicPay.HCMPersonnelNumber  -- association [0..*]
LEFT OUTER JOIN I_HCMCurrentPersonalData AS _HCMCurrentPersonalData ON HCMProcessAffectedObject = _HCMCurrentPersonalData.HCMPersonnelNumber  -- association [0..*]
LEFT OUTER JOIN I_HCMCurrentPayrollStatus AS _HCMCurrentPayrollStatus ON HCMProcessAffectedObject = _HCMCurrentPayrollStatus.HCMPersonnelNumber  -- association [0..*]
LEFT OUTER JOIN I_CalendarDate AS _ProcessStart ON HCMProcessStartDate = _ProcessStart.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ProcessCompletion ON HCMProcessCompletionDate = _ProcessCompletion.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessNameText AS _HCMProcessNameText ON HCMProcessNameCode = _HCMProcessNameText.HCMProcessNameCode AND _HCMProcessNameText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessStatus AS _HCMProcessStatus ON HCMProcessStatus = _HCMProcessStatus.HCMProcessStatus  -- association [0..1]
;