C_ParentGroup

DDL: C_PARENTGROUP SQL: CPARENTGRP Type: view CONSUMPTION

ParentGroup

C_ParentGroup is a Consumption CDS View that provides data about "ParentGroup" 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.

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 CPARENTGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label ParentGroup view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L 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: 'CPARENTGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@EndUserText.label: 'ParentGroup'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view C_ParentGroup 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' 
 @Consumption.semanticObject:'FundGroup'
 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' 
  _header._SetHeaderText[1:Language=$session.system_language].SetDescription
} 
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SETHEADER",
"I_SETHEADERTEXT",
"I_SETNODE"
],
"ASSOCIATED":
[
"I_SETHEADER"
],
"BASE":
[],
"VERSION":0
}
}*/