C_Setleafforfundedprogramgrp

DDL: C_SETLEAFFORFUNDEDPROGRAMGRP SQL: CSETFUNDEDGRP Type: view CONSUMPTION
27 Fields 1 Data Sources 3 Associations

Funded Program Set leaf

C_Setleafforfundedprogramgrp is a Consumption CDS View that provides data about "Funded Program 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, FundedProgram. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FundedProgram _FundedProgram $projection.SetSubClass = _FundedProgram.FinancialManagementArea and ( _FundedProgram.FundedProgram 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
AbapCatalog.sqlViewName CSETFUNDEDGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Funded Program Set leaf view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION 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 FundedProgram _FundedProgram FundedProgram Funded Program
FundedProgramName Funded Program Name
ValidityStartDate _FundedProgram ValidityStartDate Valid From
ValidityEndDate _FundedProgram ValidityEndDate Valid To
FundedProgramExpirationDate _FundedProgram FundedProgramExpirationDate Expiration Date
CreatedByUser _FundedProgram CreatedByUser Created By
CreationDate _FundedProgram CreationDate Created On
CreationTime _FundedProgram CreationTime Created At
FinancialManagementArea _FundedProgram FinancialManagementArea Financial Management Area
FinancialManagementAreaName Financial Management Area Text
FundedPgmFinMgmtAreaForAuthzn _FundedProgram FundedPgmFinMgmtAreaForAuthzn Authorization Group
FundedProgramType _FundedProgram FundedProgramType Funded Program Type
FundedProgramTypeName Funded Program Type Name
LastChangeDate _FundedProgram LastChangeDate Changed On
LastChangedByUser _FundedProgram LastChangedByUser Changed By
LastChangeTime _FundedProgram LastChangeTime Changed At
FundedProgramAuthznGrp _FundedProgram FundedProgramAuthznGrp
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

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_Setleafforfundedprogramgrp.
-- 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: CSETFUNDEDGRP

CREATE VIEW C_Setleafforfundedprogramgrp AS
SELECT
  SetClass,
  SetSubClass,
  SetID,
  SetLineNumber,
  _FundedProgram.FundedProgram AS FundedProgram,
  _FundedProgram._Text[1:Language=$session.system_language].FundedProgramName AS FundedProgramName,
  _FundedProgram.ValidityStartDate AS ValidityStartDate,
  _FundedProgram.ValidityEndDate AS ValidityEndDate,
  _FundedProgram.FundedProgramExpirationDate AS FundedProgramExpirationDate,
  _FundedProgram.CreatedByUser AS CreatedByUser,
  _FundedProgram.CreationDate AS CreationDate,
  _FundedProgram.CreationTime AS CreationTime,
  _FundedProgram.FinancialManagementArea AS FinancialManagementArea,
  _FundedProgram._FinMgmtArea._Text[1:Language=$session.system_language].FinancialManagementAreaName AS FinancialManagementAreaName,
  _FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  _FundedProgram.FundedProgramType AS FundedProgramType,
  _FundedProgram._FundedProgramType._Text[1:Language=$session.system_language].FundedProgramTypeName AS FundedProgramTypeName,
  _FundedProgram.LastChangeDate AS LastChangeDate,
  _FundedProgram.LastChangedByUser AS LastChangedByUser,
  _FundedProgram.LastChangeTime AS LastChangeTime,
  _FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  SetRangeSign,
  I_Setleaf.SetRangeOption AS SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _setleaf.SetRangeFromValue AS ValidFrom,
  _setleaf.SetRangeToValue AS ValidTo
FROM I_Setleaf
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON SetSubClass = _FundedProgram.FinancialManagementArea AND ( _FundedProgram.FundedProgram 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