/LTB/I_MC_ACTIVITY_DETAIL_LIST

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_ACTIVITY_DETAIL_LIST.
-- 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_ACTDL

CREATE VIEW /LTB/I_MC_ACTIVITY_DETAIL_LIST AS
SELECT
  e.proj_uuid AS migproj_uuid,
  pe_proj.name AS migproj_name,
  e.act_uuid AS act_uuid,
  c.migobj_uuid AS migobj_uuid,
  coalesce( pe_area.name, mwb_obj.ident ) AS migobj_name,
  coalesce( pe_area.descr, coalesce( mwb_obj_logon.descr, mwb_obj_en.descr ) ) AS migobj_descr,
  c.task_uuid AS task_uuid,
  e.created_at AS started_at,
  e.created_by AS started_by,
  case when usr.UserDescription is null then e.created_by else case ltrim( usr.UserDescription, ' ' ) when '' then e.created_by else usr.UserDescription end end as started_by_name AS UserDescriptionendendasstarted_by_name,
  e1.event_type AS event_type,
  e1.created_at AS finished_at,
  e1.lognr AS appllognr,
  e1.event_data AS event_data,
  e1.event_uuid AS event_uuid,
  coalesce( e1.created_at, e.created_at ) AS event_time,
  evt_rel.event_action AS event_action,
  coalesce( txt_logon.text_history, txt_en.text_history ) AS text_history,
  evt_rel.event_status AS event_status
FROM /LTB/I_MC_ACTIVITY_LIST AS c
INNER JOIN /ltb/mc_eventlog AS e ON /* join condition not captured in parsed metadata */
INNER JOIN /ltb/mc_eventlog AS e1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_proj AS mc_proj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cnv_pe_object AS pe_proj 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 */
LEFT OUTER JOIN dmc_prjctt AS mwb_proj_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_prjctt AS mwb_proj_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CNV_PE_MC_UNION_OBJECT AS pe_area ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cobj AS mwb_obj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cobjt AS mwb_obj_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cobjt AS mwb_obj_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS usr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_evtrel AS evt_rel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_evttypt AS txt_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_evttypt AS txt_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_evtstatt AS stt_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ltb/mc_evtstatt AS stt_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_trobj AS trobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_trobjt AS trobjt_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_trobjt AS trobjt_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_fixedvalue AS fv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_fixedvaluet AS fvt_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_fixedvaluet AS fvt_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cntrlparam AS cp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cntrlparamt AS cpt_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dmc_cntrlparamt AS cpt_logon ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CNV_PE_MC_TASK AS pe_task ON /* join condition not captured in parsed metadata */
;