RSRTS_QF4_QueryProvider_All

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_All.
-- 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_All AS
SELECT
  _query_list.queryCDSName AS queryCDSName,
  _query_list.compid AS compid,
  _query_list.queryDDLName AS queryDDLname,
  ars_api_released.state AS queryState,
  _query_list.queryDevClass AS queryDevClass,
  _query_list.withProvContractAnalyticalQry AS withProvContractAnalyticalQry,
  _text1.ddtext AS queryDescription,
  cast( concat( '2C', _cube_odp.odpName ) as rsinfoprov ) AS infoprovider,
  _cube_odp.ddlName AS cubeDDLname,
  _query_list.cubeCDSname AS cubeCDSname,
  _cube_odp.devClass AS cubeDevclass,
  akh.app_component AS akhAppComponent,
  _query_list.cubeDataCategory AS cubeDataCategory
FROM RSRTS_QF4_QueryProviderBasic AS _query_list
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS ars_api_released ON /* join condition not captured in parsed metadata */
INNER JOIN RSODP_ABAP_CDS_ODPNAME AS _cube_odp ON /* join condition not captured in parsed metadata */
INNER JOIN RSRTS_APP_COMPONENT AS akh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc02bt AS _text1 ON /* join condition not captured in parsed metadata */
;