P_StatisticalKeyFigureItem

Statistical Key Figure Items | view: PFISTKEYFIGITM | Extraction: Not supported | Component: Information System
Tables used: AFKOAFVCONR00VBAKCOSRTKA01T000TKA03CBPRONRBPCKPHCSKSCSLACSKSTKA02AUFKONRPDPROJPRPSFCO_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):
StatisticalKeyFigureQuantity Statistical Key Figure Quantity
Column Name Description
Column Name Description
StatisticalKeyFigureCategory Statistical Key Figure Category Show values
Column Name Description Domain name
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
AccountAssignmentType Object Type J_OBART
CostCenter Cost Center KOSTL
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
OrderID Order Number AUFNR
InternalOrder Internal Order AUFNR
ProjectInternalID Project Internal ID FIS_PROJECTINT_NO_CONV
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ProjectNetwork Network Number for Account Assignment AUFNR
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
CostObject Cost Object KSTRG
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_STATISTICALKEYFIGUREITEM.COMPANYCODE == T001.BUKRS
  • P_STATISTICALKEYFIGUREITEM.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_STATISTICALKEYFIGUREITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_STATISTICALKEYFIGUREITEM.MANDT == TKA01.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_STATISTICALKEYFIGUREITEM.FISCALYEARVARIANT == T009.PERIV
  • P_STATISTICALKEYFIGUREITEM.MANDT == T009.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_STATISTICALKEYFIGUREITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • P_STATISTICALKEYFIGUREITEM.MANDT == FAGL_SEGM.MANDT
Unit of measure
  • Statistical Key Figure Quantity Unit
  • Client
  • P_STATISTICALKEYFIGUREITEM.STATISTICALKEYFIGQTYUNIT == T006.MSEHI
  • P_STATISTICALKEYFIGUREITEM.MANDT == T006.MANDT
Statistical group
  • Controlling Area
  • Client
  • Statistical Key Figure
  • P_STATISTICALKEYFIGUREITEM.CONTROLLINGAREA == TKA03.KOKRS
  • P_STATISTICALKEYFIGUREITEM.MANDT == TKA03.MANDT
  • P_STATISTICALKEYFIGUREITEM.STATISTICALKEYFIGURE == TKA03.STAGR