I_StatisticalKeyFigureItem

Statistical Key Figure Items | view: IFISTKEYFIGITM | TRAN | Extraction: Not supported | Component: Information System
Tables used: AFKOAFVCONR00VBAKCOSRTKA01T000TKA03PRPSCBPRONRBPCKPHCSKSCSLACSKSTKA02AUFKONRPDPROJPRPSFCO_SRVDOCONRSCFCO_SRVDOCONRSVONRHPONRKLONRKSONRORONRPRONRVB
Column Name Description
ControllingObject FK Object number
StatisticalKeyFigure FK Statistical Key Figure
FiscalYear Fiscal Year
FiscalPeriod Fiscal Period
Column Name Description
Column Name Description
📏 Statistical Key Figure Quantity Unit (StatisticalKeyFigQtyUnit):
StatisticalKeyFigFixedQty Statistical Key Figure Fixed Quantity
IntmdStatisticalKeyFigFixedQty Statistical Key Figure Fixed Quantity
StatisticalKeyFigSumQty Statistical Key Figure Sum Quantity
IntmdStatisticalKeyFigSumQty Statistical Key Figure Sum Quantity
StatisticalKeyFigureQuantity Statistical Key Figure Quantity
Column Name Description
Column Name Description
StatisticalKeyFigureCategory Statistical Key Figure Category Show values
Column Name Description Domain name
CostCenter Cost Center KOSTL
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
OrderID Order Number AUFNR
BusinessProcess Business Process CO_PRZNR
CostCtrActivityType Activity Type LSTAR
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ProjectInternalID Project Internal ID FIS_PROJECTINT_NO_CONV
AccountAssignmentType Object Type J_OBART
ControllingObjectType Object Type J_OBART
Master Data Relations Join Conditions
Controlling Area
  • Client
  • Controlling Area
  • I_STATISTICALKEYFIGUREITEM.MANDT == TKA01.MANDT
  • I_STATISTICALKEYFIGUREITEM.CONTROLLINGAREA == TKA01.KOKRS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_STATISTICALKEYFIGUREITEM.MANDT == T009.MANDT
  • I_STATISTICALKEYFIGUREITEM.FISCALYEARVARIANT == T009.PERIV
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_STATISTICALKEYFIGUREITEM.MANDT == FAGL_SEGM.MANDT
  • I_STATISTICALKEYFIGUREITEM.SEGMENT == FAGL_SEGM.SEGMENT
Unit of measure
  • Client
  • Statistical Key Figure Quantity Unit
  • I_STATISTICALKEYFIGUREITEM.MANDT == T006.MANDT
  • I_STATISTICALKEYFIGUREITEM.STATISTICALKEYFIGQTYUNIT == T006.MSEHI
Statistical group
  • Client
  • Controlling Area
  • Statistical Key Figure
  • I_STATISTICALKEYFIGUREITEM.MANDT == TKA03.MANDT
  • I_STATISTICALKEYFIGUREITEM.CONTROLLINGAREA == TKA03.KOKRS
  • I_STATISTICALKEYFIGUREITEM.STATISTICALKEYFIGURE == TKA03.STAGR