C_Setleaf

DDL: C_SETLEAF SQL: CSETLEAF Type: view CONSUMPTION

setleaf for groups

C_Setleaf is a Consumption CDS View that provides data about "setleaf for groups" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 9 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSETLEAF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label setleaf for groups view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SetClass I_Setleaf SetClass
KEY SetSubClass I_Setleaf SetSubClass
KEY SetID I_Setleaf SetID
KEY SetLineNumber I_Setleaf SetLineNumber
SetRangeSign I_Setleaf SetRangeSign
SetRangeOption I_Setleaf SetRangeOption
SetRangeFromValueendasSetRangeFromValue
SetRangeToValueendasSetRangeToValue
SetLineSequenceNumber I_Setleaf SetLineSequenceNumber 
@AbapCatalog.sqlViewName: 'CSETLEAF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'setleaf for groups'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
define view C_Setleaf as select from I_Setleaf {
        //@ObjectModel.foreignKey.association:'_SetClass'

  key I_Setleaf.SetClass    as SetClass,
     // @ObjectModel.foreignKey.association:'_SetSubClass'

  key I_Setleaf.SetSubClass    as SetSubClass,
      //@ObjectModel.foreignKey.association:'_Set'

  key I_Setleaf.SetID    as SetID,
  
  key I_Setleaf.SetLineNumber  as SetLineNumber,
      I_Setleaf.SetRangeSign   as SetRangeSign,
      I_Setleaf.SetRangeOption   as SetRangeOption,
      case 
      when I_Setleaf.SetRangeFromValue = I_Setleaf.SetRangeToValue then ''
      else I_Setleaf.SetRangeFromValue
      end as SetRangeFromValue,
      
      case 
      when I_Setleaf.SetRangeFromValue = I_Setleaf.SetRangeToValue then ''
      else I_Setleaf.SetRangeToValue
      end as SetRangeToValue,
      
      
      I_Setleaf.SetLineSequenceNumber       as SetLineSequenceNumber
}

Learn More