C_SetleafForBudgetPeriodGrp

DDL: C_SETLEAFFORBUDGETPERIODGRP SQL: CSETLEAFBPGRP Type: view CONSUMPTION
19 Fields 1 Data Sources 4 Associations

Setleaf for BudgetPeriodGrp

C_SetleafForBudgetPeriodGrp is a Consumption CDS View that provides data about "Setleaf for BudgetPeriodGrp" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 19 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, BudgetPeriod. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _SetHeader $projection.SetClass = _SetHeader.SetClass and $projection.SetSubClass = _SetHeader.SetSubClass and $projection.SetID = _SetHeader.SetID
[0..*] C_BudgetPeriod_ObjP _BudgetPeriod ( _BudgetPeriod.BudgetPeriod 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 CSETLEAFBPGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Setleaf for BudgetPeriodGrp view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass Set Class
KEY SetSubClass SetSubClass Subclass
KEY SetID SetID Budget Period Group
KEY SetLineNumber SetLineNumber Set Line
KEY BudgetPeriod _BudgetPeriod BudgetPeriod Budget Period
BudgetPeriodNameendasBudgetPeriodName Budget Period Name
CreatedByUser _BudgetPeriod CreatedByUser Created By
CreationDate _BudgetPeriod CreationDate Created On
ValidityStartDate _BudgetPeriod ValidityStartDate Valid From
ValidityEndDate _BudgetPeriod ValidityEndDate Valid To
BudgetPeriodAuthznGrp _BudgetPeriod BudgetPeriodAuthznGrp Authorization Group
BudgetPeriodExpirationDate _BudgetPeriod BudgetPeriodExpirationDate Expiration Date
BudgetPeriodReversalDate _BudgetPeriod BudgetPeriodReversalDate Reversal Date
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_SetleafForBudgetPeriodGrp.
-- 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: CSETLEAFBPGRP

CREATE VIEW C_SetleafForBudgetPeriodGrp AS
SELECT
  SetClass,
  SetSubClass,
  SetID,
  SetLineNumber,
  _BudgetPeriod.BudgetPeriod AS BudgetPeriod,
  case when _BudgetPeriod.BudgetPeriod is null then _EmptySet._Text[1:Language = $session.system_language].FundsMgmtEmptySetDescription else _BudgetPeriod.BudgetPeriodName end as BudgetPeriodName AS BudgetPeriodNameendasBudgetPeriodName,
  _BudgetPeriod.CreatedByUser AS CreatedByUser,
  _BudgetPeriod.CreationDate AS CreationDate,
  _BudgetPeriod.ValidityStartDate AS ValidityStartDate,
  _BudgetPeriod.ValidityEndDate AS ValidityEndDate,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  _BudgetPeriod.BudgetPeriodExpirationDate AS BudgetPeriodExpirationDate,
  _BudgetPeriod.BudgetPeriodReversalDate AS BudgetPeriodReversalDate,
  SetRangeSign,
  I_Setleaf.SetRangeOption AS SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _setleaf.SetRangeFromValue AS ValidFrom,
  _setleaf.SetRangeToValue AS ValidTo
FROM I_Setleaf
LEFT OUTER JOIN I_SetHeader AS _SetHeader ON SetClass = _SetHeader.SetClass AND SetSubClass = _SetHeader.SetSubClass AND SetID = _SetHeader.SetID  -- association [0..1]
LEFT OUTER JOIN C_BudgetPeriod_ObjP AS _BudgetPeriod ON /* condition not available in parsed metadata */  -- 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