Rsl_Util_Lqry_List

DDL: RSL_UTIL_LQRY_LIST SQL: RSL_UTIL_QRY Type: view Package: RSL_UTILITIES
4 Fields 3 Data Sources

List of Workspace Queries

Rsl_Util_Lqry_List is a CDS View that provides data about "List of Workspace Queries" in SAP S/4HANA. It reads from 3 data sources (rsltipbase, rswsplref, rsltipt) and exposes 4 fields with key fields wspname, objname. Part of development package RSL_UTILITIES.

Data Sources (3)

SourceAliasJoin Type
rsltipbase base inner
rswsplref lref from
rsltipt ltipt inner

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName RSL_UTIL_QRY view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY wspname rswsplref wspname Workspace
KEY objname rswsplref objnm Trans.Provider
compid
description rsltipt description Well Code Des.

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 Rsl_Util_Lqry_List.
-- 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: RSL_UTIL_QRY

CREATE VIEW Rsl_Util_Lqry_List AS
SELECT
  lref.wspname AS wspname,
  lref.objnm AS objname,
  concat('3M', lref.objnm) AS compid,
  ltipt.description AS description
FROM rswsplref AS lref
INNER JOIN rsltipbase AS base ON /* join condition not captured in parsed metadata */
INNER JOIN rsltipt AS ltipt ON /* join condition not captured in parsed metadata */
;

Learn More