P_FinStatisticalKeyFigureItem1

Statistical Keyfigures per period - Union | view: PFIFINSSKFPER1 | 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 (I_FINSTATISTICALKEYFIGITEMBSC.StatisticalKeyFigQtyUnit):
msl Statistical Key Figure Quantity
Column Name Description
date_from Valid From
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
  • Order ID
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.AUFNR == AUFK.AUFNR
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == AUFK.MANDT
CO key subnumber
  • CO key subnumber
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.HRKFT == COKEY.HRKFT
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == COKEY.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.KOKRS == TKA01.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == TKA01.MANDT
Cost Object
  • Cost Object
  • ?
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.KSTRG == CKPH.KSTRG
  • P_FINSTATISTICALKEYFIGUREITEM1.[column in domain "DATBI"] == CKPH.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == CKPH.MANDT
Logical system P_FINSTATISTICALKEYFIGUREITEM1.LOGSYS == TBDLS.LOGSYS
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.NPLNR == AUFK.AUFNR
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == AUFK.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.PERIV == T009.PERIV
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == T009.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.PRCTR == CEPC.PRCTR
  • P_FINSTATISTICALKEYFIGUREITEM1.[column in domain "DATBI"] == CEPC.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM1.KOKRS == CEPC.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == CEPC.MANDT
Business Process
  • Business Process
  • ?
  • Controlling Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.PRZNR == CBPR.PRZNR
  • P_FINSTATISTICALKEYFIGUREITEM1.[column in domain "DATBI"] == CBPR.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM1.KOKRS == CBPR.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == CBPR.MANDT
Company Code
  • Company Code
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.RBUKRS == T001.BUKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.RBUSA == TGSB.GSBER
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == TGSB.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_FINSTATISTICALKEYFIGUREITEM1.[column in domain "DATBI"] == CSKS.DATBI
  • P_FINSTATISTICALKEYFIGUREITEM1.KOKRS == CSKS.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == CSKS.MANDT
  • P_FINSTATISTICALKEYFIGUREITEM1.RCNTR == CSKS.KOSTL
Functional Area
  • Functional Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.RFAREA == TFKB.FKBER
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == TFKB.MANDT
Ledger
  • Client
  • Ledger
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.SEGMENT == FAGL_SEGM.SEGMENT
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == FAGL_SEGM.MANDT
Statistical Key Figure
  • Statistical Key Figure
  • Controlling Area
  • Client
  • P_FINSTATISTICALKEYFIGUREITEM1.STAGR == TKA03.STAGR
  • P_FINSTATISTICALKEYFIGUREITEM1.KOKRS == TKA03.KOKRS
  • P_FINSTATISTICALKEYFIGUREITEM1.MANDT == TKA03.MANDT
FI-SL Business Transaction P_FINSTATISTICALKEYFIGUREITEM1.VORGN == T022.ACTIVITY