C_CommitmentItemGroup_Objp

@AbapCatalog.sqlViewName:'CCOMMITITEMGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.semanticKey: 'CommitmentItemGroup'
@EndUserText.label: 'CommitmentItem Group'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #CONSUMPTION
//@OData.publish: true

@UI.headerInfo: {
    typeName: 'Commitment Item Group',    ---- App name (mandatory)
    typeNamePlural: 'Commitment Item Groups',   ---- App name plural (mandatory)
    
    title: {
        value:'CommitmentItemGroup'      ---- Title of the App
    },
    
    description: {
        value:'CommitmentItemName'  ---- Description of the App
    }
}

define view C_CommitmentItemGroup_Objp as select from  I_SetHeader
association [0..*] to C_CommitmentItemChildGroups as _Child   on  $projection.SetClass      = _Child.SetClass
                                                and $projection.SetSubClass  = _Child.SetSubClass
                                                and $projection.CommitmentItemGroup   = _Child.SetID
association [0..*] to C_CommitmentItemParentGroups as _Parent  on  $projection.SetClass      = _Parent.ChildSetClass
                                                and $projection.SetSubClass  = _Parent.ChildSetSubClass
                                                and $projection.CommitmentItemGroup  = _Parent.ChildSetID  
                                                
association [0..*] to C_SetleafForCommitmentItemGrp as _CommitmentItem on $projection.SetClass = _CommitmentItem.SetClass
                                                           and $projection.CommitmentItemGroup = _CommitmentItem.SetID
                                                           and $projection.SetSubClass = _CommitmentItem.SetSubClass 
                                                           
association [1..1] to I_FinancialManagementArea      as _FinMgmtArea              on  $projection.SetSubClass = _FinMgmtArea.FinancialManagementArea                                                           
                                                           //and commitmentItem.SetRangeOption = 'EQ'                                                                                        

{
   
    @UI.hidden: true 
                                              
   key I_SetHeader.SetClass as SetClass,
   @UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH, position: 10} }
    @UI.lineItem: [{
             position: 10,
             importance: #HIGH }]
   @EndUserText.label: 'Financial Management Area'  
   @EndUserText.quickInfo:'Financial Management Area'  
   key I_SetHeader.SetSubClass as SetSubClass,
   //@UI:{ fieldGroup: {qualifier: 'Organization', importance: #HIGH} } 

   @EndUserText.label: 'Commitment Item Group'
   key I_SetHeader.SetID as CommitmentItemGroup,
   @UI:{ fieldGroup: {qualifier: 'Administrative Data', importance: #HIGH} } 
   @EndUserText.label: 'Created By'
   @UI.lineItem: [{
             position: 50,
             importance: #HIGH }]
   I_SetHeader.CreatedByUser as CreatedByUser,
   @UI:{ fieldGroup: {qualifier: 'Administrative Data', importance: #HIGH} } 
   @EndUserText.label: 'Created On'
   @UI.lineItem: [{
             position: 40,
             importance: #HIGH }]
   I_SetHeader.CreationDate as CreationDate,
   @UI.hidden: true
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} } 

   @EndUserText.label: 'Created At'
   I_SetHeader.CreationTime as CreationTime,
   //@UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH} } 

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

   @EndUserText.label: 'Commitment Item Group Description'
   @UI.lineItem: [{
             position: 30,
             importance: #HIGH }]
   @EndUserText.quickInfo:'Commitment Item Group Description'
   I_SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription,
   @UI:{ fieldGroup: {qualifier: 'General Information', importance: #HIGH, position: 20} } 
   @EndUserText.label: 'Financial Management Area Text'
   _FinMgmtArea._Text[1:Language=$session.system_language].FinancialManagementAreaName as FinancialManagementAreaName,   
   _Child,   
   _Parent,
   _CommitmentItem
   // _FinMgmtArea

   
}where I_SetHeader.SetClass = '0311' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALMANAGEMENTAREA",
"I_FINANCIALMANAGEMENTAREATEXT",
"I_SETHEADER",
"I_SETHEADERTEXT"
],
"ASSOCIATED":
[
"C_COMMITMENTITEMCHILDGROUPS",
"C_COMMITMENTITEMPARENTGROUPS",
"C_SETLEAFFORCOMMITMENTITEMGRP",
"I_FINANCIALMANAGEMENTAREA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/