C_BudgetPeriodGroup_Objp

DDL: C_BUDGETPERIODGROUP_OBJP SQL: CBUDGETPERIODGRP Type: view CONSUMPTION

Budget Period Group

C_BudgetPeriodGroup_Objp is a Consumption CDS View that provides data about "Budget Period Group" in SAP S/4HANA. It reads from 1 data source (I_SetHeader) and exposes 11 fields with key fields SetClass, SetSubClass, BudgetPeriodGroup. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SetHeader I_SetHeader from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_BudgetPeriodChildGroup _Child $projection.SetClass = _Child.SetClass and $projection.SetSubClass = _Child.SetSubClass and $projection.BudgetPeriodGroup = _Child.SetID
[0..*] C_BudgetPeriodParentGroup _Parent $projection.SetClass = _Parent.ChildSetClass and $projection.SetSubClass = _Parent.ChildSetSubClass and $projection.BudgetPeriodGroup = _Parent.ChildSetID
[0..*] C_SetleafForBudgetPeriodGrp _BudgetPeriod $projection.SetClass = _BudgetPeriod.SetClass and $projection.BudgetPeriodGroup = _BudgetPeriod.SetID and $projection.SetSubClass = _BudgetPeriod.SetSubClass

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBUDGETPERIODGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Budget Period Group view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Budget Period Group view
UI.headerInfo.typeNamePlural Budget Period Groups view
UI.headerInfo.title.value BudgetPeriodGroup view
UI.headerInfo.description.value SetDescription view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SetClass I_SetHeader SetClass
KEY SetSubClass I_SetHeader SetSubClass
KEY BudgetPeriodGroup I_SetHeader SetID Budget Period Group
CreatedByUser I_SetHeader CreatedByUser Created By
CreationDate I_SetHeader CreationDate Created On
CreationTime I_SetHeader CreationTime
SetType I_SetHeader SetType
SetDescription Budget Period Group Description
_Child _Child
_Parent _Parent
_BudgetPeriod _BudgetPeriod
@AbapCatalog.sqlViewName: 'CBUDGETPERIODGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Budget Period Group'
@ObjectModel.semanticKey: ['BudgetPeriodGroup']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #CONSUMPTION
@UI.headerInfo: {
    typeName: 'Budget Period Group',    ---- App name (mandatory)
    typeNamePlural: 'Budget Period Groups',   ---- App name plural (mandatory)
    
    title: {
        value:'BudgetPeriodGroup'      ---- Title of the App
    },
    
    description: {
        value:'SetDescription'  ---- Description of the App
    }
}
define view C_BudgetPeriodGroup_Objp as select from I_SetHeader
association [0..*] to C_BudgetPeriodChildGroup as _Child  on  $projection.SetClass      = _Child.SetClass
                                                and $projection.SetSubClass  = _Child.SetSubClass
                                                and $projection.BudgetPeriodGroup   = _Child.SetID
association [0..*] to C_BudgetPeriodParentGroup as _Parent  on  $projection.SetClass      = _Parent.ChildSetClass
                                                and $projection.SetSubClass  = _Parent.ChildSetSubClass
                                                and $projection.BudgetPeriodGroup   = _Parent.ChildSetID  
                                                
association [0..*] to C_SetleafForBudgetPeriodGrp as _BudgetPeriod on $projection.SetClass = _BudgetPeriod.SetClass
                                                           and $projection.BudgetPeriodGroup = _BudgetPeriod.SetID
                                                           and $projection.SetSubClass = _BudgetPeriod.SetSubClass 
                                                           ////and commitmentItem.SetRangeOption = 'EQ'                                                                                        

                                                {
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} }   

   @UI.hidden:true                                          
   key I_SetHeader.SetClass as SetClass,
  // @UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} }   

  @UI.hidden:true
   key I_SetHeader.SetSubClass as SetSubClass,
   //@UI:{ fieldGroup: {qualifier: 'Organization', importance: #HIGH} } 

   @EndUserText.label: 'Budget Period Group'
    @UI.lineItem: [{
             position: 10,
             importance: #HIGH }]
   @EndUserText.quickInfo:'Budget Period Group'            
   key I_SetHeader.SetID as BudgetPeriodGroup,
   @UI:{ fieldGroup: {qualifier: 'Administrative Data', importance: #HIGH} } 
   @EndUserText.label: 'Created By'
   @UI.lineItem: [{
             position: 40,
             importance: #HIGH }]
   I_SetHeader.CreatedByUser as CreatedByUser,
   @UI:{ fieldGroup: {qualifier: 'Administrative Data', importance: #HIGH} } 
   @EndUserText.label: 'Created On'
   @UI.lineItem: [{
             position: 30,
             importance: #HIGH }]
   @Consumption.filter.selectionType: #INTERVAL           
   I_SetHeader.CreationDate as CreationDate,
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} } 

   @UI.hidden:true
   I_SetHeader.CreationTime as CreationTime,
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} } 

   @UI.hidden:true
   I_SetHeader.SetType as SetType,
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} } 

   @EndUserText.label: 'Budget Period Group Description'
   @UI.lineItem: [{
             position: 20,
             importance: #HIGH }]
   @EndUserText.quickInfo:'Budget Period Group Description'          
   I_SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription,
    _Child,
    _Parent,
    _BudgetPeriod 
   
}where I_SetHeader.SetClass = '0114'   
  
  

  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SETHEADER",
"I_SETHEADERTEXT"
],
"ASSOCIATED":
[
"C_BUDGETPERIODCHILDGROUP",
"C_BUDGETPERIODPARENTGROUP",
"C_SETLEAFFORBUDGETPERIODGRP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/