Qb_Cdsviews_Query

DDL: QB_CDSVIEWS_QUERY SQL: QBCDSVIEWSQUERY Type: view
17 Fields 1 Data Sources

Query Browser CDS Views

Qb_Cdsviews_Query is a CDS View that provides data about "Query Browser CDS Views" in SAP S/4HANA. It reads from 1 data source (QB_CDSVIEWS_FINAL_QUERY) and exposes 17 fields.

Data Sources (1)

SourceAliasJoin Type
QB_CDSVIEWS_FINAL_QUERY Qb_Cdsviews_Query from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName QBCDSVIEWSQUERY view
EndUserText.label Query Browser CDS Views view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view

Fields (17)

KeyFieldSource TableSource FieldDescription
DDLSourceName QB_CDSVIEWS_FINAL_QUERY DDLSourceName DDL Source Name
DDLSourceNameText QB_CDSVIEWS_FINAL_QUERY DDLSourceNameText
SQLViewName QB_CDSVIEWS_FINAL_QUERY SQLViewName View Name
CDSName QB_CDSVIEWS_FINAL_QUERY CDSName
CDSReleaseStatus ReleasedViews state Vehicle Region
ApplicationComponentName QB_CDSVIEWS_FINAL_QUERY ApplicationComponentName
ApplicationComponentText QB_CDSVIEWS_FINAL_QUERY ApplicationComponentText
SQLAnalyticalQuery QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalQuery
SQLAnalyticalView QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalView
ReferredObjectDDLSourceName QB_CDSVIEWS_FINAL_QUERY ReferredObjectDDLSourceName DDL Source Name
DDLSourceText QB_CDSVIEWS_FINAL_QUERY DDLSourceText
DDLSourceTextFallback QB_CDSVIEWS_FINAL_QUERY DDLSourceTextFallback Short text
DDLSourceTextSearch QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearch
DDLSourceTextSearchfb QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearchfb
DDLSourceIsFavorite QB_CDSVIEWS_FINAL_QUERY DDLSourceIsFavorite
InAServiceName QB_CDSVIEWS_FINAL_QUERY InAServiceName
CDSViewType QB_CDSVIEWS_FINAL_QUERY source_type SRVC Source Type

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 Qb_Cdsviews_Query.
-- 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: QBCDSVIEWSQUERY

CREATE VIEW Qb_Cdsviews_Query AS
SELECT
  Qb_Cdsviews_Query.DDLSourceName AS DDLSourceName,
  Qb_Cdsviews_Query.DDLSourceNameText AS DDLSourceNameText,
  Qb_Cdsviews_Query.SQLViewName AS SQLViewName,
  Qb_Cdsviews_Query.CDSName AS CDSName,
  ReleasedViews.state AS CDSReleaseStatus,
  Qb_Cdsviews_Query.ApplicationComponentName AS ApplicationComponentName,
  Qb_Cdsviews_Query.ApplicationComponentText AS ApplicationComponentText,
  Qb_Cdsviews_Query.SQLAnalyticalQuery AS SQLAnalyticalQuery,
  Qb_Cdsviews_Query.SQLAnalyticalView AS SQLAnalyticalView,
  Qb_Cdsviews_Query.ReferredObjectDDLSourceName AS ReferredObjectDDLSourceName,
  Qb_Cdsviews_Query.DDLSourceText AS DDLSourceText,
  Qb_Cdsviews_Query.DDLSourceTextFallback AS DDLSourceTextFallback,
  Qb_Cdsviews_Query.DDLSourceTextSearch AS DDLSourceTextSearch,
  Qb_Cdsviews_Query.DDLSourceTextSearchfb AS DDLSourceTextSearchfb,
  Qb_Cdsviews_Query.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  Qb_Cdsviews_Query.InAServiceName AS InAServiceName,
  Qb_Cdsviews_Query.source_type AS CDSViewType
FROM QB_CDSVIEWS_FINAL_QUERY AS Qb_Cdsviews_Query
;

Learn More