C_SetLeafForGrantObjP

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_SetLeafForGrantObjP.
-- 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: CSLEAFGRANTOBJP

CREATE VIEW C_SetLeafForGrantObjP AS
SELECT
  SetClass,
  SetSubClass,
  SetID AS GrantGroup,
  SetLineNumber,
  _Grant.GrantID AS GrantID,
  SetRangeSign,
  SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GrantLfcycStatusForAuthzn AS GrantLfcycStatusForAuthzn,
  _GrantGroup.CreatedByUser AS CreatedByUser,
  _GrantGroup.CreationDate AS CreationDate,
  _GrantGroup.SetDescription AS SetDescription,
  cast( concat_with_space(SetID, _SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription, 1 ) as fmis_fundsmgmtextendedsetname ) AS FundsMgmtExtendedSetDesc
FROM I_Setleaf
LEFT OUTER JOIN I_SetHeader AS _SetHeader ON SetClass = _SetHeader.SetClass AND SetSubClass = _SetHeader.SetSubClass AND GrantGroup = _SetHeader.SetID  -- association [0..1]
LEFT OUTER JOIN C_Grant_Objp AS _Grant ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_GrantGroup_Objp AS _GrantGroup ON GrantGroup = _GrantGroup.GrantGroup AND _GrantGroup.SetClass = '0113'  -- association [0..1]
;