C_SetLeafForCIObjP

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_SetLeafForCIObjP.
-- 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: CSLEAFCIOBJP

CREATE VIEW C_SetLeafForCIObjP AS
SELECT
  SetClass,
  SetSubClass,
  SetID AS CommitmentItemGroup,
  SetLineNumber,
  _CommitmentItem.CommitmentItem AS CommitmentItem,
  SetRangeSign,
  SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _CommitmentItemGroup.CreatedByUser AS CreatedByUser,
  _CommitmentItemGroup.CreationDate AS CreationDate,
  _CommitmentItem.FinancialManagementArea AS FinancialManagementArea,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  _CommitmentItemGroup.SetDescription AS SetDescription
FROM I_Setleaf
LEFT OUTER JOIN I_SetHeader AS _SetHeader ON SetClass = _SetHeader.SetClass AND SetSubClass = _SetHeader.SetSubClass AND CommitmentItemGroup = _SetHeader.SetID  -- association [0..1]
LEFT OUTER JOIN C_CommitmentItem_ObjP AS _CommitmentItem ON SetSubClass = _CommitmentItem.FinancialManagementArea AND ( _CommitmentItem.CommitmentItem between SetRangeFromValue AND SetRangeToValue )  -- association [0..*]
LEFT OUTER JOIN C_CommitmentItemGroup_Objp AS _CommitmentItemGroup ON CommitmentItemGroup = _CommitmentItemGroup.CommitmentItemGroup AND _CommitmentItemGroup.SetClass = '0311' AND SetSubClass = _CommitmentItemGroup.SetSubClass  -- association [0..*]
;