I_StatisticalKeyFigure

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 I_StatisticalKeyFigure.
-- 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: IFISTSTCKEYFIG

CREATE VIEW I_StatisticalKeyFigure AS
SELECT
  cast(stagr as fis_stagr) AS StatisticalKeyFigure,
  cast(kokrs as fis_kokrs) AS ControllingArea,
  msehi AS StstcKeyFigQuantityUnit,
  grtyp AS StstcKeyFigCategory,
  hktyp AS StstclKeyFigureOrigin,
  struct AS LogsInformationSystemTable,
  kennz AS LogsInfoSystemKeyFigure,
  w_flag AS StstclKeyFigureIsCurrency,
  m_plan AS StstclKeyFigProcgPlndValType,
  m_ist AS StstclKeyFigProcgActlValType
FROM tka03
LEFT OUTER JOIN I_StatisticalKeyFigureText AS _Text ON ControllingArea = _Text.ControllingArea AND StatisticalKeyFigure = _Text.StatisticalKeyFigure association[0..1] to I_ControllingArea as _ControllingArea on ControllingArea = _ControllingArea.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_StatisticalKeyFigureCat AS _StatisticalKeyFigureCat ON StstcKeyFigCategory = _StatisticalKeyFigureCat.StstcKeyFigCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON StstcKeyFigQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StstclKeyFigureHierNode AS _StstclKeyFigureHierNode ON ControllingArea = _StstclKeyFigureHierNode.ControllingArea AND StatisticalKeyFigure = _StstclKeyFigureHierNode.StatisticalKeyFigure  -- association [0..*]
;