/APE/C_CheckActionAss

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 /APE/C_CheckActionAss.
-- 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: /APE/C_VCHKACTA

CREATE VIEW /APE/C_CheckActionAss AS
SELECT
  _CheckGroup.check_group AS check_group,
  _CheckGroupAssign.seq_no AS seq_no,
  _CheckGroupAssign.check_id AS check_id,
  _CheckResultAssign.check_result AS check_result,
  ActAss.action_code AS action_code,
  ActAss.proc_status AS proc_status,
  ActAss.prst_status AS prst_status,
  ActAss.proc_value AS proc_value,
  ActAss.proc_event AS proc_event,
  ActAss.bo_code AS bo_code,
  ActAss.proc_cluster AS proc_cluster,
  ActAss.version AS version
FROM /APE/I_CheckActionAssign_TP AS ActAss
LEFT OUTER JOIN /APE/C_ExceptionID AS _ExceptionID ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /APE/C_CheckActionID AS _CheckActionID ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /APE/C_CheckGroupAssign AS _CheckGroupAssign ON check_assign_uuid = _CheckGroupAssign.check_assign_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/C_CheckGroup AS _CheckGroup ON check_group_uuid = _CheckGroup.check_group_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/C_CheckResultAssign AS _CheckResultAssign ON result_assign_uuid = _CheckResultAssign.result_assign_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/C_CheckActionAssignCust AS _ActionAssignCust ON action_assign_uuid = _ActionAssignCust.ape_parent_key  -- association [0..1]
;