C_SetLeafForCIObjP

DDL: C_SETLEAFFORCIOBJP SQL: CSLEAFCIOBJP Type: view CONSUMPTION

Set Leaf for Commitment Item

C_SetLeafForCIObjP is a Consumption CDS View that provides data about "Set Leaf for Commitment Item" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 15 fields with key fields SetClass, SetSubClass, CommitmentItemGroup, SetLineNumber, CommitmentItem. It has 3 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SetHeader _SetHeader $projection.SetClass = _SetHeader.SetClass and $projection.SetSubClass = _SetHeader.SetSubClass and $projection.CommitmentItemGroup = _SetHeader.SetID
[0..*] C_CommitmentItem_ObjP _CommitmentItem $projection.SetSubClass = _CommitmentItem.FinancialManagementArea and ( _CommitmentItem.CommitmentItem between $projection.SetRangeFromValue and $projection.SetRangeToValue )
[0..*] C_CommitmentItemGroup_Objp _CommitmentItemGroup $projection.CommitmentItemGroup = _CommitmentItemGroup.CommitmentItemGroup and _CommitmentItemGroup.SetClass = '0311' and $projection.SetSubClass = _CommitmentItemGroup.SetSubClass

Annotations (11)

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 CSLEAFCIOBJP view
AbapCatalog.compiler.compareFilter true view
UI.headerInfo.typeName Commitment Item Group view
UI.headerInfo.typeNamePlural Commitment Item Groups view
EndUserText.label Set Leaf for Commitment Item view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SetClass SetClass
KEY SetSubClass SetSubClass Financial Management Area
KEY CommitmentItemGroup SetID Commitment Item Group
KEY SetLineNumber SetLineNumber
KEY CommitmentItem _CommitmentItem CommitmentItem
SetRangeSign SetRangeSign
SetRangeOption SetRangeOption
SetRangeFromValue SetRangeFromValue
SetRangeToValue SetRangeToValue
CreatedByUser _CommitmentItemGroup CreatedByUser Created By
CreationDate _CommitmentItemGroup CreationDate Creation Date
FinancialManagementArea _CommitmentItem FinancialManagementArea
CommitmentItemAuthznGrp _CommitmentItem CommitmentItemAuthznGrp
CmtmtItemFinMgmtAreaForAuthzn _CommitmentItem CmtmtItemFinMgmtAreaForAuthzn
SetDescription _CommitmentItemGroup SetDescription Group Description 
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.sqlViewName: 'CSLEAFCIOBJP'
@AbapCatalog.compiler.compareFilter: true

@UI.headerInfo: {
  typeName: 'Commitment Item Group',
  typeNamePlural: 'Commitment Item Groups'
}

@EndUserText.label: 'Set Leaf for Commitment Item'
define view C_SetLeafForCIObjP
  as select from I_Setleaf

  association [0..1] to I_SetHeader                as _SetHeader           on  $projection.SetClass    = _SetHeader.SetClass
                                                                           and $projection.SetSubClass = _SetHeader.SetSubClass
                                                                           and $projection.CommitmentItemGroup = _SetHeader.SetID

  association [0..*] to C_CommitmentItem_ObjP      as _CommitmentItem      on  $projection.SetSubClass       = _CommitmentItem.FinancialManagementArea
                                                                           and (
                                                                              _CommitmentItem.CommitmentItem between $projection.SetRangeFromValue and $projection.SetRangeToValue
                                                                            )

  association [0..*] to C_CommitmentItemGroup_Objp as _CommitmentItemGroup on  $projection.CommitmentItemGroup = _CommitmentItemGroup.CommitmentItemGroup
                                                                           and _CommitmentItemGroup.SetClass   = '0311'
                                                                           and $projection.SetSubClass         = _CommitmentItemGroup.SetSubClass
{
      @Consumption.hidden: true
  key SetClass,
      @UI.hidden: true
      @EndUserText.label:'Financial Management Area'
  key SetSubClass,
      @EndUserText.label:'Commitment Item Group'
      @Consumption.semanticObject:'CommitmentItemGroup'
  key SetID as CommitmentItemGroup,
      @Consumption.hidden: true
  key SetLineNumber,
      @UI.hidden: true
  key _CommitmentItem.CommitmentItem,

      @Consumption.hidden: true
      SetRangeSign,
      @Consumption.hidden: true
      SetRangeOption,
      @Consumption.hidden: true
      SetRangeFromValue,
      @Consumption.hidden: true
      SetRangeToValue,

      //meta

      @EndUserText.label:'Created By'
      _CommitmentItemGroup.CreatedByUser,
      @EndUserText.label:'Creation Date'
      _CommitmentItemGroup.CreationDate,

      @Consumption.hidden: true
      _CommitmentItem.FinancialManagementArea,
      @Consumption.hidden: true
      _CommitmentItem.CommitmentItemAuthznGrp,
      @Consumption.hidden: true
      _CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn,

      //Texts

      @EndUserText.label:'Group Description'
      _CommitmentItemGroup.SetDescription
      ///@Consumption.hidden: true

      //cast( concat_with_space(SetID, _SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription, 1 ) as fmis_fundsmgmtextendedsetname ) as  FundsMgmtExtendedSetDesc

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_COMMITMENTITEMGROUP_OBJP",
"C_COMMITMENTITEM_OBJP",
"I_SETLEAF"
],
"ASSOCIATED":
[
"C_COMMITMENTITEMGROUP_OBJP",
"C_COMMITMENTITEM_OBJP",
"I_SETHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More