TMO_EXP_I_TGV_PRV_CONF_RNG_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_CONF_RNG_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_CONF_RNG_R AS
SELECT
  tgv_prv.Target_Type AS Target_Type,
  tgv_prv.Target_Name AS Target_Name,
  tgv_prv.Variant_Name AS Variant_Name,
  tgv_prv.Provider_Name AS Provider_Name,
  tv_pr_cr.set_id AS Set_Id,
  tv_pr_cr.field_id AS Field_Id,
  tv_pr_cr.range_line AS Range_Line,
  tgv_prv.Is_Active AS Is_Active,
  coalesce( tg_pr_cr.range_sign, tv_pr_cr.range_sign ) AS Range_Sign,
  coalesce( tg_pr_cr.range_option, tv_pr_cr.range_option ) AS Range_Option,
  coalesce( tg_pr_cr.low, tv_pr_cr.low ) AS Low,
  coalesce( tg_pr_cr.high, tv_pr_cr.high ) AS High,
  tgv_prv.Owner_Type AS Owner_type,
  case when tv_pr_cr.set_id is not null and tg_pr_cr.set_id is null then 'Delivered Configuration' when tv_pr_cr.set_id is not null then 'Local Overwrite' else 'No Configuration' end as Configuration_Source AS Target_TypeasTarget_Type,
  'Local Configuration' AS Configuration_Source
FROM tmo_exp_i_tgv_prv_r AS tgv_prv
LEFT OUTER JOIN tmo_exp_tv_pr_cr AS tv_pr_cr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tmo_exp_tg_pr_cr AS tg_pr_cr ON /* join condition not captured in parsed metadata */
INNER JOIN tmo_exp_tg_pr_cr AS tg_pr_cr ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): tmo_exp_i_tgv_prv_r
;