aps_com_cs_read_cs

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.
-- 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 AS
SELECT
  cs.commsyst AS CommunicationSystemID,
  cs.commsystname AS CommunicationSystemName,
  cs.commsysthostname AS HostName,
  cs.commsystuihostname AS UIHostName,
  cast( case when cs.commsystport = '' then '0' else cs.commsystport end as int4) as TCPPort AS commsystportendasint4asTCPPort,
  cs.intermediatedoclogicalsystem AS LogicalSystemID,
  cs.businesssystemname AS BusinessSystemID,
  cs.inboundonly AS InboundOnly,
  cs.ishubsystem AS HubSystem,
  cs.commsystsapclient AS SAPClient,
  cs.isloadbalancing AS RFCLoadBalancing,
  cs.sapsystemid AS RFCSAPSystemID,
  cs.sapsystemnumber AS RFCSAPSystemNumber,
  cs.logongroup AS RFCLogonGroup,
  cs.messageservertargethost AS RFCMessageServerTargetHost,
  cs.fastserializer AS is_RFC_fast_serializ_active,
  cs.isownsystem AS OwnSystem,
  _String.string AS SystemCipherSuiteDefault,
  cs.oauth2idpenabled AS OAuth2IdentityProviderActive,
  cs.oauth2idpname AS OAuth2IdentityProviderName,
  cs.oauth2idpuserlogontype AS OAuth2IDPUserLogonType,
  cs.oauth2authendpoint AS OAuth2AuthEndpoint,
  cs.oauth2tokenendpoint AS OAuth2TokenEndpoint,
  cs.oauth2audience AS OAuth2Audience,
  cs.isabapsystem AS SAPCloudConnectorActive,
  cs.scclocationid AS SAPCloudConnectorLocationID,
  cs.samlbapenabled AS SAMLBearerAssertionProvActive,
  cs.samlbapname AS SAMLBearerAssertionProvName,
  cs.samlbapuserlogontype AS SAMLBearerAssProvUserLogonType,
  cs.commsystownrcntctpersnname AS OwnerContactPersonName,
  cs.commsystownrcntctpersnphnmbr AS OwnerContactPersonPhone,
  cs.commsystownrcntctpersnemladdr AS OwnerContactPersonEMail,
  cs.lastchangedatetime AS LastChangedDateTime,
  cs.lastchangedbyuser AS LastChangedByUserID,
  _ChangeUser.UserName AS LastChangedByUserName,
  _ChangeUser.FullName AS LastChangedByUserDescription,
  _ChangeUser.EmailAddress AS LastChangedByEMailAddress,
  _ChangeUser.GlobalUserID AS LastChangedByGlobalUserID,
  InboundUsers,
  OutboundUsers,
  CommunicationArrangements,
  EventChannel,
  OIDCProvider
FROM aps_cs_d_root AS cs
LEFT OUTER JOIN aps_com_l_string AS _String ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_busr_core AS _ChangeUser ON cs.lastchangedbyuser = _ChangeUser.UserID  -- association [0..1]
LEFT OUTER JOIN APS_COM_CS_READ_CS_CDOC AS _ChangeDocs ON cs.commsyst = _ChangeDocs.CommunicationSystemID  -- association [0..*]
LEFT OUTER JOIN aps_com_cs_read_cs_inbnd AS InboundUsers ON cs.commsyst = InboundUsers.CommunicationSystemID  -- association [0..*]
LEFT OUTER JOIN aps_com_cs_read_cs_outbnd AS OutboundUsers ON cs.commsyst = OutboundUsers.CommunicationSystemID  -- association [0..*]
LEFT OUTER JOIN aps_com_cs_read_cs_ca AS CommunicationArrangements ON cs.commsyst = CommunicationArrangements.CommunicationSystemID  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_READ_CS_ECHANNEL AS EventChannel ON cs.commsyst = EventChannel.CommunicationSystemID  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_READ_CS_OIDC AS OIDCProvider ON cs.commsyst = OIDCProvider.CommunicationSystemID  -- association [0..*]
;