I_SETNODE

CDS View

Set Node

I_SETNODE is a CDS View in S/4HANA. Set Node. It contains 4 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 4 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_CostCenterGroupHierNodeRltn view from COMPOSITE Cost Center Group Hierarchy Relation
I_ProfitCtrStdGrpHierNodeRltn view_entity from COMPOSITE Profit Center Standard Group Hierarchy Relation
P_ActyTypeAllHierNodes view from BASIC All Nodes For Activity Type Groups Unioned
P_CostCenterStdGrpHierNodeRltn view from COMPOSITE Cost Center Group Standard Hierarchy Relation
P_InternalOrderGroupNode view from COMPOSITE WUIO Groups - Node
P_ProfitCenterGroupNode view from COMPOSITE Profit Center Group Hierarchy Node
R_CostElementGroupHierarchy view union COMPOSITE Cost Element Group Hierarchy

Fields (4)

KeyField CDS FieldsUsed in Views
KEY SetClass SetClass 2
KEY SetID SetID 2
KEY SetLineNumber SetLineNumber 2
KEY SetSubClass SetSubClass 2 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISETNODE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Set Node'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view I_Setnode
  as select from setnode

  association [0..1] to I_SetClass    as _SetClass    on  $projection.SetClass = _SetClass.SetClass
  
  association [0..1] to I_SetSubClass as _SetSubClass on  $projection.SetSubClass = _SetSubClass.SetSubClass
  
  association [0..1] to I_SetHeader   as _Set         on  $projection.SetClass    = _Set.SetClass
                                                      and $projection.SetSubClass = _Set.SetSubClass
                                                      and $projection.SetID       = _Set.SetID
{
      @ObjectModel.foreignKey.association:'_SetClass'
  key setnode.setclass    as SetClass,
      @ObjectModel.foreignKey.association:'_SetSubClass'
  key setnode.subclass    as SetSubClass,
      @ObjectModel.foreignKey.association:'_Set'
  key setnode.setname     as SetID,
  key setnode.lineid      as SetLineNumber,
      setnode.subsetcls   as ChildSetClass,
      setnode.subsetscls  as ChildSetSubClass,
      setnode.subsetname  as ChildSetID,
      setnode.seqnr       as SetLineSequenceNumber,
      _SetClass,
      _SetSubClass,
      _Set

}

Learn More