C_SetleafForBPObjp

@AbapCatalog.sqlViewName: 'CSTLFBPOBJP'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Setleaf For Budget Period Object Pages'
@AbapCatalog.compiler.compareFilter: true
@UI.headerInfo: {
  typeName: 'Budget Period Group',
  typeNamePlural: 'Budget Period Groups'
}
define view C_SetleafForBPObjp
  as select from I_Setleaf

  association [0..*] to C_BudgetPeriod_ObjP      as _BudgetPeriod      on  (
           _BudgetPeriod.BudgetPeriod between $projection.SetRangeFromValue and $projection.SetRangeToValue
         )

  association [0..1] to C_BudgetPeriodGroup_Objp as _BudgetPeriodGroup on  $projection.BudgetPeriodGroup = _BudgetPeriodGroup.BudgetPeriodGroup
                                                                       and _BudgetPeriodGroup.SetClass   = '0114'

{
      @Consumption.hidden: true
  key SetClass,
      @Consumption.hidden: true
  key SetSubClass,
      @EndUserText.label:'Budget Period Group'
      @Consumption.semanticObject:'BudgetPeriodGroup'
      //key SetID,

  key SetID as BudgetPeriodGroup,

      @Consumption.hidden: true
  key SetLineNumber,
      //@UI.hidden: true

  key _BudgetPeriod.BudgetPeriod,
      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden: true
      SetRangeOption,
      @UI.hidden: true
      SetRangeFromValue,
      @UI.hidden: true
      SetRangeToValue,
      //_FunctionalArea


      //meta

      @EndUserText.label:'Created By'
      _BudgetPeriodGroup.CreatedByUser,
      // _FA.CreatedByUser,

      @EndUserText.label:'Creation Date'
      _BudgetPeriodGroup.CreationDate,

      @UI.hidden: true
      _BudgetPeriod.BudgetPeriodAuthznGrp,

      //Texts

      @EndUserText.label:'Group Description'
      //_SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription

      _BudgetPeriodGroup.SetDescription


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_BUDGETPERIODGROUP_OBJP",
"C_BUDGETPERIOD_OBJP",
"I_SETLEAF"
],
"ASSOCIATED":
[
"C_BUDGETPERIODGROUP_OBJP",
"C_BUDGETPERIOD_OBJP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/