CNV_PE_MC_STEP_INFO

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_STEP_INFO.
-- 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_STEP_INFO

CREATE VIEW CNV_PE_MC_STEP_INFO AS
SELECT
  opt_num.area_id AS area_id,
  step_num.option_id AS option_id,
  ltrim(vr.seqnum,'0') AS option_seq,
  coalesce( substring(pe_obj_logon.descr,1,55), substring(pe_obj_en.descr,1,55) ) AS option_descr,
  cast(opt_num.option_num as abap.sstring(16)) AS option_num,
  step.trfm_id AS step_id,
  ltrim(step.step,'0') AS step_seq,
  coalesce( substring(stept_logon.descr,1,55), substring(stept_en.descr,1,55) ) AS step_descr,
  cast(step_num.step_num as abap.sstring(16)) AS step_num,
  trfm.sim_type AS sim_type,
  case when ffn.semantic_object is not initial then 'X' else '' end AS nav_valid
FROM cnv_pe_exe_step AS step
INNER JOIN cnv_pe_trfm AS trfm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_vr AS vr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_exe_stept AS stept_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_exe_stept AS stept_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS pe_obj_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS pe_obj_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CNV_PE_MC_OPT_NUM AS opt_num ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CNV_PE_MC_STEP_NUM AS step_num ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_trfm_ffn AS ffn ON /* join condition not captured in parsed metadata */
;