I_HCMProcessStepBasic

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_HCMProcessStepBasic.
-- 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_HCMProcessStepBasic AS
SELECT
  case_guid AS HCMProcessStepUUID,
  parent_scenario AS HCMProcessScenarioUUID,
  title AS HCMProcessStepName,
  Language,
  processed_by AS HCMProcessStepProcessor,
  processor_role AS HCMProcessStepProcessorRole,
  scenario_stage AS HCMProcessStageName,
  status AS HCMProcessStepStatus,
  start_date AS HCMProcessStepStartDate,
  start_time AS HCMProcessStepStartTime,
  start_tst AS HCMProcessStepStartDateTime,
  start_delta AS HCMProcessStepStartTimeDiff,
  completion_date AS HCMProcessStepCompletionDate,
  completion_time AS HCMProcessStepCompletionTime,
  completion_tst AS HCMProcStpCompltnDateTme,
  completion_delta AS HCMProcessStepCompltnTimeDiff,
  latest_startdate AS HCMProcessStepLatestStartDate,
  latest_starttime AS HCMProcessStepLatestStartTime,
  latest_starttst AS HCMProcessStepLtstStrtDateTime,
  lateststartdelta AS HCMProcessStepLtstStrtTmeDiff,
  latest_enddate AS HCMProcessStepLatestEndDate,
  latest_endtime AS HCMProcessStepLatestEndTime,
  latest_endtst AS HCMProcessStepLtstEndDateTime,
  latest_enddelta AS HCMProcessStepLtstEndTmeDiff,
  forwarded_by AS HCMProcessStepFwdByUserName,
  no_of_attachment AS HCMProcStepNmbrOfAttachments,
  proc_status AS HCMProcStatusAfterUserAction,
  bstatusid AS HCMProcessBusinessStatus
FROM t5asrsteps
LEFT OUTER JOIN I_HCMProcessScenario AS _HCMProcessScenario ON HCMProcessScenarioUUID = _HCMProcessScenario.HCMProcessScenarioUUID  -- association [0..1]
LEFT OUTER JOIN I_HCMProcessStepDetails AS _HCMProcessStepDetails ON HCMProcessStepUUID = _HCMProcessStepDetails.HCMProcessStepUUID  -- association [0..*]
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]
;