aps_com_ca_read_ca_inbnd

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_ca_read_ca_inbnd.
-- 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_ca_read_ca_inbnd AS
SELECT
  ca.db_key AS CommunicationArrangementUUID,
  cs_inb.commsystinboundusername AS UserID,
  _ChangeUser.UserName AS UserName,
  cs_inb.oauth2clientid AS OAuth2ClientID,
  _GrantType.GrantType AS OAuth2GrantType,
  _Auth.AuthMethod AS AuthMethod
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]
LEFT OUTER JOIN aps_iam_customeruser_ddl AS _ChangeUser ON cs_inb.commsystinboundusername = _ChangeUser.UserID  -- association [0..1]
LEFT OUTER JOIN aps_com_cs_read_auth AS _Auth ON cs_inb.systemauthenticationmode = _Auth.AuthMethodCode  -- association [0..1]
LEFT OUTER JOIN aps_com_cs_read_granttype AS _GrantType ON cs_inb.oauth2granttype = _GrantType.GrantTypeCode  -- association [0..1]
;