hrpy_pcc_activity

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_activity.
-- 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_activity AS
SELECT
  run_time_activity.root_ref_id AS rec_ref_id,
  run_time_activity.ref_id AS ac_ref_id,
  run_time_activity.cfg_ref_id AS cfg_ref_id,
  run_time_activity.ac_category AS category,
  activity_text.name AS name,
  run_time_activity.ac_al_id AS id,
  run_time_activity.lc_user AS lc_user,
  last_changed_user_name.name_text AS lc_user_name,
  run_time_activity.lc_user AS cr_user,
  created_user_name.name_text AS cr_user_name,
  run_time_activity.cr_dt AS cr_dt,
  run_time_activity.lc_dt AS lc_dt
FROM pyt_d_act_reso AS run_time_activity
LEFT OUTER JOIN pyc_d_tl_task_t AS activity_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pyt_d_exe_status AS exe_status 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 */
;