C_FunctionalAreaParentGroups

DDL: C_FUNCTIONALAREAPARENTGROUPS SQL: CFUNCAREAPRNTGRP Type: view CONSUMPTION
10 Fields 1 Data Sources 1 Associations

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.

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 Set Line
KEY SetClass I_Setnode SetClass Set Class
KEY SetID I_Setnode SetID Parent Group
KEY SetSubClass I_Setnode SetSubClass Subclass
ChildSetSubClass I_Setnode ChildSetSubClass Subset Subclass
ChildSetClass I_Setnode ChildSetClass Subset Class
ChildSetID I_Setnode ChildSetID Subset ID
CreatedByUser _header CreatedByUser Created By
CreationDate _header CreationDate Created On
SetDescription Parent Group Description

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FunctionalAreaParentGroups.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFUNCAREAPRNTGRP

CREATE VIEW C_FunctionalAreaParentGroups AS
SELECT
  I_Setnode.SetLineNumber AS SetLineNumber,
  I_Setnode.SetClass AS SetClass,
  I_Setnode.SetID AS SetID,
  I_Setnode.SetSubClass AS SetSubClass,
  I_Setnode.ChildSetSubClass AS ChildSetSubClass,
  I_Setnode.ChildSetClass AS ChildSetClass,
  I_Setnode.ChildSetID AS ChildSetID,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationDate AS CreationDate,
  _header._SetHeaderText[1:Language=$session.system_language].SetDescription AS SetDescription
FROM I_Setnode
LEFT OUTER JOIN I_SetHeader AS _header ON SetSubClass = _header.SetSubClass AND SetClass = _header.SetClass AND SetID = _header.SetID  -- association [0..1]
;

Learn More