VB_BASIC_SEARCH_CDS_VIEWS

DDL: VB_BASIC_SEARCH_CDS_VIEWS SQL: VBBASICSEARCHCDS Type: view
18 Fields 1 Data Sources

CDS View for Basic Search on columns

VB_BASIC_SEARCH_CDS_VIEWS is a CDS View that provides data about "CDS View for Basic Search on columns" in SAP S/4HANA. It reads from 1 data source (VB_CDS_QUERY_VIEWS) and exposes 18 fields with key field DDLSourceName.

Data Sources (1)

SourceAliasJoin Type
VB_CDS_QUERY_VIEWS Vb_Cdsviews_Query from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBBASICSEARCHCDS 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
AbapCatalog.preserveKey true view
EndUserText.label CDS View for Basic Search on columns view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName VB_CDS_QUERY_VIEWS DDLSourceName DDL Source Name
SQLViewName SQLViewName View Name
DDLSourceNameText DDLSourceNameText
CDSViewPackage VB_CDS_QUERY_VIEWS CDSViewPackage
CDSViewStatus CDSViewStatus
CDSViewStatusCloud CDSViewStatusCloud
CDSViewCategory VB_CDS_QUERY_VIEWS CDSViewCategory
CdsViewType VB_CDS_QUERY_VIEWS CdsViewType
ApplicationComponentName ApplicationComponentName
CDSOriginKey VB_CDS_QUERY_VIEWS CDSOriginKey
CDSOrigin VB_CDS_QUERY_VIEWS CDSOrigin
DDLSourceText VB_CDS_QUERY_VIEWS DDLSourceText
DefaultText VB_CDS_QUERY_VIEWS DefaultText
DDLSourceTextSearch
DefaultTextSearch
DDLSourceIsFavorite VB_CDS_QUERY_VIEWS DDLSourceIsFavorite
CDSViewSourceSystem VB_CDS_QUERY_VIEWS CDSViewSourceSystem
SourceType SourceType 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 VB_BASIC_SEARCH_CDS_VIEWS.
-- 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: VBBASICSEARCHCDS

CREATE VIEW VB_BASIC_SEARCH_CDS_VIEWS AS
SELECT
  Vb_Cdsviews_Query.DDLSourceName AS DDLSourceName,
  SQLViewName,
  DDLSourceNameText,
  Vb_Cdsviews_Query.CDSViewPackage AS CDSViewPackage,
  CDSViewStatus,
  CDSViewStatusCloud,
  Vb_Cdsviews_Query.CDSViewCategory AS CDSViewCategory,
  Vb_Cdsviews_Query.CdsViewType AS CdsViewType,
  ApplicationComponentName,
  Vb_Cdsviews_Query.CDSOriginKey AS CDSOriginKey,
  Vb_Cdsviews_Query.CDSOrigin AS CDSOrigin,
  Vb_Cdsviews_Query.DDLSourceText AS DDLSourceText,
  Vb_Cdsviews_Query.DefaultText AS DefaultText,
  upper(Vb_Cdsviews_Query.DDLSourceText) AS DDLSourceTextSearch,
  upper(Vb_Cdsviews_Query.DefaultText) AS DefaultTextSearch,
  Vb_Cdsviews_Query.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  Vb_Cdsviews_Query.CDSViewSourceSystem AS CDSViewSourceSystem,
  SourceType
FROM VB_CDS_QUERY_VIEWS AS Vb_Cdsviews_Query
;

Learn More