/SAM4U/BTL_L_CLOUD_CONNECTION

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 /SAM4U/BTL_L_CLOUD_CONNECTION.
-- 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.
-- SQL view name: /SAM4U/BTLQCCON

CREATE VIEW /SAM4U/BTL_L_CLOUD_CONNECTION AS
SELECT
  Connection.destinationrfc AS DestinationRFC,
  Rfc.rfctype AS RFCType,
  Rfc.rfcoptions AS Host,
  Connection.description AS ConnectionDescription,
  Connection.statusid AS StatusId,
  Connection.createdat AS CreatedAt,
  Connection.createdby AS CreatedBy,
  Connection.changedat AS ChangedAt,
  Connection.changedby AS ChangedBy,
  Status.StatusText AS StatusText,
  Connection.is_archived AS IsArchived,
  Connection.is_deleted AS IsDeleted,
  Connection.is_favorite AS IsFavorite,
  count( distinct Destination.destinationcloud ) AS ActiveDestinations
FROM /sam4u/btl_cccon AS Connection
LEFT OUTER JOIN /SAM4U/BTL_L_STATUS_TEXT AS Status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN rfcdes AS Rfc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /sam4u/btl_cdest AS Destination ON /* join condition not captured in parsed metadata */
;