VB_FINAL_QUERY_CE
Final CDS view
VB_FINAL_QUERY_CE is a CDS View in S/4HANA. Final CDS view. It contains 31 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| VB_BASIC_SEARCH_CDS_VIEWS_CE | view | from | Basic Search on columns for cloud | |
| VB_CDSVIEWS_SEARCH_TAG_CE | view | from | View Browser CDS Views Tag Search in CE | |
| VB_QUERY_VIEW_DETAILS_CE | view | from | Final CDS view | |
| VB_VIEW_DETAILS_CE | view | from | Final CDS view |
Fields (31)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DDLSourceName | DDLSourceName | 4 |
| _AnalyticalQueryPublished | _AnalyticalQueryPublished | 1 | |
| _CdsDefinition | _CdsDefinition | 1 | |
| _CdsFavorite | _CdsFavorite | 1 | |
| _CdsSupportedCapabilities | _CdsSupportedCapabilities | 3 | |
| _CdsViewAnnotation | _CdsViewAnnotation | 1 | |
| _CdsViewCrossreference | _CdsViewCrossreference | 1 | |
| _CdsViewParameter | _CdsViewParameter | 1 | |
| _CdsViewUserTag | _CdsViewUserTag | 3 | |
| _EditorText | _EditorText | 1 | |
| AppID | AppID | 4 | |
| ApplicationComponent | ApplicationComponent | 1 | |
| ApplicationComponentName | ApplicationComponentName | 3 | |
| CDSName | CDSName | 3 | |
| CDSOrigin | CDSOrigin | 4 | |
| CDSOriginKey | CDSOriginKey | 4 | |
| CDSViewCategory | CDSViewCategory | 4 | |
| CDSViewPackage | CDSViewPackage | 4 | |
| CDSViewSourceSystem | CDSViewSourceSystem | 4 | |
| CDSViewStatus | CDSViewStatus | 4 | |
| CDSViewStatusCloud | CDSViewStatusCloud | 2 | |
| CdsViewType | CdsViewType | 4 | |
| DDLSourceIsFavorite | DDLSourceIsFavorite | 4 | |
| DDLSourceNameText | DDLSourceNameText | 3 | |
| DDLSourceText | DDLSourceText | 4 | |
| DefaultText | DefaultText | 4 | |
| DraftDDLSourceName | DraftDDLSourceName | 4 | |
| IsDraft | IsDraft | 4 | |
| SourceType | SourceType | 4 | |
| SQLViewName | SQLViewName | 3 | |
| WDAppID | WDAppID | 4 |
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.
-- Final CDS view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VB_FINAL_QUERY_CE (
DDLSOURCENAME,
_ANALYTICALQUERYPUBLISHED,
_CDSDEFINITION,
_CDSFAVORITE,
_CDSSUPPORTEDCAPABILITIES,
_CDSVIEWANNOTATION,
_CDSVIEWCROSSREFERENCE,
_CDSVIEWPARAMETER,
_CDSVIEWUSERTAG,
_EDITORTEXT,
APPID,
APPLICATIONCOMPONENT,
APPLICATIONCOMPONENTNAME,
CDSNAME,
CDSORIGIN,
CDSORIGINKEY,
CDSVIEWCATEGORY,
CDSVIEWPACKAGE,
CDSVIEWSOURCESYSTEM,
CDSVIEWSTATUS,
CDSVIEWSTATUSCLOUD,
CDSVIEWTYPE,
DDLSOURCEISFAVORITE,
DDLSOURCENAMETEXT,
DDLSOURCETEXT,
DEFAULTTEXT,
DRAFTDDLSOURCENAME,
ISDRAFT,
SOURCETYPE,
SQLVIEWNAME,
WDAPPID,
PRIMARY KEY (DDLSOURCENAME)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA