DDCDS_ENTITY_ELEMENTS_LIST
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.
Annotations (3)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Internal elements list | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (71)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | strucobjn | strucobjn | ||
| KEY | nodename | nodename | ||
| KEY | fieldname | fieldname | ||
| KEY | as4local | as4local | ||
| keyflag | keyflag | |||
| rollname | rollname | |||
| checktable | checktable | |||
| adminfield | adminfield | |||
| inttype | inttype | |||
| intlen | intlen | |||
| reftable | reftable | |||
| precfield | precfield | |||
| reffield | reffield | |||
| notnull | notnull | |||
| datatype | datatype | |||
| leng | leng | |||
| decimals | decimals | |||
| domname | domname | |||
| shlporigin | shlporigin | |||
| tabletype | tabletype | |||
| depth | depth | |||
| comptype | comptype | |||
| reftype | reftype | |||
| languflag | languflag | |||
| anonymous | anonymous | |||
| outputstyle | outputstyle | |||
| enabled | enabled | |||
| transient | transient | |||
| fieldnamedbs | fieldnamedbs | |||
| lfieldname | lfieldname | |||
| fieldorigin | fieldorigin | |||
| outputlen | outputlen | |||
| is_virtual | is_virtual | |||
| extendname | extendname | |||
| convexit | convexit | |||
| simple_type | simple_type | |||
| KEY | nodename | nodename | ||
| KEY | fieldname | associationname | ||
| KEY | as4local | as4local | ||
| keyflag | ||||
| rollname | ||||
| checktable | ||||
| adminfield | ||||
| inttype | ||||
| intlen | ||||
| reftable | ||||
| precfield | ||||
| reffield | ||||
| notnull | ||||
| datatype | ||||
| leng | ||||
| decimals | ||||
| domname | ||||
| shlporigin | ||||
| tabletype | ||||
| depth | ||||
| comptype | ||||
| reftype | ||||
| languflag | ||||
| anonymous | ||||
| outputstyle | ||||
| enabled | ||||
| transient | ||||
| fieldnamedbs | ||||
| lfieldname | ||||
| fieldorigin | assorigin | |||
| outputlen | ||||
| is_virtual | ||||
| extendname | ||||
| convexit | ||||
| simple_type |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Internal elements list'
@Metadata.ignorePropagatedAnnotations : true
define view entity DDCDS_ENTITY_ELEMENTS_LIST
as select from dd03nd
{
key strucobjn as strucobjn,
key nodename as nodename,
key fieldname as fieldname,
key as4local as as4local,
key position as element_position,
keyflag as keyflag,
rollname as rollname,
checktable as checktable,
adminfield as adminfield,
inttype as inttype,
intlen as intlen,
reftable as reftable,
precfield as precfield,
reffield as reffield,
notnull as notnull,
datatype as datatype,
leng as leng,
decimals as decimals,
domname as domname,
shlporigin as shlporigin,
tabletype as tabletype,
depth as depth,
comptype as comptype,
reftype as reftype,
languflag as languflag,
anonymous as anonymous,
outputstyle as outputstyle,
enabled as enabled,
transient as transient,
fieldnamedbs as fieldnamedbs,
lfieldname as lfieldname,
fieldorigin as fieldorigin,
appendstruname as appendstruname,
fieldname_raw as fieldname_raw,
sql_passvalue as sql_passvalue,
outputlen as outputlen,
is_virtual as is_virtual,
is_calculated as is_calculated,
extendname as extendname,
convexit as convexit,
is_calculated_quantity as is_calculated_quantity,
simple_type as simple_type,
buffer_propagated as buffer_propagated
}
union select from dd08b
{
key strucobjn as strucobjn,
key nodename as nodename,
key associationname as fieldname,
key as4local as as4local,
key 0 as element_position,
'' as keyflag,
'' as rollname,
'' as checktable,
'' as adminfield,
'' as inttype,
'000000' as intlen,
'' as reftable,
'' as precfield,
'' as reffield,
'' as notnull,
'' as datatype,
'000000' as leng,
'000000' as decimals,
'' as domname,
'' as shlporigin,
'' as tabletype,
'00' as depth,
'' as comptype,
'' as reftype,
'' as languflag,
'' as anonymous,
'00' as outputstyle,
'' as enabled,
'' as transient,
'' as fieldnamedbs,
'' as lfieldname,
assorigin as fieldorigin,
'' as appendstruname,
assocname_raw as fieldname_raw,
'' as sql_passvalue,
'000000' as outputlen,
'' as is_virtual,
'' as is_calculated,
'' as extendname,
'' as convexit,
'' as is_calculated_quantity,
'' as simple_type,
'' as buffer_propagated
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03ND",
"DD08B"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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