HRPY_PCC_BPCM_gen

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_BPCM_gen.
-- 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_BM_GC

CREATE VIEW HRPY_PCC_BPCM_gen AS
SELECT
  step_recurrence.acl_recur_ref_id AS rec_ref_id,
  step_recurrence.act_recur_ref_id AS ac_ref_id,
  step_recurrence.ref_id AS step_ref_id,
  message.rpt_chain_id AS rpt_chain_id,
  message.rej_obj_type AS type,
  message.rej_obj_id AS id,
  message.seqnr AS seqnr,
  message.msgty AS msgty,
  msgty_text.name AS msgty_name,
  message.msgid AS msgid,
  message.msgno AS msgno,
  message.msgv1 AS msgv1,
  message.msgv2 AS msgv2,
  message.msgv3 AS msgv3,
  message.msgv4 AS msgv4,
  message.text AS text,
  object_type_text.name AS type_name,
  concat( step_recurrence.ref_id, concat( message.rpt_chain_id, concat( message.rej_obj_id, concat( message.seqnr, concat( message.msgty, concat( message.msgid, message.msgno ) ) ) ) ) ) AS message_key
FROM pyt_d_bpc AS bpc_info
LEFT OUTER JOIN pyc_d_msgty_t AS msgty_text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN pyt_d_bpc_type_t AS object_type_text ON /* join condition not captured in parsed metadata */
;