ddcds_selectlist_proj

DDL: DDCDS_SELECTLIST_PROJ Type: view_entity Package: SD_CDS_ENTITY_CORE

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)

SourceAliasJoin Type
ddcds_selectlist ddcds_selectlist from

Fields (23)

KeyFieldSource TableSource FieldDescription
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
;