C_SetleafForCommitmentItemGrp

DDL: C_SETLEAFFORCOMMITMENTITEMGRP SQL: CSETLEAFCMTGRP Type: view CONSUMPTION
28 Fields 1 Data Sources 4 Associations

Setleaf For Commitment Item Group

C_SetleafForCommitmentItemGrp is a Consumption CDS View that provides data about "Setleaf For Commitment Item Group" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 28 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber, CommitmentItem. 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_CommitmentItem_ObjP _Commitment $projection.SetSubClass = _Commitment.FinancialManagementArea and ( _Commitment.CommitmentItem 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
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName CSETLEAFCMTGRP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Setleaf For Commitment Item Group view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass Set Class
KEY SetSubClass SetSubClass Subclass
KEY SetID SetID Commitment Item Group
KEY SetLineNumber SetLineNumber Set Line
KEY CommitmentItem _Commitment CommitmentItem Commitmet Item
KEY FinancialManagementArea _Commitment FinancialManagementArea Financial Management Area
CreatedByUser _Commitment CreatedByUser Created By
CreationDate _Commitment CreationDate Created On
ValidityStartDate _Commitment ValidityStartDate Valid From
ValidityEndDate _Commitment ValidityEndDate Valid To
CommitmentItemCategory _Commitment CommitmentItemCategory Item category
FinancialManagementAreaName _Commitment FinancialManagementAreaName Financial Management Area Text
FinMgmtAreaFiscalYear _Commitment FinMgmtAreaFiscalYear Fiscal Year
CmtmtItmFinancialTransaction _Commitment CmtmtItmFinancialTransaction Financial Transaction
FinMgmtAreaFiscalYearVariant _Commitment FinMgmtAreaFiscalYearVariant Fiscal Year Varient
FundsCenterName _Commitment FundsCenterName Funds Center Name
CmtmtItmDefaultFundsCenter _Commitment CmtmtItmDefaultFundsCenter Default Funds Center
FundsCenterDescription _Commitment FundsCenterDescription Funds Center Description
CommitmentItemExpirationDate _Commitment CommitmentItemExpirationDate Expiration Date
CommitmentItemAuthznGrp _Commitment CommitmentItemAuthznGrp
CmtmtItemFinMgmtAreaForAuthzn _Commitment CmtmtItemFinMgmtAreaForAuthzn
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
SetDescription Commitment Item Group Name

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_SetleafForCommitmentItemGrp.
-- 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: CSETLEAFCMTGRP

CREATE VIEW C_SetleafForCommitmentItemGrp AS
SELECT
  SetClass,
  SetSubClass,
  SetID,
  SetLineNumber,
  _Commitment.CommitmentItem AS CommitmentItem,
  _Commitment.FinancialManagementArea AS FinancialManagementArea,
  _Commitment.CreatedByUser AS CreatedByUser,
  _Commitment.CreationDate AS CreationDate,
  _Commitment.ValidityStartDate AS ValidityStartDate,
  _Commitment.ValidityEndDate AS ValidityEndDate,
  _Commitment.CommitmentItemCategory AS CommitmentItemCategory,
  _Commitment.FinancialManagementAreaName AS FinancialManagementAreaName,
  _Commitment.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  _Commitment.CmtmtItmFinancialTransaction AS CmtmtItmFinancialTransaction,
  _Commitment.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  _Commitment.FundsCenterName AS FundsCenterName,
  _Commitment.CmtmtItmDefaultFundsCenter AS CmtmtItmDefaultFundsCenter,
  _Commitment.FundsCenterDescription AS FundsCenterDescription,
  _Commitment.CommitmentItemExpirationDate AS CommitmentItemExpirationDate,
  _Commitment.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _Commitment.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  SetRangeSign,
  I_Setleaf.SetRangeOption AS SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _setleaf.SetRangeFromValue AS ValidFrom,
  _setleaf.SetRangeToValue AS ValidTo,
  _SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription AS SetDescription
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_CommitmentItem_ObjP AS _Commitment ON SetSubClass = _Commitment.FinancialManagementArea AND ( _Commitment.CommitmentItem 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