uconhttpattr_v

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 uconhttpattr_v.
-- 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: UCONHTTP_ATTR
-- Parameters: lang : abap.lang

CREATE VIEW uconhttpattr_v AS
SELECT
  called_sid,
  caller_sid,
  alias_kind,
  ucon_phase,
  status_code,
  user_agent,
  cast( substring( tstmp_first_call, 1, 8 ) as abap.dats ) AS FirstCallD,
  cast( substring( tstmp_first_call, 9, 6 ) as abap.tims ) AS FirstCallT,
  cast( substring( tstmp_previous_call, 1, 8 ) as abap.dats ) AS PrevCallD,
  cast( substring( tstmp_previous_call , 9, 6 ) as abap.tims ) AS PrevCallT,
  cast( substring( tstmp_last_call , 1, 8 ) as abap.dats ) AS LastCallD,
  cast( substring( tstmp_last_call, 9, 6 ) as abap.tims ) AS LastCallT,
  extreq,
  clientkind,
  aliaskind,
  http_phase
FROM uconhttplogging
LEFT OUTER JOIN uconhttp_clnt_kind_v AS clientkind ON non_abap_http_client = clientkind.ClientKind  -- association [0..1]
LEFT OUTER JOIN uconhttp_alias_v AS aliaskind ON alias_kind = aliaskind.Aliaskind  -- association [0..1]
LEFT OUTER JOIN uconhttpphase_v AS http_phase ON ucon_phase = http_phase.Phase  -- association [0..1]
LEFT OUTER JOIN uconhttpextreq_v AS extreq ON external_call = extreq.ExtReq  -- association [0..1]
LEFT OUTER JOIN uconhttprej_v AS httpreject ON rejected_http_call = httpreject.HTTPreject  -- association [0..1]
;