C_StatKeyFigGroup

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_StatKeyFigGroup.
-- 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: CWUSKFG

CREATE VIEW C_StatKeyFigGroup AS
SELECT
  cast ('5G' as statkeyfigwhereusedobjtypevh) AS StatKeyFigWhereUsedObjType,
  SetClass,
  cast(SetSubClass as kokrs) AS ControllingArea,
  cast( SetID as statisticalkeyfiguregroup ) AS StatisticalKeyFigureGroup,
  _StatisticalKeyFigure.StatisticalKeyFigure AS StatisticalKeyFigure,
  ChildSetClass,
  ChildSetSubClass,
  _StatisticalKeyFigure._Text[1: Language = $session.system_language ].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  cast( _SetHeader._SetHeaderText[1: Language = $session.system_language ].SetDescription as statisticalkeyfiguregroupname ) AS StatisticalKeyFigureGroupName,
  _StatisticalKeyFigure._ControllingArea.ControllingAreaName AS ControllingAreaName,
  CreatedByUser,
  LastChangedByUser,
  _SetHeader.LastChangedDate AS LastChangedDate,
  cast('19700101' as datab) AS ValidityStartDate,
  cast('20700101' as datbi) AS ValidityEndDate
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserCard ON CreatedByUser = _CreatedByUserCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangeByUserCard ON LastChangedByUser = _LastChangeByUserCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_SetHeaderText AS _ChildSetHeaderText ON ChildSetClass = _ChildSetHeaderText.SetClass AND ChildSetSubClass = _ChildSetHeaderText.SetSubClass AND ChildSetID = _ChildSetHeaderText.SetID AND _ChildSetHeaderText.Language = $session.system_language  -- association [0..1]
;