I_SETLEAF

CDS View

Set Leaf

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

Used by 5 CDS view(s) 2 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_ActyTypeExpndHier view inner COMPOSITE Expanded Hierarchy for Activity Types Groups
P_InternalOrderGroupLeaf view from COMPOSITE WUIO Groups - Leaf
P_MstrProjStstclKeyFigGrp view from BASIC Master Project Statistical Keyfigure Group List
P_ProfitCenterGroupLeaf view from COMPOSITE Private
R_CostElementGroupHierarchy view union COMPOSITE Cost Element Group Hierarchy

Fields (2)

KeyField CDS FieldsUsed in Views
KEY SetSubClass ParentSetSubClass 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