APS_COM_CS_A4C_ODATA_RT

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_A4C_ODATA_RT.
-- 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_A4C_ODATA_RT AS
SELECT
  cs.db_key AS uuid,
  cs.commsyst AS id,
  cs.commsystname AS name,
  cs.commsystdescription AS description,
  cs.commsystsapclient AS sap_client,
  cs.commsysthostname AS hostname,
  cs.commsystuihostname AS hostname_ui,
  cs.fastserializer AS is_RFC_fast_serializ_active,
  cs.creationdatetime AS created_at,
  cs.createdbyuser AS created_by,
  cs.lastchangedatetime AS changed_at,
  cs.lastchangedbyuser AS changed_by,
  InboundUsers,
  OutboundUsers,
  BusinessPartners,
  EventChannel,
  OpenIDConnect
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_COM_CS_A4C_ODATA_IB_USER AS InboundUsers ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_A4C_ODATA_OB_USER AS OutboundUsers ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_A4C_ODATA_BP AS BusinessPartners ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_A4C_ODATA_EVENT AS EventChannel ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN APS_COM_CS_A4C_ODATA_OIDC AS OpenIDConnect ON /* condition not available in parsed metadata */  -- association [0..*]
;