C_SetleafForBudgetPeriodGrp

DDL: C_SETLEAFFORBUDGETPERIODGRP SQL: CSETLEAFBPGRP Type: view CONSUMPTION

Setleaf for BudgetPeriodGrp

C_SetleafForBudgetPeriodGrp is a Consumption CDS View that provides data about "Setleaf for BudgetPeriodGrp" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 19 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, BudgetPeriod. It has 4 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _SetHeader $projection.SetClass = _SetHeader.SetClass and $projection.SetSubClass = _SetHeader.SetSubClass and $projection.SetID = _SetHeader.SetID
[0..*] C_BudgetPeriod_ObjP _BudgetPeriod ( _BudgetPeriod.BudgetPeriod 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 CSETLEAFBPGRP view
AbapCatalog.compiler.compareFilter true 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
EndUserText.label Setleaf for BudgetPeriodGrp view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass
KEY SetID SetID Budget Period Group
KEY SetLineNumber SetLineNumber
KEY BudgetPeriod _BudgetPeriod BudgetPeriod Budget Period
BudgetPeriodNameendasBudgetPeriodName Budget Period Name
CreatedByUser _BudgetPeriod CreatedByUser Created By
CreationDate _BudgetPeriod CreationDate Created On
ValidityStartDate _BudgetPeriod ValidityStartDate Valid From
ValidityEndDate _BudgetPeriod ValidityEndDate Valid To
BudgetPeriodAuthznGrp _BudgetPeriod BudgetPeriodAuthznGrp Authorization Group
BudgetPeriodExpirationDate _BudgetPeriod BudgetPeriodExpirationDate Expiration Date
BudgetPeriodReversalDate _BudgetPeriod BudgetPeriodReversalDate Reversal Date
SetRangeSign SetRangeSign
SetRangeOption I_Setleaf SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
ValidFrom _setleaf SetRangeFromValue Range From
ValidTo _setleaf SetRangeToValue Range To 
@AbapCatalog.sqlViewName: 'CSETLEAFBPGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Setleaf for BudgetPeriodGrp'
@VDM.viewType: #CONSUMPTION
define view C_SetleafForBudgetPeriodGrp
  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_BudgetPeriod_ObjP as _BudgetPeriod on  (
      _BudgetPeriod.BudgetPeriod 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:'Budget Period Group'
      @Consumption.semanticObject:'BudgetPeriodGroup'
      @UI.hidden: true
  key SetID,
      @Consumption.hidden: true
  key SetLineNumber,
      @EndUserText.label:'Budget Period'
      @Consumption.semanticObject:'BudgetPeriod'
  key _BudgetPeriod.BudgetPeriod,
      @EndUserText.label:'Budget Period Name'
      case when _BudgetPeriod.BudgetPeriod is null then
         _EmptySet._Text[1:Language = $session.system_language].FundsMgmtEmptySetDescription
      else
         _BudgetPeriod.BudgetPeriodName
       end                       as BudgetPeriodName,
      @EndUserText.label:'Created By'
      _BudgetPeriod.CreatedByUser,
      @EndUserText.label:'Created On'
      _BudgetPeriod.CreationDate,
      @EndUserText.label:'Valid From'
      _BudgetPeriod.ValidityStartDate,
      @EndUserText.label:'Valid To'
      _BudgetPeriod.ValidityEndDate,
      @EndUserText.label:'Authorization Group'
      _BudgetPeriod.BudgetPeriodAuthznGrp,
      @EndUserText.label:'Expiration Date'
      _BudgetPeriod.BudgetPeriodExpirationDate,
      @EndUserText.label:'Reversal Date'
      _BudgetPeriod.BudgetPeriodReversalDate,   
      @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

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

Learn More