VB_FINAL_QUERY_DATAEXT_CE

DDL: VB_FINAL_QUERY_DATAEXT_CE SQL: VBFINALDAEXTCE Type: view
31 Fields 1 Data Sources

Final CDS view

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

Data Sources (1)

SourceAliasJoin Type
VB_CORE_CDS_VIEWS_CE All_view from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName VBFINALDAEXTCE 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 (31)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName VB_CORE_CDS_VIEWS_CE DDLSourceName DDL Source Name
DDLSourceNameText VB_CORE_CDS_VIEWS_CE DDLSourceNameText DD: Original Name of a Struct. Obj. (e.g. Entity, Context)
DefaultText VB_CORE_CDS_VIEWS_CE DefaultText Short text
DDLSourceText VB_CORE_CDS_VIEWS_CE DDLSourceText Short text
SQLViewName VB_CORE_CDS_VIEWS_CE SQLViewName View Name
CDSName VB_CORE_CDS_VIEWS_CE CDSName
CDSOriginKey VB_CORE_CDS_VIEWS_CE CDSOriginKey
CDSOrigin
SourceType VB_CORE_CDS_VIEWS_CE SourceType Source Type
ApplicationComponent VB_CORE_CDS_VIEWS_CE ApplicationComponent
ApplicationComponentName VB_CORE_CDS_VIEWS_CE ApplicationComponentName
CDSViewPackage VB_CORE_CDS_VIEWS_CE CDSViewPackage
CDSViewSourceSystem VB_CORE_CDS_VIEWS_CE CDSViewSourceSystem
CdsViewType VB_CORE_CDS_VIEWS_CE CdsViewType
CDSViewStatus VB_CORE_CDS_VIEWS_CE CDSViewStatus
CDSViewStatusCloud VB_CORE_CDS_VIEWS_CE CDSViewStatusCloud
CDSViewCategoryendasCDSViewCategory
IsDraft VB_CORE_CDS_VIEWS_CE IsDraft
DraftDDLSourceName VB_CORE_CDS_VIEWS_CE DraftDDLSourceName
DDLSourceIsFavorite VB_CORE_CDS_VIEWS_CE DDLSourceIsFavorite
AppID VB_CORE_CDS_VIEWS_CE AppID Transaction code
WDAppID VB_CORE_CDS_VIEWS_CE WDAppID
_AnalyticalQueryPublished VB_CORE_CDS_VIEWS_CE _AnalyticalQueryPublished
_CdsDefinition VB_CORE_CDS_VIEWS_CE _CdsDefinition
_CdsFavorite VB_CORE_CDS_VIEWS_CE _CdsFavorite
_CdsSupportedCapabilities VB_CORE_CDS_VIEWS_CE _CdsSupportedCapabilities
_CdsViewAnnotation VB_CORE_CDS_VIEWS_CE _CdsViewAnnotation
_CdsViewCrossreference VB_CORE_CDS_VIEWS_CE _CdsViewCrossreference
_CdsViewParameter VB_CORE_CDS_VIEWS_CE _CdsViewParameter
_CdsViewUserTag VB_CORE_CDS_VIEWS_CE _CdsViewUserTag
_EditorText VB_CORE_CDS_VIEWS_CE _EditorText

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_FINAL_QUERY_DATAEXT_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: VBFINALDAEXTCE

CREATE VIEW VB_FINAL_QUERY_DATAEXT_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._EditorText.ddtext AS CDSOrigin,
  All_view.SourceType AS SourceType,
  All_view.ApplicationComponent AS ApplicationComponent,
  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.CDSViewStatusCloud AS CDSViewStatusCloud,
  case when All_view.SourceType = 'P' then 'true' else All_view.CDSViewCategory end as CDSViewCategory AS CDSViewCategoryendasCDSViewCategory,
  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._AnalyticalQueryPublished AS _AnalyticalQueryPublished,
  All_view._CdsDefinition AS _CdsDefinition,
  All_view._CdsFavorite AS _CdsFavorite,
  All_view._CdsSupportedCapabilities AS _CdsSupportedCapabilities,
  All_view._CdsViewAnnotation AS _CdsViewAnnotation,
  All_view._CdsViewCrossreference AS _CdsViewCrossreference,
  All_view._CdsViewParameter AS _CdsViewParameter,
  All_view._CdsViewUserTag AS _CdsViewUserTag,
  All_view._EditorText AS _EditorText
FROM VB_CORE_CDS_VIEWS_CE AS All_view
;

Learn More