QB_CDSVIEWS_FINAL_QUERY

CDS View
18 Fields 7 CDS Views

Query Browser CDS Views

QB_CDSVIEWS_FINAL_QUERY is a CDS View in S/4HANA. Query Browser CDS Views. It contains 18 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
CDS_VIEW_SEARCH_PUBLISHED_CE view from Search for tags,tables on published view
QB_CDS_VIEW_SEARCH view from CDS View Search on Tags,Columns,Tables
QB_CDS_VIEW_SEARCH view union_all CDS View Search on Tags,Columns,Tables
Qb_Cdsviews_Query view from Query Browser CDS Views
Qb_Cdsviews_Query_Ce_Published view from Query Browser Published views
Qb_Count_Published_Query_CE view from Query Browser Published views count
QB_Search_views_with_anno view from Search for views and annotations

Fields (18)

KeyField CDS FieldsUsed in Views
KEY DDLSourceName DDLSourceName 6
_CdsDefinition _CdsDefinition 1
_CdsViewCrossreference _CdsViewCrossreference 1
ApplicationComponentName ApplicationComponentName 6
ApplicationComponentText ApplicationComponentText 4
CDSName CDSName 4
DDLSourceIsFavorite DDLSourceIsFavorite 6
DDLSourceNameText DDLSourceNameText 6
DDLSourceText DDLSourceText 5
DDLSourceTextFallback DDLSourceTextFallback 5
DDLSourceTextSearch DDLSourceTextSearch 5
DDLSourceTextSearchfb DDLSourceTextSearchfb 4
InAServiceName InAServiceName 6
ReferredObjectDDLSourceName ReferredObjectDDLSourceName 6
source_type CDSViewType 3
SQLAnalyticalQuery SQLAnalyticalQuery 6
SQLAnalyticalView SQLAnalyticalView 6
SQLViewName SQLViewName 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Query Browser CDS Views
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QB_CDSVIEWS_FINAL_QUERY (
    DDLSOURCENAME,
    _CDSDEFINITION,
    _CDSVIEWCROSSREFERENCE,
    APPLICATIONCOMPONENTNAME,
    APPLICATIONCOMPONENTTEXT,
    CDSNAME,
    DDLSOURCEISFAVORITE,
    DDLSOURCENAMETEXT,
    DDLSOURCETEXT,
    DDLSOURCETEXTFALLBACK,
    DDLSOURCETEXTSEARCH,
    DDLSOURCETEXTSEARCHFB,
    INASERVICENAME,
    REFERREDOBJECTDDLSOURCENAME,
    SOURCE_TYPE,
    SQLANALYTICALQUERY,
    SQLANALYTICALVIEW,
    SQLVIEWNAME,
    PRIMARY KEY (DDLSOURCENAME)
);

Learn More