VB_VIEW_DETAILS_CE

DDL: VB_VIEW_DETAILS_CE SQL: VBVIEWDETAILSCE Type: view
24 Fields 1 Data Sources

Final CDS view

VB_VIEW_DETAILS_CE is a CDS View that provides data about "Final CDS view" in SAP S/4HANA. It reads from 1 data source (VB_FINAL_QUERY_CE) and exposes 24 fields with key field DDLSourceName.

Data Sources (1)

SourceAliasJoin Type
VB_FINAL_QUERY_CE All_view from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBVIEWDETAILSCE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Final CDS view 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 (24)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName VB_FINAL_QUERY_CE DDLSourceName DDL Source Name
DDLSourceNameText VB_FINAL_QUERY_CE DDLSourceNameText
DefaultText VB_FINAL_QUERY_CE DefaultText
DDLSourceText VB_FINAL_QUERY_CE DDLSourceText
SQLViewName VB_FINAL_QUERY_CE SQLViewName View Name
CDSName VB_FINAL_QUERY_CE CDSName
CDSOriginKey VB_FINAL_QUERY_CE CDSOriginKey
CDSOrigin VB_FINAL_QUERY_CE CDSOrigin
SourceType VB_FINAL_QUERY_CE SourceType Source Type
ApplicationComponentName VB_FINAL_QUERY_CE ApplicationComponentName
CDSViewPackage VB_FINAL_QUERY_CE CDSViewPackage
CDSViewSourceSystem VB_FINAL_QUERY_CE CDSViewSourceSystem
CdsViewType VB_FINAL_QUERY_CE CdsViewType
CDSViewStatus VB_FINAL_QUERY_CE CDSViewStatus
CDSViewCategory VB_FINAL_QUERY_CE CDSViewCategory
NumberOfAddedTags _CdsTagCount NumberOfAddedTags
PrimaryTag _CdsTagCount PrimaryTag
IsDraft VB_FINAL_QUERY_CE IsDraft
DraftDDLSourceName VB_FINAL_QUERY_CE DraftDDLSourceName
DDLSourceIsFavorite VB_FINAL_QUERY_CE DDLSourceIsFavorite
AppID VB_FINAL_QUERY_CE AppID Transaction code
WDAppID VB_FINAL_QUERY_CE WDAppID
_CdsSupportedCapabilities VB_FINAL_QUERY_CE _CdsSupportedCapabilities
_CdsViewUserTag VB_FINAL_QUERY_CE _CdsViewUserTag

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_VIEW_DETAILS_CE.
-- 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: VBVIEWDETAILSCE

CREATE VIEW VB_VIEW_DETAILS_CE AS
SELECT
  All_view.DDLSourceName AS DDLSourceName,
  All_view.DDLSourceNameText AS DDLSourceNameText,
  All_view.DefaultText AS DefaultText,
  All_view.DDLSourceText AS DDLSourceText,
  All_view.SQLViewName AS SQLViewName,
  All_view.CDSName AS CDSName,
  All_view.CDSOriginKey AS CDSOriginKey,
  All_view.CDSOrigin AS CDSOrigin,
  All_view.SourceType AS SourceType,
  All_view.ApplicationComponentName AS ApplicationComponentName,
  All_view.CDSViewPackage AS CDSViewPackage,
  All_view.CDSViewSourceSystem AS CDSViewSourceSystem,
  All_view.CdsViewType AS CdsViewType,
  All_view.CDSViewStatus AS CDSViewStatus,
  All_view.CDSViewCategory AS CDSViewCategory,
  _CdsTagCount.NumberOfAddedTags AS NumberOfAddedTags,
  _CdsTagCount.PrimaryTag AS PrimaryTag,
  All_view.IsDraft AS IsDraft,
  All_view.DraftDDLSourceName AS DraftDDLSourceName,
  All_view.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  All_view.AppID AS AppID,
  All_view.WDAppID AS WDAppID,
  All_view._CdsSupportedCapabilities AS _CdsSupportedCapabilities,
  All_view._CdsViewUserTag AS _CdsViewUserTag
FROM VB_FINAL_QUERY_CE AS All_view
;

Learn More