/LTB/I_MC_WL_ITEMT

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 /LTB/I_MC_WL_ITEMT.
-- 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: /LTB/V_MC_WLIT

CREATE VIEW /LTB/I_MC_WL_ITEMT AS
SELECT
  i.wl_item_id AS wl_item_id,
  i.wl1_id AS wl1_id,
  i.block_rcv AS block_rcv,
  i.block_snd AS block_snd,
  i.group_id_rcv AS group_id_rcv,
  i.group_id_snd AS group_id_snd,
  i.exclude_rcv AS exclude_rcv,
  i.exclude_snd AS exclude_snd,
  i.no_batch_rcv AS no_batch_rcv,
  i.no_batch_snd AS no_batch_snd,
  i.jobname_rcv AS jobname_rcv,
  i.jobcount_rcv AS jobcount_rcv,
  i.jobname_snd AS jobname_snd,
  i.jobcount_snd AS jobcount_snd,
  i.aborted_rcv AS aborted_rcv,
  i.aborted_snd AS aborted_snd,
  i.skipped AS skipped,
  i.rcv_exe_id AS rcv_exe_id,
  i.snd_exe_id AS snd_exe_id,
  i.rcv_exe_req AS rcv_exe_req,
  i.snd_exe_req AS snd_exe_req,
  i.status_snd AS status_snd,
  i.status_snd_t AS status_snd_t,
  i.status_rcv AS status_rcv,
  i.status_rcv_t AS status_rcv_t,
  i.lognr_snd AS lognr_snd,
  i.lognr_rcv AS lognr_rcv,
  i.exe_step_snd AS exe_step_snd,
  i.exe_step_rcv AS exe_step_rcv,
  i.trfm_id AS trfm_id,
  i.mc_action AS mc_action,
  i.mc_status AS mc_status,
  i.id AS id,
  i.sever_level AS sever_level,
  i.sever AS sever,
  i.obj_type AS obj_type,
  i.status_type AS status_type,
  i.doku_obj AS doku_obj,
  i.icon AS icon,
  coalesce( substring(pe_proj_logon.descr,1,60), substring(pe_proj_en.descr,1,60) ) AS option_descr,
  coalesce( substring(stept_logon.descr,1,60), substring(stept_en.descr,1,60) ) AS step_descr
FROM /LTB/I_MC_WL_ITEM AS i
LEFT OUTER JOIN dd07t AS dom_action_current ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dom_status_current ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dom_action_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd07t AS dom_status_en 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_proj_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object_t AS pe_proj_en ON /* join condition not captured in parsed metadata */
;