C_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 C_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.
-- SQL view name: CHCMPROCESS

CREATE VIEW C_HCMProcess AS
SELECT
  HCMProcessUUID,
  HCMNmbrOfProcesses,
  HCMProcessReferenceNumber,
  HCMProcessNameCode,
  _HCMProcessName._Text[1:Language=$session.system_language].HCMProcessDescription AS HCMProcessDescription,
  HCMProcessInitiatorUserID,
  HCMProcessInitiatorRole,
  HCMProcessRecruitingScenario,
  HCMProcessStatus,
  HCMProcessStatusCriticality,
  HCMNmbrOfCompletedProcesses,
  HCMNmbrOfOpenProcesses,
  HCMNmbrOfIncorrectProcesses,
  HCMProcessApplicationType,
  HCMNmbrOfPersAdminProcesses,
  HCMNmbrOfPersDevProcesses,
  HCMProcessAffectedObject,
  HCMProcessStartDate,
  HCMProcessStartTime,
  HCMProcessStartDateTime,
  HCMProcessStartTimeDiff,
  HCMProcessCompletionDate,
  HCMProcessCompletionTime,
  HCMProcessCompltnDateTime,
  fltp_to_dec(hcmprocexecutionduration as abap.dec(13,2)) AS HCMProcExecutionDuration,
  HCMProcExecutionDurationUnit,
  fltp_to_dec(hcmprocexecutiontimeindays as abap.dec(13,2)) AS HCMProcExecutionTimeInDays,
  HCMProcExecutionTimeInDaysUnit,
  HCMProcessCompltnTimeDiff,
  HCMProcessNumberOfAttachments,
  HCMProcessHasError,
  HCMProcessObjectVersionValue,
  HCMProcessBusinessUserID,
  HCMProcAffcdObjDesc,
  HCMProcessAffectedObjectType,
  HCMProcessGroupReferenceNumber,
  HCMProcessGroup,
  HCMProcessEffectiveDate,
  HCMProcStartMonth,
  HCMProcStartQuarter,
  HCMProcStartWeek,
  HCMOrganizationalUnit,
  cast (0 as abap.dec (13,2)) AS HCMProcAvgExecutionDuration,
  cast ('00' as abap.numc(2)) AS HCMProcessErrorRate,
  cast (0 as abap.dec (13,2)) AS HCMProcAvgProcessingDuration,
  cast (0 as abap.dec (13,2)) AS HCMProcAvgRetentionDuration,
  cast ('00' as abap.numc(2)) AS HCMProcessOpenRate,
  cast ('00' as abap.numc(2)) AS HCMProcessCompletionRate,
  HCMPersonnelArea,
  HCMPersonnelSubarea,
  HCMProcessProcessingDuration,
  HCMProcessRetentionDuration,
  HCMProcessProcgTimeUnit,
  HCMProcessRetentionTimeUnit,
  HCMEmployeeGroup,
  HCMEmployeeSubgroup,
  HCMEmployeeCompanyCode,
  HCMEmployeePosition
FROM ihcmprocess AS I_HCMProcess
LEFT OUTER JOIN C_HCMProcessStep AS _HCMProcessStep ON HCMProcessUUID = _HCMProcessStep.HCMProcessUUID  -- association [0..*]
LEFT OUTER JOIN I_HCMProcessStatusVH AS _HCMProcessStatus ON HCMProcessStatus = _HCMProcessStatus.HCMProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessName AS _HCMProcessName ON HCMProcessNameCode = _HCMProcessName.HCMProcessNameCode  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessApplicationTypeVH AS _HCMProcessApplicationType ON HCMProcessApplicationType = _HCMProcessApplicationType.HCMProcessApplicationType  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessInitiator AS _HCMProcessInitiator ON HCMProcessInitiatorUserID = _HCMProcessInitiator.HCMProcessInitiatorUserID  -- association [0..1]
LEFT OUTER JOIN C_HCMProcAffcdObjQuickVw AS _HCMAffcdObjQuickView ON HCMProcessAffectedObjectType = _HCMAffcdObjQuickView.HCMObjectType AND HCMProcessAffectedObject = _HCMAffcdObjQuickView.HCMProcessAffectedObject  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessAffectedObjectType AS _HCMProcessAffectedObjectType ON HCMProcessAffectedObjectType = _HCMProcessAffectedObjectType.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelArea AS _HCMPersonnelArea ON HCMPersonnelArea = _HCMPersonnelArea.HCMPersonnelArea  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelSubarea AS _HCMPersonnelSubarea ON HCMPersonnelSubarea = _HCMPersonnelSubarea.HCMPersonnelSubarea AND HCMPersonnelArea = _HCMPersonnelSubarea.HCMPersonnelArea  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeGroup AS _HCMEmployeeGroup ON HCMEmployeeGroup = _HCMEmployeeGroup.HCMEmployeeGroup  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeSubgroup AS _HCMEmployeeSubgroup ON HCMEmployeeSubgroup = _HCMEmployeeSubgroup.HCMEmployeeSubgroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _HCMEmployeeCompanyCode ON HCMEmployeeCompanyCode = _HCMEmployeeCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HCMPositionVH AS _HCMEmployeePosition ON HCMEmployeePosition = _HCMEmployeePosition.HCMPosition AND HCMProcessAffectedObjectType = _HCMEmployeePosition.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMProcInitiatorRole AS _HCMProcInitiatorRole ON HCMProcessInitiatorRole = _HCMProcInitiatorRole.HCMProcessInitiatorRole  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessGroup AS _HCMProcessGroup ON HCMProcessGroup = _HCMProcessGroup.HCMProcessGroup  -- association [0..1]
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit  -- association [0..*]
;