CFD_W_CDS_CXT
Custom Fields: CDS View Registry Context
CFD_W_CDS_CXT is an SAP database table in S/4HANA. Custom Fields: CDS View Registry Context. It contains 27 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BUSINESSCONTEXT | view_entity | from | CDS View Business Context | |
| P_Cfd_Business_Context_Union | view | from | Custom Fields: Union Business Contexts | |
| P_Cfd_Registry_Cds | view | from | Available CDS views for usage of Custom Fields |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | cds_view_name | CFD_CDS_VIEW_NAME | CDS View Name | |||
| KEY | sequence_number | CFD_SEQUENCE_NUMBER | Sequence No. | |||
| release_status | CFD_RELEASE_STATUS | Release State | ||||
| business_context | CFD_BUSINESS_CONTEXT | Business Context | ||||
| union_suffix | CFD_UNION_SUFFIX | Union Suffix | ||||
| direct_union_suffix | CFD_DIRECT_UNION_SUFFIX | Direct Union Suffix | ||||
| role_suffix | CFD_ROLE_SUFFIX | Role Suffix | ||||
| role_text_data_element | CFD_ROLE_TEXT_DATA_ELEMENT | Role Text Element | ||||
| underlying_view_alias | CFD_UNDERLYING_VIEW_ALIAS | Underlying Alias | ||||
| underlying_view_name | CFD_UNDERLYING_CDS_VIEW_NAME | Underlying View Name | ||||
| extension_incl_view_alias | CFD_CDS_ALIAS | Assoc. to Ext. View | ||||
| extension_incl_view_name | CFD_EXTENSION_INCLUDE_VIEW | Extension Incl. View | ||||
| condition_field_alias | CFD_CONDITION_FIELD_ALIAS | Datasource Alias | ||||
| condition_field_name | CFD_CONDITION_FIELD_NAME | Condition Field Name | ||||
| condition_field_value | CFD_CONDITION_FIELD_VALUE | Condition Value | ||||
| has_union_all | CFD_VIEW_BRANCH_HAS_UNION_ALL | Has union all | ||||
| has_group_by | CFD_VIEW_BRANCH_HAS_GROUP_BY | Has group by | ||||
| draft_10_ext_incl_view_alias | CFD_CDS_ALIAS | Assoc. to Ext. View | ||||
| draft_10_condition_field_alias | CFD_CONDITION_FIELD_ALIAS | Datasource Alias | ||||
| direct_union_branch | CFD_DIRECT_UNION_BRANCH | Extended Branch | ||||
| direct_union_branch_position | CFD_DIRECT_UNION_BRANCH_POS | Position in branch | ||||
| add_field_automatically | CFD_ADD_FIELD_AUTOMATICALLY | Add Field automatic | ||||
| cds_view_is_always_enabled | CFD_CDS_VIEW_IS_ALWAYS_ENABLED | Always Enabled | ||||
| ch_generic_pers_view_alias | CFD_CH_GENERIC_PERS_VIEW_ALIAS | Characteristic Alias | ||||
| ch_generic_pers_view_name | CFD_CH_GENERIC_PERS_VIEW_NAME | Characteristic View | ||||
| mandatory_field_enabled | CFD_MANDATORY_FIELD_ENABLED | Mandatory Enabled | ||||
| read_only_field_enabled | CFD_READ_ONLY_FIELD_ENABLED | Read Only Enabled |
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 Context
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFD_W_CDS_CXT (
CDS_VIEW_NAME, -- CDS View Name [CFD_CDS_VIEW_NAME]
SEQUENCE_NUMBER, -- Sequence No. [CFD_SEQUENCE_NUMBER]
RELEASE_STATUS, -- Release State [CFD_RELEASE_STATUS]
BUSINESS_CONTEXT, -- Business Context [CFD_BUSINESS_CONTEXT]
UNION_SUFFIX, -- Union Suffix [CFD_UNION_SUFFIX]
DIRECT_UNION_SUFFIX, -- Direct Union Suffix [CFD_DIRECT_UNION_SUFFIX]
ROLE_SUFFIX, -- Role Suffix [CFD_ROLE_SUFFIX]
ROLE_TEXT_DATA_ELEMENT, -- Role Text Element [CFD_ROLE_TEXT_DATA_ELEMENT]
UNDERLYING_VIEW_ALIAS, -- Underlying Alias [CFD_UNDERLYING_VIEW_ALIAS]
UNDERLYING_VIEW_NAME, -- Underlying View Name [CFD_UNDERLYING_CDS_VIEW_NAME]
EXTENSION_INCL_VIEW_ALIAS, -- Assoc. to Ext. View [CFD_CDS_ALIAS]
EXTENSION_INCL_VIEW_NAME, -- Extension Incl. View [CFD_EXTENSION_INCLUDE_VIEW]
CONDITION_FIELD_ALIAS, -- Datasource Alias [CFD_CONDITION_FIELD_ALIAS]
CONDITION_FIELD_NAME, -- Condition Field Name [CFD_CONDITION_FIELD_NAME]
CONDITION_FIELD_VALUE, -- Condition Value [CFD_CONDITION_FIELD_VALUE]
HAS_UNION_ALL, -- Has union all [CFD_VIEW_BRANCH_HAS_UNION_ALL]
HAS_GROUP_BY, -- Has group by [CFD_VIEW_BRANCH_HAS_GROUP_BY]
DRAFT_10_EXT_INCL_VIEW_ALIAS, -- Assoc. to Ext. View [CFD_CDS_ALIAS]
DRAFT_10_CONDITION_FIELD_ALIAS, -- Datasource Alias [CFD_CONDITION_FIELD_ALIAS]
DIRECT_UNION_BRANCH, -- Extended Branch [CFD_DIRECT_UNION_BRANCH]
DIRECT_UNION_BRANCH_POSITION, -- Position in branch [CFD_DIRECT_UNION_BRANCH_POS]
ADD_FIELD_AUTOMATICALLY, -- Add Field automatic [CFD_ADD_FIELD_AUTOMATICALLY]
CDS_VIEW_IS_ALWAYS_ENABLED, -- Always Enabled [CFD_CDS_VIEW_IS_ALWAYS_ENABLED]
CH_GENERIC_PERS_VIEW_ALIAS, -- Characteristic Alias [CFD_CH_GENERIC_PERS_VIEW_ALIAS]
CH_GENERIC_PERS_VIEW_NAME, -- Characteristic View [CFD_CH_GENERIC_PERS_VIEW_NAME]
MANDATORY_FIELD_ENABLED, -- Mandatory Enabled [CFD_MANDATORY_FIELD_ENABLED]
READ_ONLY_FIELD_ENABLED, -- Read Only Enabled [CFD_READ_ONLY_FIELD_ENABLED]
PRIMARY KEY (CDS_VIEW_NAME, SEQUENCE_NUMBER)
);
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