C_Setleafforfaobjp

DDL: C_SETLEAFFORFAOBJP SQL: CSTLFFAOBJP Type: view CONSUMPTION

Setleaf For Functional Area Object Pages

C_Setleafforfaobjp is a Consumption CDS View that provides data about "Setleaf For Functional Area Object Pages" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 11 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _SetHeader $projection.SetClass = _SetHeader.SetClass and $projection.SetSubClass = _SetHeader.SetSubClass and $projection.SetID = _SetHeader.SetID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSTLFFAOBJP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Setleaf For Functional Area Object Pages view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass
KEY SetID SetID Functional Area Group
KEY SetLineNumber SetLineNumber
SetRangeSign SetRangeSign
SetRangeOption SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
CreatedByUser _SetHeader CreatedByUser Created By
CreationDate _SetHeader CreationDate Creation Date
SetDescription Group Description 
@AbapCatalog.sqlViewName: 'CSTLFFAOBJP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Setleaf For Functional Area Object Pages'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XL

define view C_Setleafforfaobjp 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_Setleafforfunctionalareagrp as _FunctionalArea on $projection.setid = _FunctionalArea.FunctionalArea

                                                                          // and $projection.SetClass = _FunctionalArea.SetClass

                                                                           //and $projection.SetSubClass = _FunctionalArea.SetSubClass

                                                                          
                                                                            
                                                               
                                                                                                          
{
      @Consumption.hidden: true
  key SetClass,
      @Consumption.hidden: true
  key SetSubClass,
      @EndUserText.label:'Functional Area Group'
      @Consumption.semanticObject:'FunctionalAreaGroup'     
 key SetID,
 //key _FunctionalArea.SetID,

//@UI.hidden: true

     // _FunctionalArea.FunctionalArea,

      @Consumption.hidden: true
  key SetLineNumber,
      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden: true
      SetRangeOption,
      @UI.hidden: true
      SetRangeFromValue,
      @UI.hidden: true
      SetRangeToValue,
      //_FunctionalArea

      

      //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
      //_SetHeader.SetDescription


      //@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":
[
"I_SETHEADER",
"I_SETHEADERTEXT",
"I_SETLEAF"
],
"ASSOCIATED":
[
"I_SETHEADER"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More