I_PeriodStatisticalKeyFigure

DDL: I_PERIODSTATISTICALKEYFIGURE SQL: IFISTKEYFIGPER Type: view BASIC
26 Fields 1 Data Sources

Statistical Key Figures for all periods

I_PeriodStatisticalKeyFigure is a Basic CDS View that provides data about "Statistical Key Figures for all periods" in SAP S/4HANA. It reads from 1 data source (P_PeriodStatisticalKeyFigure) and exposes 26 fields with key fields ControllingObject, FiscalYear, StatisticalKeyFigure.

Data Sources (1)

SourceAliasJoin Type
P_PeriodStatisticalKeyFigure P_PeriodStatisticalKeyFigure from

Annotations (12)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IFISTKEYFIGPER view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Statistical Key Figures for all periods view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject P_PeriodStatisticalKeyFigure ControllingObject Object number
KEY FiscalYear P_PeriodStatisticalKeyFigure FiscalYear G/L Fiscal Year
KEY StatisticalKeyFigure P_PeriodStatisticalKeyFigure StatisticalKeyFigure Statistical Key Figure
StatisticalKeyFigQtyUnit P_PeriodStatisticalKeyFigure StatisticalKeyFigQtyUnit
CtrlgObjStstcKeyFigP01Qty P_PeriodStatisticalKeyFigure sme001 Statistical qty
CtrlgObjStstcKeyFigP02Qty P_PeriodStatisticalKeyFigure sme002 Statistical qty
CtrlgObjStstcKeyFigP03Qty P_PeriodStatisticalKeyFigure sme003 Statistical qty
CtrlgObjStstcKeyFigP04Qty P_PeriodStatisticalKeyFigure sme004 Statistical qty
CtrlgObjStstcKeyFigP05Qty P_PeriodStatisticalKeyFigure sme005 Statistical qty
CtrlgObjStstcKeyFigP06Qty P_PeriodStatisticalKeyFigure sme006 Statistical qty
CtrlgObjStstcKeyFigP07Qty P_PeriodStatisticalKeyFigure sme007 Statistical qty
CtrlgObjStstcKeyFigP08Qty P_PeriodStatisticalKeyFigure sme008 Statistical qty
CtrlgObjStstcKeyFigP09Qty P_PeriodStatisticalKeyFigure sme009 Statistical qty
CtrlgObjStstcKeyFigP10Qty P_PeriodStatisticalKeyFigure sme010 Statistical qty
CtrlgObjStstcKeyFigP11Qty P_PeriodStatisticalKeyFigure sme011 Statistical qty
CtrlgObjStstcKeyFigP12Qty P_PeriodStatisticalKeyFigure sme012 Statistical qty
CtrlgObjStstcKeyFigP13Qty P_PeriodStatisticalKeyFigure sme013 Statistical qty
CtrlgObjStstcKeyFigP14Qty P_PeriodStatisticalKeyFigure sme014 Statistical qty
CtrlgObjStstcKeyFigP15Qty P_PeriodStatisticalKeyFigure sme015 Statistical qty
CtrlgObjStstcKeyFigP16Qty P_PeriodStatisticalKeyFigure sme016 Statistical qty
FunctionalArea P_PeriodStatisticalKeyFigure FunctionalArea Sendr Fctl Area
Segment P_PeriodStatisticalKeyFigure Segment Segment number
Fund P_PeriodStatisticalKeyFigure Fund Sender Fund
GrantID P_PeriodStatisticalKeyFigure GrantID Sender Grant
BudgetPeriod P_PeriodStatisticalKeyFigure BudgetPeriod Budget Period
_UnitOfMeasure _UnitOfMeasure

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_PeriodStatisticalKeyFigure.
-- 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: IFISTKEYFIGPER

CREATE VIEW I_PeriodStatisticalKeyFigure AS
SELECT
  P_PeriodStatisticalKeyFigure.ControllingObject AS ControllingObject,
  P_PeriodStatisticalKeyFigure.FiscalYear AS FiscalYear,
  P_PeriodStatisticalKeyFigure.StatisticalKeyFigure AS StatisticalKeyFigure,
  P_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit AS StatisticalKeyFigQtyUnit,
  P_PeriodStatisticalKeyFigure.sme001 AS CtrlgObjStstcKeyFigP01Qty,
  P_PeriodStatisticalKeyFigure.sme002 AS CtrlgObjStstcKeyFigP02Qty,
  P_PeriodStatisticalKeyFigure.sme003 AS CtrlgObjStstcKeyFigP03Qty,
  P_PeriodStatisticalKeyFigure.sme004 AS CtrlgObjStstcKeyFigP04Qty,
  P_PeriodStatisticalKeyFigure.sme005 AS CtrlgObjStstcKeyFigP05Qty,
  P_PeriodStatisticalKeyFigure.sme006 AS CtrlgObjStstcKeyFigP06Qty,
  P_PeriodStatisticalKeyFigure.sme007 AS CtrlgObjStstcKeyFigP07Qty,
  P_PeriodStatisticalKeyFigure.sme008 AS CtrlgObjStstcKeyFigP08Qty,
  P_PeriodStatisticalKeyFigure.sme009 AS CtrlgObjStstcKeyFigP09Qty,
  P_PeriodStatisticalKeyFigure.sme010 AS CtrlgObjStstcKeyFigP10Qty,
  P_PeriodStatisticalKeyFigure.sme011 AS CtrlgObjStstcKeyFigP11Qty,
  P_PeriodStatisticalKeyFigure.sme012 AS CtrlgObjStstcKeyFigP12Qty,
  P_PeriodStatisticalKeyFigure.sme013 AS CtrlgObjStstcKeyFigP13Qty,
  P_PeriodStatisticalKeyFigure.sme014 AS CtrlgObjStstcKeyFigP14Qty,
  P_PeriodStatisticalKeyFigure.sme015 AS CtrlgObjStstcKeyFigP15Qty,
  P_PeriodStatisticalKeyFigure.sme016 AS CtrlgObjStstcKeyFigP16Qty,
  P_PeriodStatisticalKeyFigure.FunctionalArea AS FunctionalArea,
  P_PeriodStatisticalKeyFigure.Segment AS Segment,
  P_PeriodStatisticalKeyFigure.Fund AS Fund,
  P_PeriodStatisticalKeyFigure.GrantID AS GrantID,
  P_PeriodStatisticalKeyFigure.BudgetPeriod AS BudgetPeriod
FROM P_PeriodStatisticalKeyFigure
;

Learn More