HRPY_PCC_recurrence

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_recurrence.
-- 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: HRPY_PCC_RC

CREATE VIEW HRPY_PCC_recurrence AS
SELECT
  recurrence.ref_id AS rec_ref_id,
  recurrence.cfg_ref_id AS cfg_ref_id,
  recurrence.period_year AS period_year,
  recurrence.period_id AS period_id,
  recurrence.period_date AS period_date,
  recurrence.payid AS payid,
  recurrence.ocrsn AS ocrsn,
  oc_reason_text.ocrtx AS ocrsn_name,
  recurrence.id AS id,
  recurrence_details_text.name AS name,
  recurrence.acl_category AS category,
  recurrence.frequency AS frequency,
  activity_list.icon AS icon,
  activity_list.molga AS molga,
  recurrence.lc_user AS lc_user,
  last_changed_user_name.name_text AS lc_user_name,
  recurrence.cr_user AS cr_user,
  created_user_name.name_text AS cr_user_name,
  recurrence.cr_dt AS cr_dt,
  recurrence.lc_dt AS lc_dt,
  oc_category.payty AS payty
FROM pyt_d_acl_reso AS recurrence
LEFT OUTER JOIN pyc_d_tl_rect AS recurrence_details_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pyc_d_tlt AS activity_list_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 */
LEFT OUTER JOIN t52ocrt AS oc_reason_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t52ocr AS oc_reason ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t52occ AS oc_category ON /* join condition not captured in parsed metadata */
;