I_SETLEAF

CDS View

Set Leaf

I_SETLEAF is a CDS View in S/4HANA. Set Leaf. It contains 8 fields. 22 CDS views read from this table.

Used by 22 CDS view(s) 8 fields

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_FunctionalAreaGroupIncluded view from CONSUMPTION Functional Area Group Included
C_Setleaf view from CONSUMPTION setleaf for groups
C_SetleafForBPObjp view from CONSUMPTION Setleaf For Budget Period Object Pages
C_SetleafForBudgetPeriodGrp view from CONSUMPTION Setleaf for BudgetPeriodGrp
C_SetLeafForCIObjP view from CONSUMPTION Set Leaf for Commitment Item
C_SetleafForCommitmentItemGrp view from CONSUMPTION Setleaf For Commitment Item Group
C_Setleafforfaobjp view from CONSUMPTION Setleaf For Functional Area Object Pages
C_SetLeafForFmObjP view from CONSUMPTION Auxiliary For Sets in FM Object Pages
C_Setleafforfunctionalareagrp view from CONSUMPTION Functional Area Group Setleaf
C_Setleafforfundcentergrp view from CONSUMPTION Funds Center Set Leaf
C_Setleafforfundedprgmobjp view from CONSUMPTION Set leaf for Funded Program
C_Setleafforfundedprogramgrp view from CONSUMPTION Funded Program Set leaf
C_Setleafforfundgrp view from CONSUMPTION Fund Group Set Leaf
C_Setleafforfundobjp view from CONSUMPTION Set Leaf for Fund Group
C_Setleafforfundscenterobjp view from CONSUMPTION Set Leaf for Funds Center Group
C_SetLeafForGrantGrp view from CONSUMPTION Grant Group Setleaf
C_SetLeafForGrantObjP view from CONSUMPTION Set Leaf for Grant
P_ActyTypeExpndHier view inner COMPOSITE
P_InternalOrderGroupLeaf view from COMPOSITE
P_MstrProjStstclKeyFigGrp view from BASIC
P_ProfitCenterGroupLeaf view from COMPOSITE
R_CostElementGroupHierarchy view union COMPOSITE Cost Element Group Hierarchy

Fields (8)

KeyField CDS FieldsUsed in Views
KEY SetClass SetClass 1
KEY SetID SetID 1
KEY SetLineNumber SetLineNumber 1
KEY SetSubClass ParentSetSubClass,SetSubClass 2
SetLineSequenceNumber SetLineSequenceNumber 1
SetRangeOption SetRangeOption 8
SetRangeSign SetRangeSign 1
SetRangeToValue SetRangeToValue 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISETLEAF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Set Leaf'

@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_Setleaf
  as select from setleaf

  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 setleaf.setclass    as SetClass,
      @ObjectModel.foreignKey.association:'_SetSubClass'
  key setleaf.subclass    as SetSubClass,
      @ObjectModel.foreignKey.association:'_Set'
  key setleaf.setname     as SetID,
  key setleaf.lineid      as SetLineNumber,
      setleaf.valsign     as SetRangeSign,
      setleaf.valoption   as SetRangeOption,
      setleaf.valfrom     as SetRangeFromValue,
      setleaf.valto       as SetRangeToValue,
      setleaf.seqnr       as SetLineSequenceNumber,
      _SetClass,
      _SetSubClass,
      _Set
}

Learn More