/APE/I_CheckActionAssignTP_C

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/I_CheckActionAssignTP_C.
-- 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 /APE/I_CheckActionAssignTP_C AS
SELECT
  config_key,
  ape_root_key,
  _CheckGroup.proc_cluster AS proc_cluster,
  _CheckGroup.version AS version,
  _CheckGroupAssign.check_id AS check_id,
  _CheckResultAssign.check_result AS check_result,
  _CheckActionID.action_code AS action_code,
  proc_status,
  prst_status,
  _ProcessValue.proc_value AS proc_value,
  _ProcessEvent.proc_event AS proc_event,
  bo_code,
  created_at_,
  created_by_,
  changed_at_,
  changed_by_
FROM /APE/I_CheckActionAssign_C
LEFT OUTER JOIN /APE/I_CheckGroupTP_C AS _CheckGroup ON _CheckGroup.config_key = ape_root_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_CheckResultAssign_TP AS _CheckResultAssign ON result_assign_uuid = _CheckResultAssign.config_key  -- association [1..*]
LEFT OUTER JOIN /APE/I_CheckActionID_TP AS _CheckActionID ON action_code_uuid = _CheckActionID.config_key  -- association [0..1]
LEFT OUTER JOIN /APE/I_CheckActionCodeText_C AS _CheckActionText ON action_code_uuid = _CheckActionText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_CheckResultText_C AS _CheckResultText ON check_result = _CheckResultText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_ExceptionCodeID_C AS _ExceptionCode ON exception_code_uuid = _ExceptionCode.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessValue_TP AS _ProcessValue ON proc_value_uuid = _ProcessValue.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessEvent_TP AS _ProcessEvent ON proc_event_uuid = _ProcessEvent.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_BusStatus_TP AS _BusStatus ON proc_bus_status_uuid = _BusStatus.config_key  -- association [0..1]
LEFT OUTER JOIN /APE/I_ProcessValueText_C AS _ProcessValueText ON proc_value_uuid = _ProcessValueText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_ProcessEventText_C AS _ProcessEventText ON proc_event_uuid = _ProcessEventText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_ExceptionCodeIDText_C AS _ExceptionCodeIDText ON exception_code_uuid = _ExceptionCodeIDText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_BusinessStatusText_C AS _BusinessStatusText ON proc_bus_status_uuid = _BusinessStatusText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _ProcStatus ON _ProcStatus.Name = '/APE/D_PROC_STATUS' AND _ProcStatus.ValueCode = proc_status  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _ProcessStepStatusVH ON _ProcessStepStatusVH.Name = '/APE/D_PROC_STEP_STATUS' AND _ProcessStepStatusVH.ValueCode = prst_status  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _ProcessStatusText ON _ProcessStatusText.Name = '/APE/D_PROC_STATUS' AND _ProcessStatusText.ValueCode = proc_status  -- association [0..*]
;