I_FINSTATISTICALKEYFIGUREITEM

CDS View
37 Fields 5 CDS Views

Statistical Keyfigures per period

I_FINSTATISTICALKEYFIGUREITEM is a CDS View in S/4HANA. Statistical Keyfigures per period. It contains 37 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_FinStatisticalKeyFigure view from CONSUMPTION Read Statistical Key Figures per Period
C_FinStatisticalKeyFigureItem view from CONSUMPTION Statistical Keyfigures per period
C_PlanFinStatisticalKeyFigItem view from CONSUMPTION Plan Statistical Key Figures per Period
P_ACTPLNSTATKEYFIGITEMSEMTAG view from COMPOSITE
P_StatKeyFigValueAssignment view from CONSUMPTION

Fields (37)

KeyField CDS FieldsUsed in Views
AccountAssignmentType AccountAssignmentType 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 1
ControllingBusTransacType ControllingBusTransacType 2
ControllingObject ControllingObject 2
ControllingObjectClass ControllingObjectClass 2
CostCenter CostCenter 2
CostCtrActivityType CostCtrActivityType 2
FiscalPeriod FiscalPeriod 2
FiscalYear FiscalYear 2
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 2
Fund Fund 1
GrantID GrantID 1
IntmdStatisticalKeyFigFixedQty IntmdStatisticalKeyFigFixedQty 2
IntmdStatisticalKeyFigSumQty IntmdStatisticalKeyFigSumQty 2
Ledger Ledger 3
OrderCategory OrderCategory 1
OrderID OrderID 1
PlanningCategory PlanningCategory 2
ProfitCenter ProfitCenter 2
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
Segment Segment 2
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
StatisticalKeyFigure StatisticalKeyFigure 2
StatisticalKeyFigureCategory StatisticalKeyFigureCategory 2
StstclKeyFigIntmdActlFixedQty StstclKeyFigIntmdActlFixedQty 1
StstclKeyFigIntmdActlSumQty StstclKeyFigIntmdActlSumQty 1
StstclKeyFigIntmdPlanFixedQty StstclKeyFigIntmdPlanFixedQty 2
StstclKeyFigIntmdPlanSumQty StstclKeyFigIntmdPlanSumQty 2
WBSElement WBSElement 1
WBSElementExternalID WBSElementExternalID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Statistical Keyfigures per period
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINSTATISTICALKEYFIGUREITEM (
    ACCOUNTASSIGNMENTTYPE,
    BUDGETPERIOD,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGBUSTRANSACTYPE,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTCLASS,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    FUND,
    GRANTID,
    INTMDSTATISTICALKEYFIGFIXEDQTY,
    INTMDSTATISTICALKEYFIGSUMQTY,
    LEDGER,
    ORDERCATEGORY,
    ORDERID,
    PLANNINGCATEGORY,
    PROFITCENTER,
    SALESORDER,
    SALESORDERITEM,
    SEGMENT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    STATISTICALKEYFIGURE,
    STATISTICALKEYFIGURECATEGORY,
    STSTCLKEYFIGINTMDACTLFIXEDQTY,
    STSTCLKEYFIGINTMDACTLSUMQTY,
    STSTCLKEYFIGINTMDPLANFIXEDQTY,
    STSTCLKEYFIGINTMDPLANSUMQTY,
    WBSELEMENT,
    WBSELEMENTEXTERNALID
);

Learn More