Vb_Cdsviews_Query

DDL: VB_CDSVIEWS_QUERY SQL: VBCDSVIEWSQUERY Type: view Package: S_DICT_VB
33 Fields 2 Data Sources

View Browser CDS Views

Vb_Cdsviews_Query is a CDS View that provides data about "View Browser CDS Views" in SAP S/4HANA. It reads from 2 data sources (Vb_Core_Cdsviews, ddddlsrct) and exposes 33 fields with key field DDLSourceName. Part of development package S_DICT_VB.

Data Sources (2)

SourceAliasJoin Type
Vb_Core_Cdsviews Core_CDSViews from
ddddlsrct DDDescriptionTable left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VBCDSVIEWSQUERY 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 (33)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName DDLSourceName DDL Source Name
DDLSourceNameText DDLSourceNameText
SQLViewName SQLViewName View Name
CDSViewPackage Vb_Core_Cdsviews CDSViewPackage
CDSReleaseStatus CDSReleaseStatus
CDSPrivate CDSPrivate
CDSType CDSType
CDSName Vb_Core_Cdsviews CDSName
CDSViewCategory Vb_Core_Cdsviews CDSViewCategory
CdsViewType Vb_Core_Cdsviews CdsViewType
ApplicationComponentName Vb_Core_Cdsviews ApplicationComponentName
CDSOriginKey Vb_Core_Cdsviews CDSOriginKey
DeprecatedStatus Vb_Core_Cdsviews DeprecatedStatus
AppID
WDAppID
CDSOrigin
DDLSourceTextendasDDLSourceText
DDLSourceTextendasDDLSourceTextSearch
NumberOfAddedTags
PrimaryTag
SupportedCapability SupportedCapability
NumberOfCapabilities NumberOfCapabilities
ModelingPattern ModelingPattern
_CdsViewUserTag Vb_Core_Cdsviews _CdsViewUserTag
_CdsDefinition Vb_Core_Cdsviews _CdsDefinition
_CdsViewCrossreference Vb_Core_Cdsviews _CdsViewCrossreference
_CdsViewAnnotation Vb_Core_Cdsviews _CdsViewAnnotation
CDSViewSourceSystem Vb_Core_Cdsviews CDSViewSourceSystem
_CdsSupportedCapabilities Vb_Core_Cdsviews _CdsSupportedCapabilities
IsDraft
IsPublished
DraftDDLSourceName
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_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: VBCDSVIEWSQUERY

CREATE VIEW Vb_Cdsviews_Query AS
SELECT
  DDLSourceName,
  DDLSourceNameText,
  SQLViewName,
  Core_CDSViews.CDSViewPackage AS CDSViewPackage,
  CDSReleaseStatus,
  CDSPrivate,
  CDSType,
  Core_CDSViews.CDSName AS CDSName,
  Core_CDSViews.CDSViewCategory AS CDSViewCategory,
  Core_CDSViews.CdsViewType AS CdsViewType,
  Core_CDSViews.ApplicationComponentName AS ApplicationComponentName,
  Core_CDSViews.CDSOriginKey AS CDSOriginKey,
  Core_CDSViews.DeprecatedStatus AS DeprecatedStatus,
  _AnalyticalQueryPublished[app_type = 0].app_id AS AppID,
  _AnalyticalQueryPublished[app_type = 1].app_id AS WDAppID,
  Core_CDSViews._EditorText[Language = $session.system_language].ddtext AS CDSOrigin,
  case when Core_CDSViews._Text[Language = $session.system_language].DDLSourceText = '' or Core_CDSViews._Text[Language = $session.system_language].DDLSourceText is null then DDDescriptionTable.ddtext else Core_CDSViews._Text[Language = $session.system_language].DDLSourceText end as DDLSourceText AS DDLSourceTextendasDDLSourceText,
  case when Core_CDSViews._Text[Language = $session.system_language].DDLSourceText = '' or Core_CDSViews._Text[Language = $session.system_language].DDLSourceText is null then upper(DDDescriptionTable.ddtext) else upper(Core_CDSViews._Text[Language = $session.system_language].DDLSourceText) end as DDLSourceTextSearch AS DDLSourceTextendasDDLSourceTextSearch,
  Core_CDSViews._CdsTagCount.NumberOfAddedTags AS NumberOfAddedTags,
  Core_CDSViews._CdsTagCount.PrimaryTag AS PrimaryTag,
  SupportedCapability,
  NumberOfCapabilities,
  ModelingPattern,
  Core_CDSViews._CdsViewUserTag AS _CdsViewUserTag,
  Core_CDSViews._CdsDefinition AS _CdsDefinition,
  Core_CDSViews._CdsViewCrossreference AS _CdsViewCrossreference,
  Core_CDSViews._CdsViewAnnotation AS _CdsViewAnnotation,
  Core_CDSViews.CDSViewSourceSystem AS CDSViewSourceSystem,
  Core_CDSViews._CdsSupportedCapabilities AS _CdsSupportedCapabilities,
  '' AS IsDraft,
  '' AS IsPublished,
  '' AS DraftDDLSourceName,
  SourceType
FROM Vb_Core_Cdsviews AS Core_CDSViews
LEFT OUTER JOIN ddddlsrct AS DDDescriptionTable ON /* join condition not captured in parsed metadata */
;

Learn More