CNV_PE_MC_ACTIVE_CFGOPTID

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 CNV_PE_MC_ACTIVE_CFGOPTID.
-- 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: CNV_PE_MC_OPTID

CREATE VIEW CNV_PE_MC_ACTIVE_CFGOPTID AS
SELECT
  optids.area_id AS area_id,
  optids.cfg_opt_id AS cfgoptid,
  optid.cfg_opt AS cfgopt,
  coalesce( coalesce( opt_t_logon.descr, opt_t_en.descr ) , optid.cfg_opt) AS cfgopt_descr,
  optid.docu_tx AS document_id
FROM cnv_pe_cfgoptids AS optids
INNER JOIN cnv_pe_cfgoptid AS optid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_cfgoptidt AS optid_t_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_cfgoptidt AS optid_t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_cfgopt_t AS opt_t_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_cfgopt_t AS opt_t_en ON /* join condition not captured in parsed metadata */
;