aps_com_cs_read_cs_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_cs_read_cs_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_cs_read_cs_inbnd AS
SELECT
  cs.commsyst AS CommunicationSystemID,
  cs_inb.db_key AS InboundUUID,
  cs_inb.commsystinboundusername AS UserID,
  _User.UserName AS UserName,
  cs_inb.oauth2clientid AS OAuth2ClientID,
  _GrantType.GrantType AS OAuth2GrantType,
  _Auth.AuthMethod AS AuthMethod
FROM aps_cs_d_inbound AS cs_inb
LEFT OUTER JOIN aps_iam_customeruser_ddl AS _User ON cs_inb.commsystinboundusername = _User.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]
;