RSRTS_QF4_QueryProvider

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 RSRTS_QF4_QueryProvider.
-- 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 RSRTS_QF4_QueryProvider AS
SELECT
  _list.queryCDSName AS queryCDSName,
  _list.compid AS compid,
  _list.queryDDLname AS queryDDLName,
  case when _list.queryDescription = '' then _list.queryCDSName when _list.queryDescription is null then _list.queryCDSName else _list.queryDescription end as queryDescription AS queryDescriptionendasqueryDescription,
  _list.cubeCDSname AS cubeCDSName,
  _list.infoprovider AS infoProvider,
  _list.cubeDDLname AS cubeDDLName,
  _list.cubeDataCategory AS cubeDataCategory,
  coalesce( _repdir.infocube , ' ') AS preferredProvider,
  _repdir.lastuser AS lastuser,
  _repdir.modtime AS modtime,
  _repdir.olapeffort AS olapeffort,
  _list.withProvContractAnalyticalQry AS withProvContractAnalyticalQry,
  _list.queryState AS queryState,
  _service.serviceBindingName AS serviceName
FROM RSRTS_QF4_QueryProvider_All AS _list
LEFT OUTER JOIN rsrrepdir AS _repdir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN RSRTS_SRVB_SRVD_CDS_RELEATION AS _service ON /* join condition not captured in parsed metadata */
;