C_FunctionalAreaChildGroups

DDL: C_FUNCTIONALAREACHILDGROUPS SQL: CFUNCAREACHLDGRP Type: view CONSUMPTION

Functional Area Child Groups

C_FunctionalAreaChildGroups is a Consumption CDS View that provides data about "Functional Area Child Groups" in SAP S/4HANA. It reads from 1 data source (I_Setnode) and exposes 10 fields with key fields SetClass, SetID, SetSubClass, SetLineNumber. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_Setnode I_Setnode from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _header $projection.ChildSetSubClass = _header.SetSubClass and $projection.ChildSetClass = _header.SetClass and $projection.ChildSetID = _header.SetID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CFUNCAREACHLDGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Area Child Groups view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SetClass I_Setnode SetClass
KEY SetID I_Setnode SetID
KEY SetSubClass I_Setnode SetSubClass
KEY SetLineNumber I_Setnode SetLineNumber
ChildSetSubClass I_Setnode ChildSetSubClass
ChildSetClass I_Setnode ChildSetClass
ChildSetID I_Setnode ChildSetID Child Group
CreatedByUser _header CreatedByUser Created By
CreationDate _header CreationDate Created On
SetDescription Child Group Description 
@AbapCatalog.sqlViewName: 'CFUNCAREACHLDGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:  #CHECK
@EndUserText.label: 'Functional Area Child Groups'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #CONSUMPTION
define view C_FunctionalAreaChildGroups
  as select from I_Setnode
  
  association [0..1] to I_SetHeader as _header on  $projection.ChildSetSubClass = _header.SetSubClass
                                               and $projection.ChildSetClass    = _header.SetClass
                                               and $projection.ChildSetID       = _header.SetID
{
      @UI.hidden:true
  key I_Setnode.SetClass                                                         as SetClass,
      @UI.hidden:true
  key I_Setnode.SetID                                                            as SetID,

      @UI.hidden:true
  key I_Setnode.SetSubClass                                                      as SetSubClass,
      @UI.hidden:true
  key I_Setnode.SetLineNumber,
      @UI.hidden:true
      I_Setnode.ChildSetSubClass                                                 as ChildSetSubClass,
      @UI.hidden:true
      I_Setnode.ChildSetClass                                                    as ChildSetClass,
      @EndUserText.label: 'Child Group'
      @EndUserText.quickInfo:'Functional Area Group'
      I_Setnode.ChildSetID                                                       as ChildSetID,
      @EndUserText.label: 'Created By'
      _header.CreatedByUser                                                      as CreatedByUser,
      @EndUserText.label: 'Created On'
      _header.CreationDate                                                       as CreationDate,
      @EndUserText.label: 'Child Group Description'
      @EndUserText.quickInfo:'Functional Area Group Description'
      _header._SetHeaderText[1:Language=$session.system_language].SetDescription
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SETHEADER",
"I_SETHEADERTEXT",
"I_SETNODE"
],
"ASSOCIATED":
[
"I_SETHEADER"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More