i_islm_p_tkey_runs

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 i_islm_p_tkey_runs.
-- 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 i_islm_p_tkey_runs AS
SELECT
  tkey_run.guid AS guid,
  tkey_run.version AS version,
  tkey_run.status AS status,
  tkey_run.created_by AS created_by,
  tkey_run.created_at AS created_at,
  tkey_run.changed_by AS changed_by,
  tkey_run.changed_at AS changed_at,
  cast( plnd_log.planned_guid as islm2_de_uuid preserving type ) AS Planned_Guid,
  plnd_log.execution_timestamp AS Execution_Timestamp,
  plnd_log.type AS Type,
  plnd_log.id AS Id,
  plnd_log.msg_number AS Msg_Number,
  plnd_log.message AS Message,
  plnd_log.message_v1 AS Message_V1,
  plnd_log.message_v2 AS Message_V2,
  plnd_log.message_v3 AS Message_V3,
  plnd_log.message_v4 AS Message_V4,
  plnd_log.job_name AS Job_Name,
  plnd_log.job_count AS Job_Count,
  plnd_log.log_handle AS Log_Handle,
  plnd_log.ref_entity_id AS Ref_Entity_Id,
  plnd_log.ref_entity_type AS Ref_Entity_Type,
  plnd_log.tkey_run_guid AS TkeyRunGuid
FROM islm_tkey_runs AS tkey_run
INNER JOIN islm_plnd_tk_log AS plnd_log ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_d_jr_rest AS restart_job ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APL_V_APPL_LOG_OVERVIEW AS log_details ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ISLM_P_PSCENARIO AS _scenario ON scenario_name = _scenario.guid  -- association [1..1]
;