DDCDS_BASE_OBJECTS

DDL: DDCDS_BASE_OBJECTS Type: view_entity

Hierarchy of CDS VIEWS

DDCDS_BASE_OBJECTS is a CDS View that provides data about "Hierarchy of CDS VIEWS" in SAP S/4HANA. It reads from 3 data sources (ddcds_fromclause, DDCDS_VIEW_FROM_STOB, DDCDS_VIEW_FROM_STOB) and exposes 7 fields. It has 1 association to related views.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
ddcds_fromclause _hierarchy union
DDCDS_VIEW_FROM_STOB trinity from
DDCDS_VIEW_FROM_STOB trinity union

Associations (1)

CardinalityTargetAliasCondition
[1..1] DDCDS_VIEW_FROM_STOB _view_to_stobname _view_to_stobname.viewname = _joins.tabname

Annotations (2)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Hierarchy of CDS VIEWS view

Fields (7)

KeyFieldSource TableSource FieldDescription
source DDCDS_VIEW_FROM_STOB stobname
target dd08b strucobjn_t
target _joins tabname
type
target
type
name 
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Hierarchy of CDS VIEWS'
define view entity DDCDS_BASE_OBJECTS
  as select from DDCDS_VIEW_FROM_STOB as trinity
    join         dd08b on trinity.stobname = dd08b.strucobjn
{
  trinity.stobname       as source,
  dd08b.strucobjn_t      as target,
  case
  when dd08b.associationkind = 1 then 'composition         '
                                 else 'association         '
  end                    as type,
  dd08b.associationname  as name
  //  ,

  //  _to_parent

}
union select from DDCDS_VIEW_FROM_STOB as trinity
  join            dd26s                   as _joins on _joins.viewname = trinity.viewname
association [1..1] to DDCDS_VIEW_FROM_STOB as _view_to_stobname on _view_to_stobname.viewname = _joins.tabname
association        to ddtypes                                      on _joins.tabname = ddtypes.typename
{
  trinity.stobname           as source,
  _joins.tabname             as target,
  'from'                     as type,
  ''                         as name
}
union select from ddcds_fromclause as _hierarchy
{
  entity_name                               as source,
  cast( parameter_value as ddstrucobjname ) as target,
  'from'                                    as type,
  'child2parent'                            as name
}
where
  parameter_name = 'HIER_SOURCE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDCDS_VIEW_FROM_STOB",
"DD08B",
"DD26S",
"DDCDS_FROMCLAUSE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More