VB_QUERY_VIEW_DETAILS

DDL: VB_QUERY_VIEW_DETAILS SQL: VBQUERYDETAIL Type: view
23 Fields 1 Data Sources

View Browser CDS Views

VB_QUERY_VIEW_DETAILS is a CDS View that provides data about "View Browser CDS Views" in SAP S/4HANA. It reads from 1 data source (VB_CDS_QUERY_VIEWS) and exposes 23 fields with key field DDLSourceName.

Data Sources (1)

SourceAliasJoin Type
VB_CDS_QUERY_VIEWS Core_CDSViews from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBQUERYDETAIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label View 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 #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName VB_CDS_QUERY_VIEWS DDLSourceName DDL Source Name
CDSName VB_CDS_QUERY_VIEWS CDSName
SQLViewName VB_CDS_QUERY_VIEWS SQLViewName View Name
DDLSourceNameText VB_CDS_QUERY_VIEWS DDLSourceNameText
DefaultText VB_CDS_QUERY_VIEWS DefaultText
DDLSourceText VB_CDS_QUERY_VIEWS DDLSourceText
CDSViewPackage VB_CDS_QUERY_VIEWS CDSViewPackage
CDSViewCategory VB_CDS_QUERY_VIEWS CDSViewCategory
CdsViewType VB_CDS_QUERY_VIEWS CdsViewType
ApplicationComponentName VB_CDS_QUERY_VIEWS ApplicationComponentName
CDSOriginKey VB_CDS_QUERY_VIEWS CDSOriginKey
CDSViewStatus VB_CDS_QUERY_VIEWS CDSViewStatus
CDSOrigin VB_CDS_QUERY_VIEWS CDSOrigin
DDLSourceIsFavorite VB_CDS_QUERY_VIEWS DDLSourceIsFavorite
NumberOfAddedTags _CdsTagCount NumberOfAddedTags
PrimaryTag _CdsTagCount PrimaryTag
SupportedCapability SupportCapabilities SupportedCapability
NumberOfCapabilities SupportCapabilities NumberOfCapabilities
ModelingPattern CDSModelingPattern AnnotationValue
SourceType SourceType Source Type
CDSViewSourceSystem VB_CDS_QUERY_VIEWS CDSViewSourceSystem
_CdsViewUserTag VB_CDS_QUERY_VIEWS _CdsViewUserTag
_CdsSupportedCapabilities VB_CDS_QUERY_VIEWS _CdsSupportedCapabilities

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_QUERY_VIEW_DETAILS.
-- 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: VBQUERYDETAIL

CREATE VIEW VB_QUERY_VIEW_DETAILS AS
SELECT
  Core_CDSViews.DDLSourceName AS DDLSourceName,
  Core_CDSViews.CDSName AS CDSName,
  Core_CDSViews.SQLViewName AS SQLViewName,
  Core_CDSViews.DDLSourceNameText AS DDLSourceNameText,
  Core_CDSViews.DefaultText AS DefaultText,
  Core_CDSViews.DDLSourceText AS DDLSourceText,
  Core_CDSViews.CDSViewPackage AS CDSViewPackage,
  Core_CDSViews.CDSViewCategory AS CDSViewCategory,
  Core_CDSViews.CdsViewType AS CdsViewType,
  Core_CDSViews.ApplicationComponentName AS ApplicationComponentName,
  Core_CDSViews.CDSOriginKey AS CDSOriginKey,
  Core_CDSViews.CDSViewStatus AS CDSViewStatus,
  Core_CDSViews.CDSOrigin AS CDSOrigin,
  Core_CDSViews.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  _CdsTagCount.NumberOfAddedTags AS NumberOfAddedTags,
  _CdsTagCount.PrimaryTag AS PrimaryTag,
  SupportCapabilities.SupportedCapability AS SupportedCapability,
  SupportCapabilities.NumberOfCapabilities AS NumberOfCapabilities,
  CDSModelingPattern.AnnotationValue AS ModelingPattern,
  SourceType,
  Core_CDSViews.CDSViewSourceSystem AS CDSViewSourceSystem,
  Core_CDSViews._CdsViewUserTag AS _CdsViewUserTag,
  Core_CDSViews._CdsSupportedCapabilities AS _CdsSupportedCapabilities
FROM VB_CDS_QUERY_VIEWS AS Core_CDSViews
;

Learn More