aps_com_cusr_read_cusr_ca

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_cusr_read_cusr_ca.
-- 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_cusr_read_cusr_ca AS
SELECT
  cs_inb.commsystinboundusername AS UserID,
  ca.db_key AS CommunicationArrangementUUID,
  ca.commarrgmtname AS CommunicationArrangementName,
  cs.commsyst AS CommunicationSystemID,
  ca.communicationscenario AS CommunicationScenarioID
FROM aps_ca_d_root AS ca
INNER JOIN aps_cs_d_root AS cs ON /* join condition not captured in parsed metadata */
INNER JOIN aps_ca_d_dinbnd AS ca_inb ON /* join condition not captured in parsed metadata */
INNER JOIN aps_cs_d_inbound AS cs_inb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_com_w_cscn AS _CommScen ON ca.communicationscenario = _CommScen.communication_scenario_id  -- association [0..1]
;