P_FinStatisticalKeyFigureItem1

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_FinStatisticalKeyFigureItem1.
-- 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_FinStatisticalKeyFigureItem1 AS
SELECT
  I_FiscalCalYearPeriodForLedger.Ledger AS rldnr,
  I_FinStatisticalKeyFigItemBsc.CompanyCode AS rbukrs,
  I_FiscalCalYearPeriodForLedger.FiscalYearPeriod AS FISCYEARPER,
  I_FinStatisticalKeyFigItemBsc.StatisticalKeyFigure AS stagr,
  I_FinStatisticalKeyFigItemBsc.StatisticalKeyFigureItem AS recid,
  I_FiscalCalYearPeriodForLedger.FiscalYear AS RYEAR,
  I_FiscalCalYearPeriodForLedger.FiscalPeriod AS poper,
  I_FiscalCalYearPeriodForLedger.FiscalYearVariant AS periv,
  I_FiscalCalYearPeriodForLedger.IsSpecialPeriod AS IsSpecialPeriod,
  I_FinStatisticalKeyFigItemBsc.ValidityStartDate AS date_from,
  I_FinStatisticalKeyFigItemBsc.StatisticalKeyFigureCategory AS grtyp,
  I_FinStatisticalKeyFigItemBsc.StatisticalKeyFigQtyUnit AS runit,
  I_FinStatisticalKeyFigItemBsc.StatisticalKeyFigureQuantity AS msl,
  I_FinStatisticalKeyFigItemBsc.GLRecordType AS rrcty,
  I_FinStatisticalKeyFigItemBsc.PlanningCategory AS category,
  I_FinStatisticalKeyFigItemBsc.CostCenter AS rcntr,
  I_FinStatisticalKeyFigItemBsc.ProfitCenter AS prctr,
  I_FinStatisticalKeyFigItemBsc.FunctionalArea AS rfarea,
  I_FinStatisticalKeyFigItemBsc.BusinessArea AS rbusa,
  I_FinStatisticalKeyFigItemBsc.ControllingArea AS kokrs,
  I_FinStatisticalKeyFigItemBsc.Segment AS segment,
  I_FinStatisticalKeyFigItemBsc.ControllingBusTransacType AS vorgn,
  I_FinStatisticalKeyFigItemBsc.LogicalSystem AS logsys,
  I_FinStatisticalKeyFigItemBsc.ControllingObject AS objnr,
  I_FinStatisticalKeyFigItemBsc.ControllingKeySubNumber AS hrkft,
  I_FinStatisticalKeyFigItemBsc.ControllingObjectClass AS scope,
  I_FinStatisticalKeyFigItemBsc.OrderID AS aufnr,
  I_FinStatisticalKeyFigItemBsc.OrderCategory AS autyp,
  I_FinStatisticalKeyFigItemBsc.WBSElementInternalID AS ps_psp_pnr,
  I_FinStatisticalKeyFigItemBsc.WBSElement AS ps_posid,
  cast( I_FinStatisticalKeyFigItemBsc._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  I_FinStatisticalKeyFigItemBsc.ProjectInternalID AS ps_prj_pnr,
  I_FinStatisticalKeyFigItemBsc.Project AS ps_pspid,
  I_FinStatisticalKeyFigItemBsc.ProjectNetwork AS nplnr,
  I_FinStatisticalKeyFigItemBsc.RelatedNetworkActivity AS nplnr_vorgn,
  I_FinStatisticalKeyFigItemBsc.BusinessProcess AS prznr,
  I_FinStatisticalKeyFigItemBsc.CostObject AS kstrg,
  I_FinStatisticalKeyFigItemBsc.Fund AS rfund,
  I_FinStatisticalKeyFigItemBsc.GrantID AS rgrant_nbr,
  I_FinStatisticalKeyFigItemBsc.BudgetPeriod AS rbudget_pd,
  I_FinStatisticalKeyFigItemBsc.SalesDocument AS kdauf,
  I_FinStatisticalKeyFigItemBsc.SalesDocumentItem AS kdpos,
  I_FinStatisticalKeyFigItemBsc.CostCtrActivityType AS lstar,
  I_FinStatisticalKeyFigItemBsc.ServiceDocumentItem as service_doc_item_id AS Ledgerasrldnr
FROM I_FinStatisticalKeyFigItemBsc
INNER JOIN I_FiscalCalYearPeriodForLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_StatisticalKeyFigure ON /* join condition not captured in parsed metadata */
INNER JOIN I_ControllingArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON ps_psp_pnr = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FinStatisticalKeyFigItemBsc
;