C_FunctionalAreaGroupIncluded

DDL: C_FUNCTIONALAREAGROUPINCLUDED SQL: CFAGRPINC Type: view CONSUMPTION

Functional Area Group Included

C_FunctionalAreaGroupIncluded is a Consumption CDS View that provides data about "Functional Area Group Included" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 13 fields with key fields SetClass, SetSubClass, FunctionalAreaGroup, SetLineNumber, FunctionalArea. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _SetHeader $projection.SetClass = _SetHeader.SetClass and $projection.SetSubClass = _SetHeader.SetSubClass and $projection.FunctionalAreaGroup = _SetHeader.SetID
[0..*] C_FundsMgmtFunctionalArea_ObjP _FunctionalArea ( _FunctionalArea.FunctionalArea between $projection.SetRangeFromValue and $projection.SetRangeToValue )
[0..1] C_Functionalareagroup_Objp _FunctionalAreaGroup $projection.FunctionalAreaGroup = _FunctionalAreaGroup.FunctionalAreaGroup and _FunctionalAreaGroup.SetClass = '0112'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CFAGRPINC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Area Group Included 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
UI.headerInfo.typeName Functional Area Group view
UI.headerInfo.typeNamePlural Functional Area Groups view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass
KEY FunctionalAreaGroup SetID Functional Area Group
KEY SetLineNumber SetLineNumber
KEY FunctionalArea _FunctionalArea FunctionalArea
SetRangeSign SetRangeSign
SetRangeOption SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
CreatedByUser _FunctionalAreaGroup CreatedByUser Created By
CreationDate _FunctionalAreaGroup CreationDate Creation Date
FunctionalAreaAuthznGrp _FunctionalArea FunctionalAreaAuthznGrp
SetDescription _FunctionalAreaGroup SetDescription Group Description 
@AbapCatalog.sqlViewName: 'CFAGRPINC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Functional Area Group Included'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.sizeCategory: #XL
@UI.headerInfo: {
  typeName: 'Functional Area Group',
  typeNamePlural: 'Functional Area Groups'
}
define view C_FunctionalAreaGroupIncluded
  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.FunctionalAreaGroup = _SetHeader.SetID

  association [0..*] to C_FundsMgmtFunctionalArea_ObjP as _FunctionalArea      on  (
           _FunctionalArea.FunctionalArea between $projection.SetRangeFromValue and $projection.SetRangeToValue
         )

  association [0..1] to C_Functionalareagroup_Objp     as _FunctionalAreaGroup on  $projection.FunctionalAreaGroup = _FunctionalAreaGroup.FunctionalAreaGroup
                                                                               and _FunctionalAreaGroup.SetClass   = '0112'

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

  key SetID as FunctionalAreaGroup,

      @Consumption.hidden: true
  key SetLineNumber,
      //@UI.hidden: true

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



      //meta

      @EndUserText.label:'Created By'
      _FunctionalAreaGroup.CreatedByUser,
      // _FA.CreatedByUser,

      @EndUserText.label:'Creation Date'
      _FunctionalAreaGroup.CreationDate,
      
      @UI.hidden: true
      _FunctionalArea.FunctionalAreaAuthznGrp,

      //Texts

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

      _FunctionalAreaGroup.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":
[
"C_FUNCTIONALAREAGROUP_OBJP",
"C_FUNDSMGMTFUNCTIONALAREA_OBJP",
"I_SETLEAF"
],
"ASSOCIATED":
[
"C_FUNCTIONALAREAGROUP_OBJP",
"C_FUNDSMGMTFUNCTIONALAREA_OBJP",
"I_SETHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More