VB_CDS_SEARCH_QUERY_VIEWS

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_CDS_SEARCH_QUERY_VIEWS.
-- 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: VBSEARCHVIEW

CREATE VIEW VB_CDS_SEARCH_QUERY_VIEWS AS
SELECT
  Vb_Cdsviews_Query.DDLSourceName AS DDLSourceName,
  Vb_Cdsviews_Query._CdsDefinition[inner].FieldName AS Value,
  2 AS Type,
  cast(Vb_Cdsviews_Query._CdsDefinition[inner].fieldname_raw as abap.char(40)) AS Fieldnametext,
  Vb_Cdsviews_Query.CDSName AS CDSName,
  Vb_Cdsviews_Query.SQLViewName AS SQLViewName,
  Vb_Cdsviews_Query.DDLSourceNameText AS DDLSourceNameText,
  Vb_Cdsviews_Query.DefaultText AS DefaultText,
  Vb_Cdsviews_Query.DDLSourceText AS DDLSourceText,
  Vb_Cdsviews_Query.CDSViewPackage AS CDSViewPackage,
  Vb_Cdsviews_Query.CDSViewCategory AS CDSViewCategory,
  Vb_Cdsviews_Query.CdsViewType AS CdsViewType,
  Vb_Cdsviews_Query.ApplicationComponentName AS ApplicationComponentName,
  Vb_Cdsviews_Query.CDSOriginKey AS CDSOriginKey,
  Vb_Cdsviews_Query.CDSViewStatus AS CDSViewStatus,
  Vb_Cdsviews_Query.CDSViewStatusCloud AS CDSViewStatusCloud,
  Vb_Cdsviews_Query.CDSOrigin AS CDSOrigin,
  Vb_Cdsviews_Query.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  Vb_Cdsviews_Query.CDSViewSourceSystem AS CDSViewSourceSystem,
  Vb_Cdsviews_Query.SourceType AS SourceType
;