cnv_dmc_mc_pe_instance_fileds

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_dmc_mc_pe_instance_fileds.
-- 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 cnv_dmc_mc_pe_instance_fileds AS
SELECT
  par.id AS id,
  area.id AS area_id,
  par.name AS name,
  coalesce( coalesce( obj_t_logon.descr, obj_t_en.descr), par.inttext ) AS description,
  par.par_nr AS par_nr,
  par.type AS type,
  concat( 'WORKLIST_ROOT-', par.name ) AS full_name,
  par.is_key AS is_key,
  wl_field.displayed AS displayed,
  wl_field.deleted AS deleted,
  wl_field.customer AS customer,
  wl_field.key_internal AS key_internal
FROM cnv_pe_if_par AS par
INNER JOIN cnv_pe_wl AS wl ON /* join condition not captured in parsed metadata */
INNER JOIN cnv_pe_area AS area ON /* join condition not captured in parsed metadata */
INNER JOIN cnv_pe_if_par AS parent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS obj_t_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS obj_t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_if_par_wl AS wl_field ON /* join condition not captured in parsed metadata */
;