CFD_W_CDS
Custom Fields: CDS View Registry
CFD_W_CDS is an SAP database table in S/4HANA. Custom Fields: CDS View Registry. It contains 22 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CDSReleaseContract0 | view | from | BASIC | C0 release info |
| P_Cfd_C0_Registrations_CDS | view | from | Custom Fields: Registered CDS Views | |
| P_Cfd_C0_Registrations_CDS_CBC | view | inner | Registered Ext. Include Changed By Count | |
| P_Cfd_C0_Registrations_CDS_CBy | view | inner | Registered Ext. Include Changed On | |
| P_Cfd_C0_Registrations_CDS_COn | view | inner | Registered Ext. Include Changed On | |
| P_Cfd_Cds_Email_BusCtxt | view | inner | Custom Fields: Business Contexts for Email Usage | |
| P_Cfd_Cds_Email_BusCtxt_Union | view | inner | Custom Fields: Union Business Contexts for Email Usage | |
| p_cfd_cds_view_value_help | view | left_outer | ||
| P_Cfd_De_Datasource | view | union_all | ||
| P_CFD_DE_DATASOURCE_FEATURE | view_entity | from | ||
| P_Cfd_Reg_Cds_Text_Source | view | from | Determine Source of Texts | |
| P_Cfd_Reg_Obj_CDS | view | from | Registry Objects for CDS View | |
| P_Cfd_Registry_Cds | view | inner | Available CDS views for usage of Custom Fields | |
| P_CFD_Successors_For_C0_BDEF | view_entity | left_outer |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | cds_view_name | cfd_cds_view_name | CDS View Name | |||
| availability | cfd_availability | Availability | ||||
| release_status | cfd_release_status | Release State | ||||
| supported_features | cfd_supported_features | Supported features | ||||
| text_classification | cfd_text_classification | Text Classification | ||||
| view_type | cfd_cds_view_type | View Type | ||||
| based_on_underlying_view | cfd_based_on_underlying_view | From underlying View | ||||
| basic_search_support | cfd_basic_search_support | Basic Search support | ||||
| has_group_by | cfd_view_has_group_by | Has "Group By" | ||||
| has_union | cfd_view_has_union | Has union | ||||
| has_default_aggregation | cfd_view_has_default_aggr | Has default aggr. | ||||
| is_analytical_query | cfd_view_is_analytical_query | Analytical Query | ||||
| has_datacategory_cube | cfd_view_has_datacategory_cube | Has category 'Cube' | ||||
| has_datacategory_fact | cfd_view_has_datacategory_fact | Has category Fact | ||||
| has_datacategory_dimension | cfd_view_has_datacategory_dim | 'Dimension' | ||||
| is_redirect_view | cfd_view_is_redirect_view | Redirect View | ||||
| language_parameter | cfd_cds_language_parameter | Language Parameter | ||||
| behavior_definition | cfd_behavior_definition | Behaviour Definition | ||||
| behavior_entity_alias | cfd_behavior_entity_alias | Entity Alias | ||||
| det_val_supported | cfd_det_val_support | Validation&Determin | ||||
| has_draft | cfd_has_draft | Has Draft | ||||
| draft_union_datasource_alias | cfd_cds_draft_union_alias | Draft Union Alias |
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.
-- Custom Fields: CDS View Registry
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFD_W_CDS (
CDS_VIEW_NAME, -- CDS View Name [cfd_cds_view_name]
AVAILABILITY, -- Availability [cfd_availability]
RELEASE_STATUS, -- Release State [cfd_release_status]
SUPPORTED_FEATURES, -- Supported features [cfd_supported_features]
TEXT_CLASSIFICATION, -- Text Classification [cfd_text_classification]
VIEW_TYPE, -- View Type [cfd_cds_view_type]
BASED_ON_UNDERLYING_VIEW, -- From underlying View [cfd_based_on_underlying_view]
BASIC_SEARCH_SUPPORT, -- Basic Search support [cfd_basic_search_support]
HAS_GROUP_BY, -- Has "Group By" [cfd_view_has_group_by]
HAS_UNION, -- Has union [cfd_view_has_union]
HAS_DEFAULT_AGGREGATION, -- Has default aggr. [cfd_view_has_default_aggr]
IS_ANALYTICAL_QUERY, -- Analytical Query [cfd_view_is_analytical_query]
HAS_DATACATEGORY_CUBE, -- Has category 'Cube' [cfd_view_has_datacategory_cube]
HAS_DATACATEGORY_FACT, -- Has category Fact [cfd_view_has_datacategory_fact]
HAS_DATACATEGORY_DIMENSION, -- 'Dimension' [cfd_view_has_datacategory_dim]
IS_REDIRECT_VIEW, -- Redirect View [cfd_view_is_redirect_view]
LANGUAGE_PARAMETER, -- Language Parameter [cfd_cds_language_parameter]
BEHAVIOR_DEFINITION, -- Behaviour Definition [cfd_behavior_definition]
BEHAVIOR_ENTITY_ALIAS, -- Entity Alias [cfd_behavior_entity_alias]
DET_VAL_SUPPORTED, -- Validation&Determin [cfd_det_val_support]
HAS_DRAFT, -- Has Draft [cfd_has_draft]
DRAFT_UNION_DATASOURCE_ALIAS, -- Draft Union Alias [cfd_cds_draft_union_alias]
PRIMARY KEY (CDS_VIEW_NAME)
);
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