QB_CDS_VIEW_SEARCH

DDL: QB_CDS_VIEW_SEARCH SQL: QBCDSVIEWSEARCH Type: view

CDS View Search on Tags,Columns,Tables

QB_CDS_VIEW_SEARCH is a CDS View that provides data about "CDS View Search on Tags,Columns,Tables" in SAP S/4HANA. It reads from 4 data sources (QB_CDSVIEWS_FINAL_QUERY, QB_CDSVIEWS_FINAL_QUERY, QB_CDSVIEWS_FINAL_QUERY, vdm_browsertag) and exposes 43 fields with key fields DDLSourceName, Value, Type, MatchedInValue, Value.

Data Sources (4)

SourceAliasJoin Type
QB_CDSVIEWS_FINAL_QUERY Cds_View from
QB_CDSVIEWS_FINAL_QUERY Cds_View union_all
QB_CDSVIEWS_FINAL_QUERY Cds_View union_all
vdm_browsertag vdm_browsertag inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName QBCDSVIEWSEARCH view
EndUserText.label CDS View Search on Tags,Columns,Tables view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName QB_CDSVIEWS_FINAL_QUERY DDLSourceName DDL Source Name
KEY Value vdm_browsertag browsertagnameupper Browser Tag Upper
KEY Type 1
KEY MatchedInValue vdm_browsertag browsertagname Browser Tag Name
SQLAnalyticalView QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalView
SQLAnalyticalQuery QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalQuery
SQLViewName QB_CDSVIEWS_FINAL_QUERY SQLViewName View Name
DDlSourceNameText QB_CDSVIEWS_FINAL_QUERY DDLSourceNameText
ReferredObjectDDLSourceName QB_CDSVIEWS_FINAL_QUERY ReferredObjectDDLSourceName DDL Source Name
ApplicationComponentName QB_CDSVIEWS_FINAL_QUERY ApplicationComponentName
DDLSourceText QB_CDSVIEWS_FINAL_QUERY DDLSourceText
DDLSourceTextSearchfb QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearchfb
DDLSourceTextSearch QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearch
DDLSourceTextFallback QB_CDSVIEWS_FINAL_QUERY DDLSourceTextFallback Short text
DDLSourceName DDL Source Name
KEY Value Browser Tag Upper
KEY Type 2
MatchedInValue Browser Tag Name
SQLAnalyticalView QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalView
SQLAnalyticalQuery QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalQuery
SQLViewName QB_CDSVIEWS_FINAL_QUERY SQLViewName View Name
DDLSourceNameText QB_CDSVIEWS_FINAL_QUERY DDLSourceNameText
ReferredObjectDDLSourceName QB_CDSVIEWS_FINAL_QUERY ReferredObjectDDLSourceName DDL Source Name
ApplicationComponentName QB_CDSVIEWS_FINAL_QUERY ApplicationComponentName
DDLSourceText QB_CDSVIEWS_FINAL_QUERY DDLSourceText
DDLSourceTextSearchfb QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearchfb
DDLSourceTextSearch QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearch
DDLSourceTextFallback QB_CDSVIEWS_FINAL_QUERY DDLSourceTextFallback Short text
DDLSourceName DDL Source Name
KEY Value Browser Tag Upper
KEY Type 3
MatchedInValue Browser Tag Name
SQLAnalyticalView QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalView
SQLAnalyticalQuery QB_CDSVIEWS_FINAL_QUERY SQLAnalyticalQuery
SQLViewName QB_CDSVIEWS_FINAL_QUERY SQLViewName View Name
DDLSourceNameText QB_CDSVIEWS_FINAL_QUERY DDLSourceNameText
ReferredObjectDDLSourceName QB_CDSVIEWS_FINAL_QUERY ReferredObjectDDLSourceName DDL Source Name
ApplicationComponentName QB_CDSVIEWS_FINAL_QUERY ApplicationComponentName
DDLSourceText QB_CDSVIEWS_FINAL_QUERY DDLSourceText
DDLSourceTextSearchfb QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearchfb
DDLSourceTextSearch QB_CDSVIEWS_FINAL_QUERY DDLSourceTextSearch
DDLSourceTextFallback QB_CDSVIEWS_FINAL_QUERY DDLSourceTextFallback Short text
DDLSourceIsFavorite QB_CDSVIEWS_FINAL_QUERY DDLSourceIsFavorite

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_CDS_VIEW_SEARCH.
-- 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: QBCDSVIEWSEARCH

CREATE VIEW QB_CDS_VIEW_SEARCH AS
SELECT
  Cds_View.DDLSourceName AS DDLSourceName,
  vdm_browsertag.browsertagnameupper AS Value,
  1 AS Type,
  vdm_browsertag.browsertagname AS MatchedInValue,
  Cds_View.SQLAnalyticalView AS SQLAnalyticalView,
  Cds_View.SQLAnalyticalQuery AS SQLAnalyticalQuery,
  Cds_View.SQLViewName AS SQLViewName,
  Cds_View.DDLSourceNameText AS DDlSourceNameText,
  Cds_View.ReferredObjectDDLSourceName AS ReferredObjectDDLSourceName,
  Cds_View.ApplicationComponentName AS ApplicationComponentName,
  Cds_View.DDLSourceText AS DDLSourceText,
  Cds_View.DDLSourceTextSearchfb AS DDLSourceTextSearchfb,
  Cds_View.DDLSourceTextSearch AS DDLSourceTextSearch,
  Cds_View.DDLSourceTextFallback AS DDLSourceTextFallback,
  Cds_View.DDLSourceIsFavorite AS DDLSourceIsFavorite
FROM QB_CDSVIEWS_FINAL_QUERY AS Cds_View
INNER JOIN vdm_browsertag ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): QB_CDSVIEWS_FINAL_QUERY
;