HRPY_PCC_step

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 HRPY_PCC_step.
-- 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 HRPY_PCC_step AS
SELECT
  run_time_activity.root_ref_id AS rec_ref_id,
  run_time_step.ac_rec_ref_id AS ac_ref_id,
  run_time_step.ref_id AS step_ref_id,
  run_time_step.cfg_ref_id AS cfg_ref_id,
  activity_step_text.name AS name,
  run_time_step.st_type AS type,
  run_time_step.st_category AS category,
  run_time_step.is_shadow AS is_shadow,
  run_time_step.st_id AS id,
  run_time_step.lc_user AS lc_user,
  last_changed_user_name.name_text AS lc_user_name,
  run_time_step.lc_user AS cr_user,
  created_user_name.name_text AS cr_user_name,
  run_time_step.cr_dt AS cr_dt,
  run_time_step.lc_dt AS lc_dt
FROM pyt_d_step_reso AS run_time_step
LEFT OUTER JOIN pyc_d_task_stept AS activity_step_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pyt_d_err_sta_t AS error_status_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pyt_d_proc_sta_t AS processing_status_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS last_changed_user ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS last_changed_user_name ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS created_user ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp AS created_user_name ON /* join condition not captured in parsed metadata */
;