I_OMEQ_SNDREQ

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 I_OMEQ_SNDREQ.
-- 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: OMEQV_I_SNDREQ

CREATE VIEW I_OMEQ_SNDREQ AS
SELECT
  concat( soes.recyr, soes.recno ) AS ID,
  cast( dats_tims_to_tstmp( soes.snddat, soes.sndtim, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as timestamp ) as SendDate AS clientNULLastimestampasSendDate,
  case when bcst_sr.subject is not initial then bcst_sr.subject else sood.objdes end as Subject AS objdesendasSubject,
  cast( ' ' as so_adrnam ) AS Sender,
  cast( ' ' as so_adrnam ) AS Recipient,
  cast( case when soes.status = 'W' then 'W' when soes.status = '751' then 'W' when ( soes.status like '6__' ) then 'E' when ( soes.status like '8__' ) then 'E' when ( soes.status like '71_' ) then 'S' when ( soes.status like '72_' ) then 'S' when ( soes.status like '73_' ) then 'S' when ( soes.status like '74_' ) then 'S' when ( soes.status like '70_' ) then 'S' when soes.status = '73' then 'S' else 'E' end as abap.char(1) ) as StatusUI AS char1asStatusUI,
  case when soes.status = 'W' then 2 when soes.status = '751' then 2 when ( soes.status like '6__' ) then 1 when ( soes.status like '8__' ) then 1 when ( soes.status like '71_' ) then 3 when ( soes.status like '72_' ) then 3 when ( soes.status like '73_' ) then 3 when ( soes.status like '74_' ) then 3 when ( soes.status like '70_' ) then 3 when soes.status = '73' then 3 else 1 end as StatusCriticality AS status73then3else1endasStatusCriticality,
  cast( ' ' as abap.char( 1024 ) ) AS StatusDescr,
  cast( ' ' as so_text255 ) AS StatusInfo,
  soes.rectp AS rectp,
  soes.recyr AS recyr,
  soes.recno AS recno,
  soes.snddat AS stat_date,
  soes.sndtim AS stat_time,
  soes.sndart AS sndart,
  soes.adrnr AS adrnr,
  soes.status AS status,
  soes.scomtp AS scomtp,
  soes.scomyr AS scomyr,
  soes.scomno AS scomno,
  soes.msgty AS msgty,
  soes.msgid AS msgid,
  soes.msgv1 AS msgv1,
  soes.msgv2 AS msgv2,
  soes.msgv3 AS msgv3,
  soes.msgv4 AS msgv4,
  soes.node AS node,
  sood.objsns AS objsns,
  sood.objlen AS objlen,
  sood.attlen AS attlen,
  soos.sndtp AS sndtp,
  soos.sndyr AS sndyr,
  soos.sndno AS sndno,
  soos.sndreq AS sndreq,
  sosc.msgtp AS msgtp,
  sosc.wait_date AS wait_date,
  sosc.wait_time AS wait_time,
  cast( ' ' as so_snd_nam ) AS usernam,
  cast( ' ' as symsgno ) AS msgno,
  cast( ' ' as so_sta_cnt ) AS counter,
  cast( ' ' as symsgid ) AS sost_msgid,
  cast( ' ' as symsgv ) AS sost_msgv1,
  cast( ' ' as so_obj_len ) AS length,
  cast( ' ' as so_text255 ) AS msgtxt,
  cast( ' ' as os_boolean ) AS def_stat,
  cast( ' ' as os_boolean ) AS mark,
  cast( ' ' as so_text050 ) AS sndart_l,
  cast( ' ' as icon_text ) AS icon,
  cast( ' ' as char4 ) AS color
FROM soos
INNER JOIN soes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sosc ON /* join condition not captured in parsed metadata */
INNER JOIN sood ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bcst_sr ON /* join condition not captured in parsed metadata */
;