ddcds_selectlist_proj
Projection on DDCDS_SELECTLIST: strings to characters
ddcds_selectlist_proj is a CDS View that provides data about "Projection on DDCDS_SELECTLIST: strings to characters" in SAP S/4HANA. It reads from 1 data source (ddcds_selectlist) and exposes 23 fields with key fields entity_name, union_number, element_pos, stack_line, as4local. Part of development package SD_CDS_ENTITY_CORE.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ddcds_selectlist | ddcds_selectlist | from |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | entity_name | entity_name | Table Name | |
| KEY | union_number | union_number | Union Select Number | |
| KEY | element_pos | element_pos | DD: Marked Position in a Repeat Group | |
| KEY | stack_line | stack_line | Stackcode Line | |
| KEY | as4local | as4local | Activation State | |
| expr_type | expr_type | Type of a source based expression | ||
| expr_subtype | expr_subtype | Subtype of Expressions | ||
| operator | operator | Type of OPTION component in row type of a Ranges type | ||
| data_element | Field type | |||
| keyflag | keyflag | Key field | ||
| is_virtual | is_virtual | Virtual | ||
| is_generated | is_generated | Generated Flag | ||
| assoc_name | DD: Name of an Association | |||
| datatype | datatype | Field Type | ||
| length | length | Text Length | ||
| decimals | decimals | Rounding Places | ||
| anno_name | DD: Key/Name for Annotation | |||
| anno_value | DD: Value of an Annotation | |||
| anno_type | Annotation type in stackcode | |||
| simple_type | CDS Type Name | |||
| enum_name | Enum of CDS Type | |||
| aspect_name | CDS Aspect Name | |||
| aspect_alias |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view ddcds_selectlist_proj.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW ddcds_selectlist_proj AS
SELECT
entity_name,
union_number,
element_pos,
stack_line,
as4local,
expr_type,
expr_subtype,
operator,
cast(data_element as abap.char(30)) AS data_element,
keyflag,
is_virtual,
is_generated,
cast(assoc_name as abap.char(30)) AS assoc_name,
datatype,
length,
decimals,
cast(anno_name as abap.char(240)) AS anno_name,
cast(anno_value as abap.char(1333)) AS anno_value,
cast(anno_type as abap.char(20)) AS anno_type,
cast(simple_type as abap.char(30)) AS simple_type,
cast(enum_name as abap.char(30)) AS enum_name,
cast(aspect_name as abap.char(30)) AS aspect_name,
cast(aspect_alias as abap.char(30)) AS aspect_alias
FROM ddcds_selectlist
;
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA