C_Setleafforfundedprgmobjp

DDL: C_SETLEAFFORFUNDEDPRGMOBJP SQL: CSETFUNDEDPRGOBJ Type: view CONSUMPTION

Set leaf for Funded Program

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

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_FundedProgram_ObjP _FundedProgram $projection.SetSubClass = _FundedProgram.FinancialManagementArea and ( _FundedProgram.FundedProgram between $projection.SetRangeFromValue and $projection.SetRangeToValue )
[0..1] C_Fundedprogramgrp_Objp _FundedProgramGroup $projection.FundedProgramGroup = _FundedProgramGroup.FundedProgramGroup and _FundedProgramGroup.SetClass = '0315' and $projection.SetSubClass = _FundedProgramGroup.SetSubClass

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
EndUserText.label Set leaf for Funded Program view
AbapCatalog.sqlViewName CSETFUNDEDPRGOBJ view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Funded Program Group view
UI.headerInfo.typeNamePlural Funded Program Groups view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass Financial Management Area
KEY FundedProgramGroup SetID Group ID
KEY SetLineNumber SetLineNumber
KEY FundedProgram _FundedProgram FundedProgram
SetRangeSign SetRangeSign
SetRangeOption SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
CreatedByUser _FundedProgramGroup CreatedByUser Created By
CreationDate _FundedProgramGroup CreationDate Creation Date
SetDescription _FundedProgramGroup SetDescription Group Description
FinancialManagementArea _FundedProgram FinancialManagementArea
FundedPgmFinMgmtAreaForAuthzn _FundedProgram FundedPgmFinMgmtAreaForAuthzn
FundedProgramAuthznGrp _FundedProgram FundedProgramAuthznGrp 
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Set leaf for Funded Program'
@AbapCatalog.sqlViewName: 'CSETFUNDEDPRGOBJ'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@UI.headerInfo: {
  typeName: 'Funded Program Group',
  typeNamePlural: 'Funded Program Groups'
}
define view C_Setleafforfundedprgmobjp
  as select from I_Setleaf

  association [0..*] to C_FundedProgram_ObjP    as _FundedProgram      on  $projection.SetSubClass     = _FundedProgram.FinancialManagementArea
                                                                       and (
                                                                          _FundedProgram.FundedProgram between $projection.SetRangeFromValue and $projection.SetRangeToValue
                                                                        )

  association [0..1] to C_Fundedprogramgrp_Objp as _FundedProgramGroup on  $projection.FundedProgramGroup = _FundedProgramGroup.FundedProgramGroup
                                                                       and _FundedProgramGroup.SetClass   = '0315'
                                                                       and $projection.SetSubClass        = _FundedProgramGroup.SetSubClass
{
      @Consumption.hidden: true
  key SetClass,
      @EndUserText.label:'Financial Management Area'
  key SetSubClass,
      @EndUserText.label:'Group ID'
      @Consumption.semanticObject:'FundedProgramGroup'
  key SetID as FundedProgramGroup,
      @Consumption.hidden: true
  key SetLineNumber,

  key _FundedProgram.FundedProgram,
      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden: true
      SetRangeOption,
      @Consumption.hidden: true
      SetRangeFromValue,
      @Consumption.hidden: true
      SetRangeToValue,

      //meta

      @EndUserText.label:'Created By'
      _FundedProgramGroup.CreatedByUser,
      @EndUserText.label:'Creation Date'
      _FundedProgramGroup.CreationDate,


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

      _FundedProgramGroup.SetDescription,

      @Consumption.hidden: true 
      _FundedProgram.FinancialManagementArea,
      _FundedProgram.FundedPgmFinMgmtAreaForAuthzn,
      _FundedProgram.FundedProgramAuthznGrp

      // @Consumption.hidden: true

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



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

Learn More