CDS_VIEW_ALL
All CDS Views with Analytic/Non-Analytic categorization
CDS_VIEW_ALL is a CDS View in S/4HANA. All CDS Views with Analytic/Non-Analytic categorization. It contains 19 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Cds_View | view | from | List of CDS View based on App Type | |
| Cds_view_annotation_query_Vb | view | from | List of CDS View for View Browser |
Fields (19)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DDLSourceName | DDLSourceName | 2 |
| _CdsApplComp | _CdsApplComp | 1 | |
| _CdsBrowserTag | _CdsBrowserTag | 1 | |
| _CdsDefinition | _CdsDefinition | 1 | |
| _CdsFavorite | _CdsFavorite | 1 | |
| _CdsTagCount | _CdsTagCount | 1 | |
| _CdsViewAnnotation | _CdsViewAnnotation | 1 | |
| _CdsViewCrossreference | _CdsViewCrossreference | 1 | |
| _CdsViewParameter | _CdsViewParameter | 1 | |
| _EditorText | _EditorText | 1 | |
| _Text | _Text | 1 | |
| CDSName | CDSName | 1 | |
| CDSOrigin | CDSOrigin | 1 | |
| CDSReleaseStatus | CDSReleaseStatus | 1 | |
| CDSType | CDSType | 1 | |
| CDSViewPackage | CDSViewPackage | 1 | |
| CDSViewSourceSystem | CDSViewSourceSystem | 1 | |
| DDLSourceNameText | DDLSourceNameText | 1 | |
| SQLViewName | SQLViewName | 1 |
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.
-- All CDS Views with Analytic/Non-Analytic categorization
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CDS_VIEW_ALL (
DDLSOURCENAME,
_CDSAPPLCOMP,
_CDSBROWSERTAG,
_CDSDEFINITION,
_CDSFAVORITE,
_CDSTAGCOUNT,
_CDSVIEWANNOTATION,
_CDSVIEWCROSSREFERENCE,
_CDSVIEWPARAMETER,
_EDITORTEXT,
_TEXT,
CDSNAME,
CDSORIGIN,
CDSRELEASESTATUS,
CDSTYPE,
CDSVIEWPACKAGE,
CDSVIEWSOURCESYSTEM,
DDLSOURCENAMETEXT,
SQLVIEWNAME,
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