P_FinStatisticalKeyFigureItem

Statistical Keyfigures per period | view: PFIFINSSKFPER | Extraction: Not supported | Component: Information System
Tables used: FINSSKF, TKA01, FINSC_LEDGER, T000, PRPS, TKA03, FINSC_LD_CMP, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
Column Name Description
📏 Statistical Key Figure Quantity Unit (P_FINSTATISTICALKEYFIGUREITEM1.runit):
msl null
Column Name Description
Column Name Description
IsSpecialPeriod Indicator: Is Special Period Show values
grtyp Statistical Key Figure Category Show values
rrcty Record Type Show values
scope Object Class Show values
autyp Order category Show values
Column Name Description Domain name
FISCYEARPER Fiscal Year + Fiscal Period FINS_FYEARPERIOD
recid Statistical Key Figure Item SYSUUID_22
RYEAR Fiscal Year GJAHR
poper Fiscal Period POPER
category Plan Category FCOM_CATEGORY
ps_psp_pnr WBS Element Internal ID FIS_WBSINT_NO_CONV
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ps_prj_pnr Project (internal) PS_PSPNR
ps_pspid Project definition PS_PSPID
nplnr_vorgn Network activity VORNR
rfund Fund BP_GEBER
rgrant_nbr Grant GM_GRANT_NBR
rbudget_pd Budget Period FM_BUDGET_PERIOD
kdauf Sales Order Number VBELN
kdpos Item number in Sales Order NUM06
lstar Activity Type LSTAR
service_doc_type Service Document Type CRM_PROCESS_TYPE
service_doc_id Service Document ID CRM_OBJECT_ID
service_doc_item_id Service Document Item ID FCO_SRVDOC_ITEM_ID
Master Data Relations Join Conditions
Order ID
  • Client
  • Order ID
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == AUFK.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.AUFNR == AUFK.AUFNR
CO key subnumber
  • CO key subnumber
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM.HRKFT == COKEY.HRKFT
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == COKEY.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == TKA01.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.KOKRS == TKA01.KOKRS
Cost Object
  • ?
  • Client
  • Cost Object
  • P_FINSTATISTICALKEYFIGUREITEM.[column in domain "DATBI"] == CKPH.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == CKPH.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.KSTRG == CKPH.KSTRG
Logical system P_FINSTATISTICALKEYFIGUREITEM.LOGSYS == TBDLS.LOGSYS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == AUFK.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.NPLNR == AUFK.AUFNR
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM.PERIV == T009.PERIV
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == T009.MANDT
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • P_FINSTATISTICALKEYFIGUREITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == CEPC.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.KOKRS == CEPC.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM.PRCTR == CEPC.PRCTR
Business Process
  • ?
  • Client
  • Controlling Area
  • Business Process
  • P_FINSTATISTICALKEYFIGUREITEM.[column in domain "DATBI"] == CBPR.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == CBPR.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.KOKRS == CBPR.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM.PRZNR == CBPR.PRZNR
Company Code
  • Client
  • Company Code
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == T001.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.RBUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == TGSB.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.RBUSA == TGSB.GSBER
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • P_FINSTATISTICALKEYFIGUREITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == CSKS.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.RCNTR == CSKS.KOSTL
  • P_FINSTATISTICALKEYFIGUREITEM.KOKRS == CSKS.KOKRS
Functional Area
  • Client
  • Functional Area
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == TFKB.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.RFAREA == TFKB.FKBER
Ledger
  • Ledger
  • Client
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == FAGL_SEGM.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.SEGMENT == FAGL_SEGM.SEGMENT
Statistical Key Figure
  • Client
  • Controlling Area
  • Statistical Key Figure
  • P_FINSTATISTICALKEYFIGUREITEM.MANDT == TKA03.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM.KOKRS == TKA03.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM.STAGR == TKA03.STAGR
FI-SL Business Transaction P_FINSTATISTICALKEYFIGUREITEM.VORGN == T022.ACTIVITY