C_Setleafforfundedprogramgrp

DDL: C_SETLEAFFORFUNDEDPROGRAMGRP SQL: CSETFUNDEDGRP Type: view CONSUMPTION

Funded Program Set leaf

C_Setleafforfundedprogramgrp is a Consumption CDS View that provides data about "Funded Program Set leaf" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 27 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, FundedProgram. It has 3 associations to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FundedProgram _FundedProgram $projection.SetSubClass = _FundedProgram.FinancialManagementArea and ( _FundedProgram.FundedProgram between $projection.SetRangeFromValue and $projection.SetRangeToValue )
[0..1] C_Setleaf _setleaf $projection.SetClass = _setleaf.SetClass and $projection.SetSubClass = _setleaf.SetSubClass and $projection.SetID = _setleaf.SetID and $projection.SetLineNumber = _setleaf.SetLineNumber
[0..1] I_FundsMgmtEmptySet _EmptySet $projection.SetRangeOption = _EmptySet.SetRangeOption

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSETFUNDEDGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Funded Program Set leaf 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 (27)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass
KEY SetID SetID Group ID
KEY SetLineNumber SetLineNumber
KEY FundedProgram _FundedProgram FundedProgram Funded Program
FundedProgramName Funded Program Name
ValidityStartDate _FundedProgram ValidityStartDate Valid From
ValidityEndDate _FundedProgram ValidityEndDate Valid To
FundedProgramExpirationDate _FundedProgram FundedProgramExpirationDate Expiration Date
CreatedByUser _FundedProgram CreatedByUser Created By
CreationDate _FundedProgram CreationDate Created On
CreationTime _FundedProgram CreationTime Created At
FinancialManagementArea _FundedProgram FinancialManagementArea Financial Management Area
FinancialManagementAreaName Financial Management Area Text
FundedPgmFinMgmtAreaForAuthzn _FundedProgram FundedPgmFinMgmtAreaForAuthzn Authorization Group
FundedProgramType _FundedProgram FundedProgramType Funded Program Type
FundedProgramTypeName Funded Program Type Name
LastChangeDate _FundedProgram LastChangeDate Changed On
LastChangedByUser _FundedProgram LastChangedByUser Changed By
LastChangeTime _FundedProgram LastChangeTime Changed At
FundedProgramAuthznGrp _FundedProgram FundedProgramAuthznGrp
SetRangeSign SetRangeSign
SetRangeOption I_Setleaf SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
ValidFrom _setleaf SetRangeFromValue Range From
ValidTo _setleaf SetRangeToValue Range To 
@AbapCatalog.sqlViewName: 'CSETFUNDEDGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Funded Program Set leaf'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION

define view C_Setleafforfundedprogramgrp
  as select from I_Setleaf

  association [0..*] to I_FundedProgram     as _FundedProgram on  $projection.SetSubClass     = _FundedProgram.FinancialManagementArea
                                                              and (
                                                                 _FundedProgram.FundedProgram 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

{
      @Consumption.hidden:true
  key SetClass,
      @Consumption.hidden:true
  key SetSubClass,
      @EndUserText.label:'Group ID'
      @Consumption.hidden:true
  key SetID,
      @Consumption.hidden:true
  key SetLineNumber,
      @EndUserText.label: 'Funded Program'
      @Consumption.semanticObject:'FundedProgram'
  key _FundedProgram.FundedProgram,
      @EndUserText.label: 'Funded Program Description'
      case when _FundedProgram.FundedProgram is null then
        _EmptySet._Text[1:Language = $session.system_language].FundsMgmtEmptySetDescription
      else
        _FundedProgram._Text[1:Language=$session.system_language].FundedProgramDescription
      end                        as FundedProgramDescription,

      @EndUserText.label: 'Funded Program Name'
      _FundedProgram._Text[1:Language=$session.system_language].FundedProgramName,
      @EndUserText.label: 'Valid From'
      _FundedProgram.ValidityStartDate,
      @EndUserText.label: 'Valid To'
      _FundedProgram.ValidityEndDate,
      @EndUserText.label: 'Expiration Date'
      _FundedProgram.FundedProgramExpirationDate,
      @EndUserText.label: 'Created By'
      _FundedProgram.CreatedByUser,
      @EndUserText.label: 'Created On'
      _FundedProgram.CreationDate,
      @EndUserText.label: 'Created At'
      _FundedProgram.CreationTime,
      @EndUserText.label:'Financial Management Area'
      _FundedProgram.FinancialManagementArea,
      @EndUserText.label: 'Financial Management Area Text'
      _FundedProgram._FinMgmtArea._Text[1:Language=$session.system_language].FinancialManagementAreaName,
      @EndUserText.label:'Authorization Group'
      _FundedProgram.FundedPgmFinMgmtAreaForAuthzn,
      @EndUserText.label:'Funded Program Type'
      _FundedProgram.FundedProgramType,
      @EndUserText.label: 'Funded Program Type Name'
      _FundedProgram._FundedProgramType._Text[1:Language=$session.system_language].FundedProgramTypeName,
      @EndUserText.label:'Changed On'
      _FundedProgram.LastChangeDate,
      @EndUserText.label:'Changed By'
      _FundedProgram.LastChangedByUser,
      @EndUserText.label:'Changed At'
      _FundedProgram.LastChangeTime,
      @Consumption.hidden:true
      _FundedProgram.FundedProgramAuthznGrp,
      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden:true
      I_Setleaf.SetRangeOption,
      @Consumption.hidden:true
      SetRangeFromValue,
      @Consumption.hidden:true
      SetRangeToValue,
      @EndUserText.label: 'Range From'
      _setleaf.SetRangeFromValue as ValidFrom,
      @EndUserText.label: 'Range To'
      _setleaf.SetRangeToValue   as ValidTo
      //_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_SETLEAF",
"I_FINANCIALMANAGEMENTAREA",
"I_FINANCIALMANAGEMENTAREATEXT",
"I_FUNDEDPROGRAM",
"I_FUNDEDPROGRAMTEXT",
"I_FUNDEDPROGRAMTYPE",
"I_FUNDEDPROGRAMTYPETEXT",
"I_FUNDSMGMTEMPTYSET",
"I_FUNDSMGMTEMPTYSETTEXT",
"I_SETLEAF"
],
"ASSOCIATED":
[
"C_SETLEAF",
"I_FUNDEDPROGRAM",
"I_FUNDSMGMTEMPTYSET"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More