APS_SEC_TRUSTED_CDOC_GEN

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

CREATE VIEW APS_SEC_TRUSTED_CDOC_GEN AS
SELECT
  cdoc.entry_type AS UseCase,
  cdoc.sort_key AS SortKey,
  cdoc.action AS Action,
  cdoc.host AS Host,
  cdoc.scheme AS Scheme,
  cdoc.port AS Port,
  cdoc.namespace AS Type,
  cdoc.username AS ChangedBy,
  cdoc.time AS ChangedAt,
  case UseCase when '01' then _Text_NetworkZones.text when '02' then _Text_Click.text when '03' then _Text_CSS.text else '' end as UseCaseText AS textelseendasUseCaseText,
  case Action when 'A' then _Text_Created.text when 'D' then _Text_Deleted.text else '' end as ActionText AS textelseendasActionText,
  case Scheme when '1' then _Text_HTTP.text when '2' then _Text_HTTPS.text when '*' then _Text_HTTP_HTTPS.text else '' end as SchemeText AS textelseendasSchemeText,
  case Type when 'C' then _Text_Mngt_Cust.text else '' end as TypeText AS textelseendasTypeText,
  _user.UserDescription AS ChangedByName
FROM http_chw_log_mw AS cdoc
LEFT OUTER JOIN t100 AS _Text_HTTP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_HTTPS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_HTTP_HTTPS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Mngt_Cust ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Created ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Deleted ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_Click ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_NetworkZones ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t100 AS _Text_CSS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_user_ddl AS _user ON cdoc.username = _user.UserID  -- association [0..1]
;