I_SETNODE

CDS View

Set Node

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

Used by 23 CDS view(s) 7 fields

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_BudgetPeriodChildGroup view from CONSUMPTION Budget Period Child Groups
C_BudgetPeriodParentGroup view from CONSUMPTION Budget Period Parent Groups
C_ChildGrantGroup view from CONSUMPTION Child Grant Group
C_ChildGroup view from CONSUMPTION Child Group
C_Childgroup_Fund view from CONSUMPTION Fund Child Group
C_Childgroup_Funded_prg view from CONSUMPTION Funded Program Child Group
C_Childgroup_Fundscenter view from CONSUMPTION Funds Center Child Group
C_CommitmentItemChildGroups view from CONSUMPTION Commitment Item Child Groups
C_CommitmentItemParentGroups view from CONSUMPTION Commitment Item Parents Groups
C_FunctionalAreaChildGroups view from CONSUMPTION Functional Area Child Groups
C_FunctionalAreaParentGroups view from CONSUMPTION Functional Area Parent Groups
C_ParentGrantGroup view from CONSUMPTION Parent Grant Group
C_ParentGroup view from CONSUMPTION ParentGroup
C_Parentgroup_Fund view from CONSUMPTION Fund Parent Group
C_Parentgroup_Funded_prg view from CONSUMPTION Funded Program Parent Group
C_Parentgroup_Fundscenter view from CONSUMPTION Funds Center Parent Group
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
P_CostCenterStdGrpHierNodeRltn view from COMPOSITE
P_InternalOrderGroupNode view from COMPOSITE
P_ProfitCenterGroupNode view from COMPOSITE
R_CostElementGroupHierarchy view union COMPOSITE Cost Element Group Hierarchy

Fields (7)

KeyField CDS FieldsUsed in Views
KEY SetClass SetClass 18
KEY SetID SetID 18
KEY SetLineNumber SetLineNumber 18
KEY SetSubClass SetSubClass 18
ChildSetClass ChildSetClass 16
ChildSetID ChildSetID 16
ChildSetSubClass ChildSetSubClass 16 
@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

}    
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SETNODE"
],
"ASSOCIATED":
[
"I_SETCLASS",
"I_SETHEADER",
"I_SETSUBCLASS"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More