DD_CDS_ROOTREF_BASE

DDL: DD_CDS_ROOTREF_BASE Type: view_entity Package: SD_CDS_ENTITY_CORE

Base for root composition hierarchy

DD_CDS_ROOTREF_BASE is a CDS View that provides data about "Base for root composition hierarchy" in SAP S/4HANA. It reads from 3 data sources (dd08b, dd02bnd, dd02bnd) and exposes 5 fields. It has 1 association to related views. Part of development package SD_CDS_ENTITY_CORE.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
dd08b dd08b from
dd02bnd node_composite inner
dd02bnd node_parent inner

Associations (1)

CardinalityTargetAliasCondition
[1] DD_CDS_ROOTREF_BASE _to_parent $projection.parent_entity = _to_parent.composite_entity and $projection.state = _to_parent.state

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Base for root composition hierarchy view

Fields (5)

KeyFieldSource TableSource FieldDescription
state dd08b as4local
card_max dd08b card_max
card_min dd08b card_min
typekind_t dd08b typekind_t
_to_parent _to_parent 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Base for root composition hierarchy'
define view entity DD_CDS_ROOTREF_BASE
  as select from dd08b

    inner join   dd02bnd as node_parent    on  dd08b.strucobjn = node_parent.strucobjn
                                           and dd08b.as4local  = node_parent.as4local
    inner join   dd02bnd as node_composite on  dd08b.strucobjn_t = node_composite.strucobjn
                                           and dd08b.as4local    = node_composite.as4local
  association [1] to DD_CDS_ROOTREF_BASE as _to_parent on  $projection.parent_entity = _to_parent.composite_entity
                                                       and $projection.state         = _to_parent.state
{
  dd08b.strucobjn             as parent_entity,
  node_parent.isrootnode      as parent_is_root,
  dd08b.strucobjn_t           as composite_entity,
  node_parent.rootnode_ref    as parent_rootnode_ref,
  node_composite.rootnode_ref as composite_rootnode_ref,
  dd08b.as4local              as state,
  dd08b.associationkind       as associationkind,
  dd08b.associationname       as associationname,
  dd08b.card_max              as card_max,
  dd08b.card_min              as card_min,
  dd08b.typekind_t            as typekind_t,
  _to_parent // Make association public

}
where
      dd08b.associationkind = 1
  and dd08b.as4local        = 'A'

Learn More