C_Setleaf

DDL: C_SETLEAF SQL: CSETLEAF Type: view CONSUMPTION
9 Fields 1 Data Sources

setleaf for groups

C_Setleaf is a Consumption CDS View that provides data about "setleaf for groups" in SAP S/4HANA. It reads from 1 data source (I_Setleaf) and exposes 9 fields with key fields SetClass, SetSubClass, SetID, SetLineNumber.

Data Sources (1)

SourceAliasJoin Type
I_Setleaf I_Setleaf from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSETLEAF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label setleaf for groups 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 (9)

KeyFieldSource TableSource FieldDescription
KEY SetClass I_Setleaf SetClass Set Class
KEY SetSubClass I_Setleaf SetSubClass Subclass
KEY SetID I_Setleaf SetID SETID
KEY SetLineNumber I_Setleaf SetLineNumber Set Line
SetRangeSign I_Setleaf SetRangeSign SIGN
SetRangeOption I_Setleaf SetRangeOption Option
SetRangeFromValueendasSetRangeFromValue
SetRangeToValueendasSetRangeToValue
SetLineSequenceNumber I_Setleaf SetLineSequenceNumber Tank ID

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_Setleaf.
-- 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: CSETLEAF

CREATE VIEW C_Setleaf AS
SELECT
  I_Setleaf.SetClass AS SetClass,
  I_Setleaf.SetSubClass AS SetSubClass,
  I_Setleaf.SetID AS SetID,
  I_Setleaf.SetLineNumber AS SetLineNumber,
  I_Setleaf.SetRangeSign AS SetRangeSign,
  I_Setleaf.SetRangeOption AS SetRangeOption,
  case when I_Setleaf.SetRangeFromValue = I_Setleaf.SetRangeToValue then '' else I_Setleaf.SetRangeFromValue end as SetRangeFromValue AS SetRangeFromValueendasSetRangeFromValue,
  case when I_Setleaf.SetRangeFromValue = I_Setleaf.SetRangeToValue then '' else I_Setleaf.SetRangeToValue end as SetRangeToValue AS SetRangeToValueendasSetRangeToValue,
  I_Setleaf.SetLineSequenceNumber AS SetLineSequenceNumber
FROM I_Setleaf
;

Learn More