C_HCMProcessStep

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_HCMProcessStep.
-- 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: CHCMPROCSTEP

CREATE VIEW C_HCMProcessStep AS
SELECT
  HCMProcessStepUUID,
  HCMProcessScenarioUUID,
  HCMProcessStepName,
  Language,
  HCMProcessStepProcessor,
  HCMProcessStepProcessorRole,
  HCMProcessStageName,
  HCMProcessStepStatus,
  HCMProcStepStatusCriticality,
  HCMProcessStepStartDate,
  HCMProcessStepStartTime,
  HCMProcessStepStartDateTime,
  HCMProcessStepStartTimeDiff,
  HCMProcessStepCompletionDate,
  HCMProcessStepCompletionTime,
  HCMProcStpCompltnDateTme,
  HCMProcessStepCompltnTimeDiff,
  HCMProcessStepLatestStartDate,
  HCMProcessStepLatestStartTime,
  HCMProcessStepLtstStrtDateTime,
  HCMProcessStepLtstStrtTmeDiff,
  HCMProcessStepLatestEndDate,
  HCMProcessStepLatestEndTime,
  HCMProcessStepLtstEndDateTime,
  HCMProcessStepLtstEndTmeDiff,
  HCMProcessStepFwdByUserName,
  HCMProcStepNmbrOfAttachments,
  HCMProcStatusAfterUserAction,
  HCMProcessBusinessStatus,
  HCMProcessUUID,
  HCMProcessNameCode,
  HCMProcessStepChgDateTime,
  HCMProcessStepDraftDateTime,
  HCMProcessProcessingDuration,
  HCMProcessProcgTimeUnit,
  HCMProcessRetentionDuration,
  HCMProcessRetentionTimeUnit,
  cast ('' as abap.char( 400 )) AS HCMProcProcessorName
FROM I_HCMProcessStep
LEFT OUTER JOIN I_HCMProcProcessorRole AS _HCMProcProcessorRole ON HCMProcessStepProcessorRole = _HCMProcProcessorRole.HCMProcessStepProcessorRole  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessStepStatus AS _HCMProcessStepStatus ON HCMProcessStepStatus = _HCMProcessStepStatus.HCMProcessStepStatus  -- association [0..1]
LEFT OUTER JOIN I_HCMProcStepProcessingStatus AS _HCMProcStepProcessingStatus ON HCMProcStatusAfterUserAction = _HCMProcStepProcessingStatus.HCMProcStepProcessingStatus  -- association [0..1]
;