C_FunctionalAreaParentGroups

DDL: C_FUNCTIONALAREAPARENTGROUPS SQL: CFUNCAREAPRNTGRP Type: view CONSUMPTION

Functional Area Parent Groups

C_FunctionalAreaParentGroups is a Consumption CDS View that provides data about "Functional Area Parent Groups" in SAP S/4HANA. It reads from 1 data source (I_Setnode) and exposes 10 fields with key fields SetLineNumber, SetClass, SetID, SetSubClass. 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.SetSubClass = _header.SetSubClass and $projection.SetClass = _header.SetClass and $projection.SetID = _header.SetID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CFUNCAREAPRNTGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Functional Area Parent 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 SetLineNumber I_Setnode SetLineNumber
KEY SetClass I_Setnode SetClass
KEY SetID I_Setnode SetID Parent Group
KEY SetSubClass I_Setnode SetSubClass
ChildSetSubClass I_Setnode ChildSetSubClass
ChildSetClass I_Setnode ChildSetClass
ChildSetID I_Setnode ChildSetID
CreatedByUser _header CreatedByUser Created By
CreationDate _header CreationDate Created On
SetDescription Parent Group Description 
@AbapCatalog.sqlViewName: 'CFUNCAREAPRNTGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:  #CHECK
@EndUserText.label: 'Functional Area Parent Groups'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@VDM.viewType: #CONSUMPTION
define view C_FunctionalAreaParentGroups
  as select from I_Setnode
  
  association [0..1] to I_SetHeader as _header on  $projection.SetSubClass = _header.SetSubClass
                                               and $projection.SetClass    = _header.SetClass
                                               and $projection.SetID       = _header.SetID
{
      @Consumption.hidden: true
  key I_Setnode.SetLineNumber,
      @Consumption.hidden: true
  key I_Setnode.SetClass         as SetClass,
      @EndUserText.label: 'Parent Group'
      @EndUserText.quickInfo:'Functional Area Group'
  key I_Setnode.SetID            as SetID,
      @Consumption.hidden: true
  key I_Setnode.SetSubClass      as SetSubClass,
      @Consumption.hidden: true
      I_Setnode.ChildSetSubClass as ChildSetSubClass,
      @Consumption.hidden: true
      I_Setnode.ChildSetClass    as ChildSetClass,
      @Consumption.hidden: true
      I_Setnode.ChildSetID       as ChildSetID,

      @EndUserText.label: 'Created By'
      _header.CreatedByUser      as CreatedByUser,
      @EndUserText.label: 'Created On'
      _header.CreationDate       as CreationDate,
      @EndUserText.label: 'Parent 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