C_SetleafForCommitmentItemGrp

@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@AbapCatalog.sqlViewName: 'CSETLEAFCMTGRP'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Setleaf For Commitment Item Group'
define view C_SetleafForCommitmentItemGrp
  as select from I_Setleaf

  association [0..1] to I_SetHeader           as _SetHeader  on  $projection.SetClass    = _SetHeader.SetClass
                                                             and $projection.SetSubClass = _SetHeader.SetSubClass
                                                             and $projection.SetID       = _SetHeader.SetID

  association [0..*] to C_CommitmentItem_ObjP as _Commitment on  $projection.SetSubClass   = _Commitment.FinancialManagementArea
                                                             and (
                                                                _Commitment.CommitmentItem between $projection.SetRangeFromValue and $projection.SetRangeToValue
                                                              )
  association [0..1] to C_Setleaf             as _setleaf    on  $projection.SetClass      = _setleaf.SetClass
                                                             and $projection.SetSubClass   = _setleaf.SetSubClass
                                                             and $projection.SetID         = _setleaf.SetID
                                                             and $projection.SetLineNumber = _setleaf.SetLineNumber

  association [0..1] to I_FundsMgmtEmptySet   as _EmptySet   on  $projection.SetRangeOption = _EmptySet.SetRangeOption

{
      @UI.hidden: true
  key SetClass,
      @Consumption.hidden: true
  key SetSubClass,
      @EndUserText.label:'Commitment Item Group'
      @Consumption.semanticObject:'CommitmentItemGroup'
      @UI.hidden: true
  key SetID,
      @Consumption.hidden: true
  key SetLineNumber,
      @EndUserText.label:'Commitmet Item'
      @Consumption.semanticObject:'CommitmentItem'
  key _Commitment.CommitmentItem,
      @EndUserText.label:'Financial Management Area'
  key _Commitment.FinancialManagementArea,
      @EndUserText.label:'Commitment Item Text'
      case when _Commitment.CommitmentItem is null then
        _EmptySet._Text[1:Language = $session.system_language].FundsMgmtEmptySetDescription
      else
        _Commitment.CommitmentItemName
      end                        as CommitmentItemName,
      @EndUserText.label:'Created By'
      _Commitment.CreatedByUser,
      @EndUserText.label:'Created On'
      _Commitment.CreationDate,
      @EndUserText.label:'Valid From'
      _Commitment.ValidityStartDate,
      @EndUserText.label:'Valid To'
      _Commitment.ValidityEndDate,
      @EndUserText.label:'Item category'
      _Commitment.CommitmentItemCategory,
      @EndUserText.label:'Financial Management Area Text'
      _Commitment.FinancialManagementAreaName,
      @EndUserText.label:'Fiscal Year'
      _Commitment.FinMgmtAreaFiscalYear,
      @EndUserText.label:'Financial Transaction'
      _Commitment.CmtmtItmFinancialTransaction,
      @EndUserText.label:'Fiscal Year Varient'
      _Commitment.FinMgmtAreaFiscalYearVariant,
      @EndUserText.label:'Funds Center Name'
      _Commitment.FundsCenterName,
      @EndUserText.label:'Default Funds Center'
      _Commitment.CmtmtItmDefaultFundsCenter,
      @EndUserText.label:'Funds Center Description'
      _Commitment.FundsCenterDescription,
      @EndUserText.label:'Expiration Date'
      _Commitment.CommitmentItemExpirationDate,
      @Consumption.hidden: true
      _Commitment.CommitmentItemAuthznGrp,
      @Consumption.hidden: true
      _Commitment.CmtmtItemFinMgmtAreaForAuthzn,
      // _Commitment.

      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden: true
      I_Setleaf.SetRangeOption,

      //case


      //when SetRangeFromValue = SetRangeToValue then ''

      //else SetRangeFromValue

      @Consumption.hidden: true
      SetRangeFromValue,

      //@EndUserText.label:'Range To'

      @Consumption.hidden: true
      SetRangeToValue,
      @EndUserText.label:'Range From'
      _setleaf.SetRangeFromValue as ValidFrom,
      @EndUserText.label:'Range To'
      _setleaf.SetRangeToValue   as ValidTo,
      @UI.hidden: true
      @EndUserText.label:'Commitment Item Group Name'
      _SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription
      //_Setleaf




      //meta

      // @EndUserText.label:'Created By'

      //_SetHeader.CreatedByUser,

      //@EndUserText.label:'Creation Date'

      //_SetHeader.CreationDate,



      //Texts

      // @EndUserText.label:'Group Description'

      //_SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription


      // @Consumption.hidden: true

      // cast( concat_with_space(SetID, _SetHeader._SetText[1:Language=$session.system_language].SetDescription, 1 ) as fmis_fundsmgmtextendedsetname ) as  FundsMgmtExtendedSetDesc



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_COMMITMENTITEM_OBJP",
"C_SETLEAF",
"I_FUNDSMGMTEMPTYSET",
"I_FUNDSMGMTEMPTYSETTEXT",
"I_SETHEADER",
"I_SETHEADERTEXT",
"I_SETLEAF"
],
"ASSOCIATED":
[
"C_COMMITMENTITEM_OBJP",
"C_SETLEAF",
"I_FUNDSMGMTEMPTYSET",
"I_SETHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/