C_Setleafforfundgrp

DDL: C_SETLEAFFORFUNDGRP SQL: CSETLEAFFUNDGRP Type: view CONSUMPTION
27 Fields 1 Data Sources 3 Associations

Fund Group Set Leaf

C_Setleafforfundgrp is a Consumption CDS View that provides data about "Fund Group Set Leaf" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 27 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, Fund. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_Fund _Fund $projection.SetSubClass = _Fund.FinancialManagementArea and ( _Fund.Fund between $projection.SetRangeFromValue and $projection.SetRangeToValue )
[0..1] C_Setleaf _Setleaf $projection.SetClass = _Setleaf.SetClass and $projection.SetSubClass = _Setleaf.SetSubClass and $projection.SetID = _Setleaf.SetID and $projection.SetLineNumber = _Setleaf.SetLineNumber
[0..1] I_FundsMgmtEmptySet _EmptySet $projection.SetRangeOption = _EmptySet.SetRangeOption

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CSETLEAFFUNDGRP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Fund Group Set Leaf view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass Set Class
KEY SetSubClass SetSubClass Subclass
KEY SetID SetID Group ID
KEY SetLineNumber SetLineNumber Set Line
KEY Fund _Fund Fund Fund
FundName Fund Name
FundDescriptionendasFundDescription Fund Description
ValidityEndDate _Fund ValidityEndDate Valid To
ValidityStartDate _Fund ValidityStartDate Valid From
FundCreatedBy _Fund FundCreatedBy Created By
FundCreatedAt _Fund FundCreatedAt Created On
FinancialManagementArea _Fund FinancialManagementArea Financial Management Area
FinancialManagementAreaName Financial Management Area Text
FundType _Fund FundType Fund Type
FundTypeDescription Fund Type Description
ApplicationOfFunds _Fund ApplicationOfFunds Application of Funds
FundAuthznGrp _Fund FundAuthznGrp Authorization Group
LastChangeDate _Fund LastChangeDate Changed On
LastChangeUser _Fund LastChangeUser Changed By
FundFinMgmtAreaForAuthzn _Fund FundFinMgmtAreaForAuthzn
SetRangeSign SetRangeSign SIGN
SetRangeOption I_Setleaf SetRangeOption Option
SetRangeFromValue SetRangeFromValue Valid-From Date
SetRangeToValue SetRangeToValue Valid To
ValidFrom _Setleaf SetRangeFromValue Range From
ValidTo _Setleaf SetRangeToValue Range To
_Setleaf _Setleaf

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_Setleafforfundgrp.
-- 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: CSETLEAFFUNDGRP

CREATE VIEW C_Setleafforfundgrp AS
SELECT
  SetClass,
  SetSubClass,
  SetID,
  SetLineNumber,
  _Fund.Fund AS Fund,
  _Fund._Text[1:Language=$session.system_language].FundName AS FundName,
  case when _Fund.Fund is null then _EmptySet._Text[1:Language = $session.system_language].FundsMgmtEmptySetDescription else _Fund._Text[1:Language=$session.system_language].FundDescription end as FundDescription AS FundDescriptionendasFundDescription,
  _Fund.ValidityEndDate AS ValidityEndDate,
  _Fund.ValidityStartDate AS ValidityStartDate,
  _Fund.FundCreatedBy AS FundCreatedBy,
  _Fund.FundCreatedAt AS FundCreatedAt,
  _Fund.FinancialManagementArea AS FinancialManagementArea,
  _Fund._FinMgmtArea._Text[1:Language = $session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  _Fund.FundType AS FundType,
  _Fund._FundType._Text[1:Language = $session.system_language].FundTypeDescription AS FundTypeDescription,
  _Fund.ApplicationOfFunds AS ApplicationOfFunds,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _Fund.LastChangeDate AS LastChangeDate,
  _Fund.LastChangeUser AS LastChangeUser,
  _Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  SetRangeSign,
  I_Setleaf.SetRangeOption AS SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _Setleaf.SetRangeFromValue AS ValidFrom,
  _Setleaf.SetRangeToValue AS ValidTo
FROM I_Setleaf
LEFT OUTER JOIN I_Fund AS _Fund ON SetSubClass = _Fund.FinancialManagementArea AND ( _Fund.Fund between SetRangeFromValue AND SetRangeToValue )  -- association [0..*]
LEFT OUTER JOIN C_Setleaf AS _Setleaf ON SetClass = _Setleaf.SetClass AND SetSubClass = _Setleaf.SetSubClass AND SetID = _Setleaf.SetID AND SetLineNumber = _Setleaf.SetLineNumber  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtEmptySet AS _EmptySet ON SetRangeOption = _EmptySet.SetRangeOption  -- association [0..1]
;

Learn More