DDCDS_ENTITY_ELEMENTS_LIST

DDL: DDCDS_ENTITY_ELEMENTS_LIST Type: view_entity
71 Fields 2 Data Sources

Internal elements list

DDCDS_ENTITY_ELEMENTS_LIST is a CDS View that provides data about "Internal elements list" in SAP S/4HANA. It reads from 2 data sources (dd03nd, dd08b) and exposes 71 fields with key fields strucobjn, nodename, fieldname, as4local, nodename.

Data Sources (2)

SourceAliasJoin Type
dd03nd dd03nd from
dd08b dd08b union

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Internal elements list view
Metadata.ignorePropagatedAnnotations true view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY strucobjn dd03nd strucobjn DD: Name of a structured object (e.g. entity, context)
KEY nodename dd03nd nodename Node Text
KEY fieldname dd03nd fieldname DD: Name of an Association
KEY as4local dd03nd as4local Activation State
keyflag dd03nd keyflag Key field
rollname dd03nd rollname Repr. Data Elem
checktable dd03nd checktable Table Name
adminfield dd03nd adminfield Admin. field
inttype dd03nd inttype Interest Type
intlen dd03nd intlen Length
reftable dd03nd reftable Reference table
precfield dd03nd precfield Name of include
reffield dd03nd reffield Reference field
notnull dd03nd notnull NOT NULL forced
datatype dd03nd datatype Field Type
leng dd03nd leng No. of Characters
decimals dd03nd decimals Rounding Places
domname dd03nd domname Domain
shlporigin dd03nd shlporigin Origin
tabletype dd03nd tabletype Table
depth dd03nd depth Draught
comptype dd03nd comptype Type of a reporting component
reftype dd03nd reftype Reference Type
languflag dd03nd languflag Text Lang.
anonymous dd03nd anonymous Anonymous
outputstyle dd03nd outputstyle Output
enabled dd03nd enabled Enabled
transient dd03nd transient Transient workflow
fieldnamedbs dd03nd fieldnamedbs DD: For Database Field Name (restricted by 30)
lfieldname dd03nd lfieldname DD: Concatenated Field Name
fieldorigin dd03nd fieldorigin DD: Origin of an Association
outputlen dd03nd outputlen Output Length
is_virtual dd03nd is_virtual Virtual
extendname dd03nd extendname Source Code Name
convexit dd03nd convexit Convers. Rout.
simple_type dd03nd simple_type CDS Type Name
KEY nodename nodename Node Text
KEY fieldname associationname DD: Name of an Association
KEY as4local as4local Activation State
keyflag Key field
rollname Repr. Data Elem
checktable Table Name
adminfield Admin. field
inttype Interest Type
intlen Length
reftable Reference table
precfield Name of include
reffield Reference field
notnull NOT NULL forced
datatype Field Type
leng No. of Characters
decimals Rounding Places
domname Domain
shlporigin Origin
tabletype Table
depth Draught
comptype Type of a reporting component
reftype Reference Type
languflag Text Lang.
anonymous Anonymous
outputstyle Output
enabled Enabled
transient Transient workflow
fieldnamedbs DD: For Database Field Name (restricted by 30)
lfieldname DD: Concatenated Field Name
fieldorigin assorigin DD: Origin of an Association
outputlen Output Length
is_virtual Virtual
extendname extendname Source Code Name
convexit Convers. Rout.
simple_type CDS Type Name

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_ENTITY_ELEMENTS_LIST.
-- 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_ENTITY_ELEMENTS_LIST AS
SELECT
  dd03nd.strucobjn AS strucobjn,
  dd03nd.nodename AS nodename,
  dd03nd.fieldname AS fieldname,
  dd03nd.as4local AS as4local,
  dd03nd.keyflag AS keyflag,
  dd03nd.rollname AS rollname,
  dd03nd.checktable AS checktable,
  dd03nd.adminfield AS adminfield,
  dd03nd.inttype AS inttype,
  dd03nd.intlen AS intlen,
  dd03nd.reftable AS reftable,
  dd03nd.precfield AS precfield,
  dd03nd.reffield AS reffield,
  dd03nd.notnull AS notnull,
  dd03nd.datatype AS datatype,
  dd03nd.leng AS leng,
  dd03nd.decimals AS decimals,
  dd03nd.domname AS domname,
  dd03nd.shlporigin AS shlporigin,
  dd03nd.tabletype AS tabletype,
  dd03nd.depth AS depth,
  dd03nd.comptype AS comptype,
  dd03nd.reftype AS reftype,
  dd03nd.languflag AS languflag,
  dd03nd.anonymous AS anonymous,
  dd03nd.outputstyle AS outputstyle,
  dd03nd.enabled AS enabled,
  dd03nd.transient AS transient,
  dd03nd.fieldnamedbs AS fieldnamedbs,
  dd03nd.lfieldname AS lfieldname,
  dd03nd.fieldorigin AS fieldorigin,
  dd03nd.outputlen AS outputlen,
  dd03nd.is_virtual AS is_virtual,
  dd03nd.extendname AS extendname,
  dd03nd.convexit AS convexit,
  dd03nd.simple_type AS simple_type
FROM dd03nd
-- UNION with additional select branch(es): dd08b
;

Learn More