aps_com_cs_read_cs_outbnd

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_com_cs_read_cs_outbnd.
-- 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_com_cs_read_cs_outbnd AS
SELECT
  cs.commsyst AS CommunicationSystemID,
  cs_outb.db_key AS OutboundUUID,
  case when cs_outb.systemauthenticationmode = '4' then '' when cs_outb.systemauthenticationmode = '8' then '' when cs_outb.systemauthenticationmode = '41' then '' when cs_outb.systemauthenticationmode = '42' then '' when cs_outb.systemauthenticationmode = '43' then '' when cs_outb.systemauthenticationmode = '44' then '' else cs_outb.commsystoutboundusername end as UserName AS commsystoutboundusernameendasUserName,
  cs_outb.certificatetext AS CertificateID,
  _Auth.AuthMethod AS AuthMethod
FROM aps_cs_d_outbnd AS cs_outb
LEFT OUTER JOIN aps_com_cs_read_auth AS _Auth ON cs_outb.systemauthenticationmode = _Auth.AuthMethodCode  -- association [0..1]
;