Vb_Cdsviews_Def_Query_Ext

DDL: VB_CDSVIEWS_DEF_QUERY_EXT SQL: VBCDSDEFQRYEXT Type: view
11 Fields 2 Data Sources

View Browser CDS Views Field Definition

Vb_Cdsviews_Def_Query_Ext is a CDS View that provides data about "View Browser CDS Views Field Definition" in SAP S/4HANA. It reads from 2 data sources (Cds_Views_Extn, Vb_Core_Cds_Definition_Ext) and exposes 11 fields with key fields DDLSourceName, FieldName.

Data Sources (2)

SourceAliasJoin Type
Cds_Views_Extn Cds_Views_Extn from
Vb_Core_Cds_Definition_Ext CdsDefinition inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VBCDSDEFQRYEXT view
EndUserText.label View Browser CDS Views Field Definition view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DDLSourceName Cds_Views_Extn DDLSourceName DDL Source Name
KEY FieldName Vb_Core_Cds_Definition_Ext FieldName UI Group FieldName
FieldNameText Vb_Core_Cds_Definition_Ext fieldname_raw Property Name
CDSName Cds_Views_Extn CDSName
DataElement Vb_Core_Cds_Definition_Ext DataElement Data Element
DataType Vb_Core_Cds_Definition_Ext DataType Field Type
FieldPosition Vb_Core_Cds_Definition_Ext FieldPosition
Length Vb_Core_Cds_Definition_Ext Length Text Length
DataElementText
DataElementText_Medium
_CdsFieldAnnotation _CdsFieldAnnotation

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_Def_Query_Ext.
-- 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: VBCDSDEFQRYEXT

CREATE VIEW Vb_Cdsviews_Def_Query_Ext AS
SELECT
  Cds_Views_Extn.DDLSourceName AS DDLSourceName,
  CdsDefinition.FieldName AS FieldName,
  CdsDefinition.fieldname_raw AS FieldNameText,
  Cds_Views_Extn.CDSName AS CDSName,
  CdsDefinition.DataElement AS DataElement,
  CdsDefinition.DataType AS DataType,
  CdsDefinition.FieldPosition AS FieldPosition,
  CdsDefinition.Length AS Length,
  CdsDefinition._Text[Language = $session.system_language].DataElementText AS DataElementText,
  CdsDefinition._Text[Language = $session.system_language].DataElementText_Medium AS DataElementText_Medium
FROM Cds_Views_Extn
INNER JOIN Vb_Core_Cds_Definition_Ext AS CdsDefinition ON /* join condition not captured in parsed metadata */
;

Learn More