C_GrantGroup_Objp

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_GrantGroup_Objp.
-- 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: CGRANTGRP

CREATE VIEW C_GrantGroup_Objp AS
SELECT
  I_SetHeader.SetClass AS SetClass,
  I_SetHeader.SetSubClass AS SetSubClass,
  I_SetHeader.SetID AS GrantGroup,
  I_SetHeader.CreatedByUser AS CreatedByUser,
  I_SetHeader.CreationDate AS CreationDate,
  I_SetHeader.CreationTime AS CreationTime,
  I_SetHeader.SetType AS SetType,
  I_SetHeader._SetHeaderText[1:Language=$session.system_language].SetDescription AS SetDescription
FROM I_SetHeader
LEFT OUTER JOIN C_ChildGrantGroup AS _Child ON SetClass = _Child.SetClass AND SetSubClass = _Child.SetSubClass AND GrantGroup = _Child.SetID  -- association [0..*]
LEFT OUTER JOIN C_ParentGrantGroup AS _Parent ON SetClass = _Parent.ChildSetClass AND SetSubClass = _Parent.ChildSetSubClass AND GrantGroup = _Parent.ChildSetID  -- association [0..*]
LEFT OUTER JOIN C_SetLeafForGrantGrp AS _Grant ON SetClass = _Grant.SetClass AND GrantGroup = _Grant.SetID AND SetSubClass = _Grant.SetSubClass  -- association [0..*]
;