P_StatisticalKeyFigureItem

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 P_StatisticalKeyFigureItem.
-- 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.

CREATE VIEW P_StatisticalKeyFigureItem AS
SELECT
  P_StatisticalKeyFigureItem1.ControllingObject AS ControllingObject,
  P_StatisticalKeyFigureItem1.StatisticalKeyFigure AS StatisticalKeyFigure,
  P_StatisticalKeyFigureItem1.FiscalYear AS FiscalYear,
  P_StatisticalKeyFigureItem1.FiscalPeriod AS FiscalPeriod,
  P_StatisticalKeyFigureItem1.StatisticalKeyFigQtyUnit AS StatisticalKeyFigQtyUnit,
  P_StatisticalKeyFigureItem1.StatisticalKeyFigureQuantity AS StatisticalKeyFigureQuantity,
  P_StatisticalKeyFigureItem1.FunctionalArea AS FunctionalArea,
  P_StatisticalKeyFigureItem1.Segment AS Segment,
  P_StatisticalKeyFigureItem1.Fund AS Fund,
  P_StatisticalKeyFigureItem1.GrantID AS GrantID,
  P_StatisticalKeyFigureItem1.BudgetPeriod AS BudgetPeriod,
  I_ControllingObjectEnhanced.ControllingArea AS ControllingArea,
  I_ControllingObjectEnhanced.CompanyCode AS CompanyCode,
  I_ControllingObjectEnhanced.AccountAssignmentType AS AccountAssignmentType,
  I_ControllingObjectEnhanced.CostCenter AS CostCenter,
  I_ControllingObjectEnhanced.CostCtrActivityType AS CostCtrActivityType,
  I_ControllingObjectEnhanced.BusinessProcess AS BusinessProcess,
  I_ControllingObjectEnhanced.OrderID AS OrderID,
  I_ControllingObjectEnhanced.InternalOrder AS InternalOrder,
  cast( I_ControllingObjectEnhanced.ProjectInternalID as fis_projectint_no_conv preserving type ) AS ProjectInternalID,
  cast( I_ControllingObjectEnhanced.WBSElementInternalID as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  I_ControllingObjectEnhanced.SalesDocument AS SalesDocument,
  I_ControllingObjectEnhanced.SalesDocumentItem AS SalesDocumentItem,
  I_ControllingObjectEnhanced.ProjectNetwork AS ProjectNetwork,
  I_ControllingObjectEnhanced.ServiceDocumentType AS ServiceDocumentType,
  I_ControllingObjectEnhanced.ServiceDocument AS ServiceDocument,
  I_ControllingObjectEnhanced.ServiceDocumentItem AS ServiceDocumentItem,
  I_ControllingObjectEnhanced.CostObject AS CostObject,
  I_StatisticalKeyFigure.StstcKeyFigCategory AS StatisticalKeyFigureCategory,
  I_ControllingArea.FiscalYearVariant AS FiscalYearVariant,
  I_ControllingObjectEnhanced._BusinessProcess AS _BusinessProcess,
  I_ControllingObjectEnhanced._ControllingArea AS _ControllingArea,
  I_ControllingObjectEnhanced._CostCenter AS _CostCenter,
  I_ControllingObjectEnhanced._CostCtrActivityType AS _CostCtrActivityType,
  I_ControllingObjectEnhanced._InternalOrder AS _InternalOrder,
  I_ControllingObjectEnhanced._Order AS _Order,
  I_ControllingObjectEnhanced._ProjectBasicData AS _ProjectBasicData,
  I_ControllingObjectEnhanced._SalesDocument AS _SalesDocument,
  I_ControllingObjectEnhanced._SalesDocumentItem AS _SalesDocumentItem,
  I_ControllingObjectEnhanced._ServiceDocument AS _ServiceDocument,
  I_ControllingObjectEnhanced._ServiceDocumentItem AS _ServiceDocumentItem,
  I_ControllingObjectEnhanced._ServiceDocumentType AS _ServiceDocumentType,
  I_ControllingObjectEnhanced._WBSElementBasicData AS _WBSElementBasicData,
  I_StatisticalKeyFigure._StatisticalKeyFigureCat AS _StatisticalKeyFigureCat
FROM P_StatisticalKeyFigureItem1
INNER JOIN I_ControllingObjectEnhanced ON /* join condition not captured in parsed metadata */
INNER JOIN I_StatisticalKeyFigure ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ControllingArea ON /* join condition not captured in parsed metadata */
;