P_FinStatisticalKeyFigureItem

DDL: P_FINSTATISTICALKEYFIGUREITEM Type: view_entity COMPOSITE
42 Fields 1 Data Sources

P_FinStatisticalKeyFigureItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_FinStatisticalKeyFigureItem1) and exposes 42 fields.

Data Sources (1)

SourceAliasJoin Type
P_FinStatisticalKeyFigureItem1 P_FinStatisticalKeyFigureItem1 from

Annotations (4)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (42)

KeyFieldSource TableSource FieldDescription
rldnr P_FinStatisticalKeyFigureItem1 rldnr Ledger (Compat.)
rbukrs P_FinStatisticalKeyFigureItem1 rbukrs Company Code
FISCYEARPER P_FinStatisticalKeyFigureItem1 FISCYEARPER Period/Year
stagr P_FinStatisticalKeyFigureItem1 stagr Statistical Key Figure
recid P_FinStatisticalKeyFigureItem1 recid Statistical Key Figure Item
RYEAR P_FinStatisticalKeyFigureItem1 RYEAR Ref. Year1
poper P_FinStatisticalKeyFigureItem1 poper Posting periods
periv P_FinStatisticalKeyFigureItem1 periv FYear Variant
IsSpecialPeriod P_FinStatisticalKeyFigureItem1 IsSpecialPeriod
grtyp P_FinStatisticalKeyFigureItem1 grtyp Stat. Key Fig. Cat.
runit P_FinStatisticalKeyFigureItem1 runit Unit/Area
msl
rrcty P_FinStatisticalKeyFigureItem1 rrcty Record Type
category P_FinStatisticalKeyFigureItem1 category Violation Category
rcntr P_FinStatisticalKeyFigureItem1 rcntr Cost Center
prctr P_FinStatisticalKeyFigureItem1 prctr Profit Centers
rfarea P_FinStatisticalKeyFigureItem1 rfarea R FuncArea
rbusa P_FinStatisticalKeyFigureItem1 rbusa Business Area
kokrs P_FinStatisticalKeyFigureItem1 kokrs Org. Value
segment P_FinStatisticalKeyFigureItem1 segment Segment number
vorgn P_FinStatisticalKeyFigureItem1 vorgn Transaction
logsys P_FinStatisticalKeyFigureItem1 logsys Source system
objnr P_FinStatisticalKeyFigureItem1 objnr Val. Obj. No.
hrkft P_FinStatisticalKeyFigureItem1 hrkft Origin group order
scope P_FinStatisticalKeyFigureItem1 scope Visibility
aufnr P_FinStatisticalKeyFigureItem1 aufnr SettlementOrder
autyp P_FinStatisticalKeyFigureItem1 autyp Order category
ps_psp_pnr P_FinStatisticalKeyFigureItem1 ps_psp_pnr WBS Element
ps_posid P_FinStatisticalKeyFigureItem1 ps_posid WBS Element
WBSElementExternalID P_FinStatisticalKeyFigureItem1 WBSElementExternalID WBS Element External ID
ps_prj_pnr P_FinStatisticalKeyFigureItem1 ps_prj_pnr Project def.
ps_pspid P_FinStatisticalKeyFigureItem1 ps_pspid Project def.
nplnr P_FinStatisticalKeyFigureItem1 nplnr Network
nplnr_vorgn P_FinStatisticalKeyFigureItem1 nplnr_vorgn Netwk activity
prznr P_FinStatisticalKeyFigureItem1 prznr Sender BProc
kstrg P_FinStatisticalKeyFigureItem1 kstrg Cost Objects
rfund P_FinStatisticalKeyFigureItem1 rfund Fund
rgrant_nbr P_FinStatisticalKeyFigureItem1 rgrant_nbr Grant
rbudget_pd P_FinStatisticalKeyFigureItem1 rbudget_pd Rec BudPer
kdauf P_FinStatisticalKeyFigureItem1 kdauf SD Document
kdpos P_FinStatisticalKeyFigureItem1 kdpos Sales Ord. Item
lstar P_FinStatisticalKeyFigureItem1 lstar Activity Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FinStatisticalKeyFigureItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_FinStatisticalKeyFigureItem AS
SELECT
  P_FinStatisticalKeyFigureItem1.rldnr AS rldnr,
  P_FinStatisticalKeyFigureItem1.rbukrs AS rbukrs,
  P_FinStatisticalKeyFigureItem1.FISCYEARPER AS FISCYEARPER,
  P_FinStatisticalKeyFigureItem1.stagr AS stagr,
  P_FinStatisticalKeyFigureItem1.recid AS recid,
  P_FinStatisticalKeyFigureItem1.RYEAR AS RYEAR,
  P_FinStatisticalKeyFigureItem1.poper AS poper,
  P_FinStatisticalKeyFigureItem1.periv AS periv,
  P_FinStatisticalKeyFigureItem1.IsSpecialPeriod AS IsSpecialPeriod,
  P_FinStatisticalKeyFigureItem1.grtyp AS grtyp,
  P_FinStatisticalKeyFigureItem1.runit AS runit,
  sum( P_FinStatisticalKeyFigureItem1.msl ) AS msl,
  P_FinStatisticalKeyFigureItem1.rrcty AS rrcty,
  P_FinStatisticalKeyFigureItem1.category AS category,
  P_FinStatisticalKeyFigureItem1.rcntr AS rcntr,
  P_FinStatisticalKeyFigureItem1.prctr AS prctr,
  P_FinStatisticalKeyFigureItem1.rfarea AS rfarea,
  P_FinStatisticalKeyFigureItem1.rbusa AS rbusa,
  P_FinStatisticalKeyFigureItem1.kokrs AS kokrs,
  P_FinStatisticalKeyFigureItem1.segment AS segment,
  P_FinStatisticalKeyFigureItem1.vorgn AS vorgn,
  P_FinStatisticalKeyFigureItem1.logsys AS logsys,
  P_FinStatisticalKeyFigureItem1.objnr AS objnr,
  P_FinStatisticalKeyFigureItem1.hrkft AS hrkft,
  P_FinStatisticalKeyFigureItem1.scope AS scope,
  P_FinStatisticalKeyFigureItem1.aufnr AS aufnr,
  P_FinStatisticalKeyFigureItem1.autyp AS autyp,
  P_FinStatisticalKeyFigureItem1.ps_psp_pnr AS ps_psp_pnr,
  P_FinStatisticalKeyFigureItem1.ps_posid AS ps_posid,
  P_FinStatisticalKeyFigureItem1.WBSElementExternalID AS WBSElementExternalID,
  P_FinStatisticalKeyFigureItem1.ps_prj_pnr AS ps_prj_pnr,
  P_FinStatisticalKeyFigureItem1.ps_pspid AS ps_pspid,
  P_FinStatisticalKeyFigureItem1.nplnr AS nplnr,
  P_FinStatisticalKeyFigureItem1.nplnr_vorgn AS nplnr_vorgn,
  P_FinStatisticalKeyFigureItem1.prznr AS prznr,
  P_FinStatisticalKeyFigureItem1.kstrg AS kstrg,
  P_FinStatisticalKeyFigureItem1.rfund AS rfund,
  P_FinStatisticalKeyFigureItem1.rgrant_nbr AS rgrant_nbr,
  P_FinStatisticalKeyFigureItem1.rbudget_pd AS rbudget_pd,
  P_FinStatisticalKeyFigureItem1.kdauf AS kdauf,
  P_FinStatisticalKeyFigureItem1.kdpos AS kdpos,
  P_FinStatisticalKeyFigureItem1.lstar AS lstar
FROM P_FinStatisticalKeyFigureItem1
;

Learn More