tmo_exp_i_tgv_prv_r

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 tmo_exp_i_tgv_prv_r.
-- 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 tmo_exp_i_tgv_prv_r AS
SELECT
  tg_hdr.Target_Type AS Target_Type,
  tg_hdr.Target_Name AS Target_Name,
  tv_prv.variant_name AS Variant_Name,
  tv_prv.provider_name AS Provider_Name,
  tv_prv.provider_adptr AS Provider_Adptr,
  tv_prv.pipeline_name AS Pipeline_Name,
  coalesce( tg_prv.is_active, tv_prv.is_active ) AS Is_Active,
  coalesce( tg_prv.log_level , tv_prv.log_level ) AS Log_Level,
  coalesce( tg_prv.time_period , tv_prv.time_period ) AS Time_Period,
  tv_prv.description AS Description,
  tv_prv.health_check AS Health_Check,
  tv_prv.priority AS Priority,
  tg_hdr.owner_type AS Owner_Type,
  prv_w.Protocol AS Protocol,
  prv_w.Implementation_Name AS Implementation_Name,
  prv_w.Configuration_Name AS Configuration_Name,
  prv_w.Abap_Language_Version AS Abap_Language_Version,
  prv_w.Instantiation AS Instantiation,
  prv_w.Provider_Category AS Provider_Category
FROM TMO_EXP_I_TG_HEADER_R AS tg_hdr
LEFT OUTER JOIN tmo_exp_tg_prv AS tg_prv ON /* join condition not captured in parsed metadata */
;