I_FinStatisticalKeyFigItemBsc
Statistical Keyfigure Items
I_FinStatisticalKeyFigItemBsc (Basic)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
FinStatisticalKeyFigureItem · Accounting and Financial Close
I_FinStatisticalKeyFigItemBsc is a Basic CDS View (Cube) that provides data about "Statistical Keyfigure Items" in SAP S/4HANA. It reads from 1 data source (P_Finsskf) and exposes 63 fields with key fields StatisticalKeyFigure, StatisticalKeyFigureItem, ValidityStartDate.
SAP Help Documentation
| Category | CDS Views for Overhead Cost Controlling |
|---|---|
| Data Category | Cube |
This CDS view is designed to provide detailed information about statistical key figure items within a financial context. It aggregates and organizes data related to various financial dimensions such as cost centers, profit centers, and controlling areas, among others. The view is structured to support analytical and data extraction capabilities, enabling users to perform in-depth analysis and reporting on statistical key figures. This CDS view provides the data to answer the following business questions: What are the statistical key figures and their associated items within a specific company code or controlling area? How do statistical key figures vary across different cost centers and profit centers? What is the quantity and unit of measure for each statistical key figure item? How do statistical key figures relate to various financial dimensions such as functional areas, business areas, and segments? What is the validity period for each statistical key figure item? How can statistical key figures be analyzed in relation to sales documents, orders, and service documents? What are the last change timestamps for statistical key figure items, indicating recent updates or modifications? How do statistical key figures integrate with planning categories and budget periods for financial planning and analysis? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object ID Authorization Object Text CRMS4_SLSO Sales Organizational Units of Service Transactions F_BKPF_BUK Accounting Document: Authorization for Company Codes F_BKPF_FKB Accounting Document: Authorization for Functional Area F_BKPF_ORD Order Category / Order Type for Journal Entries F_CC_HIER Authorization Object for Company Code Hierarchies F_FAGL_SEG General Ledger: Authorization for Segment F_FINS_SKF FI: Processing of Statistical Key Figures K_ACDOCP_P Financials planning via table ACDOCP K_PCAR_REP EC-PCA: Summary and Line Item Reports K_REPO_CCA CO-CCA: Reporting on Cost Centers/Cost Elements V_VBAK_AAT Sales Document: Authorization for Sales Document Types V_VBAK_VKO Sales Document: Authorization for Sales Areas
Structure
Important Fields Important fields in this view include the following: Field Name Description STATISTICALKEYFIGUREQUANTITY Stat. KeyFig. Qty LASTCHANGEDATETIME Time Stamp SERVICEDOCUMENTITEM Service Doc. Item SERVICEDOCUMENT Service Document SERVICEDOCUMENTTYPE Service Doc. Type COSTCTRACTIVITYTYPE Activity Type SALESDOCUMENTITEM Sales Order Item SALESDOCUMENT Sales Order BUDGETPERIOD Budget Period GRANTID Grant FUND Fund COSTOBJECT Cost Object PROJECT Project PROJECTINTERNALID Project Internal ID WBSELEMENT WBS Element WBSELEMENTINTERNALID WBS Element Internal ID ORDERCATEGORY Order category ORDERID Order ID CONTROLLINGOBJECTCLASS Controlling Object Class CONTROLLINGKEYSUBNUMBER CO subkey CONTROLLINGOBJECT Controlling Object LOGICALSYSTEM Logical system ACCOUNTASSIGNMENTTYPE Object Type CONTROLLINGBUSTRANSACTYPE Transaction SEGMENT Segment CONTROLLINGAREA Controlling Area BUSINESSAREA Business Area FUNCTIONALAREA Functional Area PROFITCENTER Profit Center COSTCENTER Cost Center PLANNINGCATEGORY Plan Category GLRECORDTYPE Record Type COMPANYCODE Company Code STATISTICALKEYFIGQTYUNIT StatKeyFigQtyUnit STATISTICALKEYFIGURECATEGORY Stat. Key Fig. Cat. VALIDITYSTARTDATE Valid From STATISTICALKEYFIGUREITEM Statistical Key Figure Item STATISTICALKEYFIGURE Statistical Key Figure
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Accounting and Financial Close |
| Application Component | FI-FIO-GL-IS |
| Capabilities | Data Provider for Analytical Queries, Data Source for Data Extraction |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view is designed to provide detailed information about statistical key figure items within a financial context. It aggregates and organizes data related to various financial dimensions such as cost centers, profit centers, and controlling areas, among others. The view is structured to support analytical and data extraction capabilities, enabling users to perform in-depth analysis and reporting on statistical key figures.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the statistical key figures and their associated items within a specific company code or controlling area?</p></li> <li><p>How do statistical key figures vary across different cost centers and profit centers?</p></li> <li><p>What is the quantity and unit of measure for each statistical key figure item?</p></li> <li><p>How do statistical key figures relate to various financial dimensions such as functional areas, business areas, and segments?</p></li> <li><p>What is the validity period for each statistical key figure item?</p></li> <li><p>How can statistical key figures be analyzed in relation to sales documents, orders, and service documents?</p></li> <li><p>What are the last change timestamps for statistical key figure items, indicating recent updates or modifications?</p></li> <li><p>How do statistical key figures integrate with planning categories and budget periods for financial planning and analysis?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_Finsskf | P_Finsskf | from |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | false | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| Metadata.allowExtensions | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Statistical Keyfigure Items | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| Analytics.technicalName | IFIFINSSKF | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.internalName | #LOCAL | view | |
| Analytics.dataExtraction.enabled | true | view | |
| ObjectModel.sapObjectNodeType.name | FinStatisticalKeyFigureItem | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (63)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | StatisticalKeyFigure | P_Finsskf | stagr | Statistical Key Figure |
| KEY | StatisticalKeyFigureItem | P_Finsskf | recid | Statistical Key Figure Item |
| KEY | ValidityStartDate | P_Finsskf | date_from | Validity Start Date |
| StatisticalKeyFigureCategory | P_Finsskf | grtyp | Statistical Key Figure Category | |
| StatisticalKeyFigQtyUnit | P_Finsskf | runit | Statistical Key Figure Quantity Unit | |
| StatisticalKeyFigureQuantity | P_Finsskf | msl | Statistical Key Figure Quantity | |
| LastChangeDateTime | P_Finsskf | timestamp | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |
| CompanyCode | P_Finsskf | rbukrs | Company Code | |
| GLRecordType | P_Finsskf | rrcty | Record Type | |
| PlanningCategory | P_Finsskf | category | Violation Category | |
| CostCenter | P_Finsskf | rcntr | Cost Center | |
| ProfitCenter | P_Finsskf | prctr | Profit Centers | |
| FunctionalArea | P_Finsskf | rfarea | Functional Area | |
| BusinessArea | P_Finsskf | rbusa | Business Area | |
| ControllingArea | P_Finsskf | kokrs | Controlling Area | |
| Segment | P_Finsskf | segment | Segment for Segmental Reporting | |
| ControllingBusTransacType | P_Finsskf | vorgn | FI-SL Business Transaction | |
| AccountAssignmentType | P_Finsskf | accasty | Object Type | |
| LogicalSystem | P_Finsskf | logsys | Logical system | |
| ControllingObject | P_Finsskf | objnr | Controlling Object | |
| ControllingKeySubNumber | P_Finsskf | hrkft | Origin group order | |
| ControllingObjectClass | P_Finsskf | scope | Controlling Object Class | |
| OrderID | P_Finsskf | aufnr | SettlementOrder | |
| OrderCategory | P_Finsskf | autyp | Order category | |
| WBSElementInternalID | P_Finsskf | ps_psp_pnr | WBS Element Internal ID | |
| WBSElement | P_Finsskf | ps_posid | WBS Element | |
| ProjectInternalID | P_Finsskf | ps_prj_pnr | Project Internal ID | |
| Project | P_Finsskf | ps_pspid | Project def. | |
| ProjectNetwork | P_Finsskf | nplnr | Network Number for Account Assignment | |
| RelatedNetworkActivity | P_Finsskf | nplnr_vorgn | Related Network Activity | |
| BusinessProcess | P_Finsskf | prznr | Business Process | |
| CostObject | P_Finsskf | kstrg | Cost Objects | |
| Fund | P_Finsskf | rfund | Fund | |
| GrantID | P_Finsskf | rgrant_nbr | Grant | |
| BudgetPeriod | P_Finsskf | rbudget_pd | Budget Period | |
| SalesDocument | P_Finsskf | kdauf | Sales Order Number | |
| SalesDocumentItem | P_Finsskf | kdpos | Item Number in Sales Order | |
| CostCtrActivityType | P_Finsskf | lstar | Activity Type | |
| ServiceDocumentType | P_Finsskf | service_doc_type | Service Document Type | |
| ServiceDocument | P_Finsskf | service_doc_id | Service Document ID | |
| ServiceDocumentItem | P_Finsskf | service_doc_item_id | Service Document Item ID | |
| _FiscalCalYearPeriodForLedger | _FiscalCalYearPeriodForLedger | |||
| _ControllingArea | _ControllingArea | |||
| _CompanyCode | _CompanyCode | |||
| _CostCenter | _CostCenter | |||
| _ProfitCenter | _ProfitCenter | |||
| _StatisticalKeyFigure | _StatisticalKeyFigure | |||
| _StatisticalKeyFigureCat | _StatisticalKeyFigureCat | |||
| _UnitOfMeasure | _UnitOfMeasure | |||
| _Segment | _Segment | |||
| _FunctionalArea | _FunctionalArea | |||
| _BusinessArea | _BusinessArea | |||
| _Order | _Order | |||
| _SalesDocument | _SalesDocument | |||
| _SalesDocumentItem | _SalesDocumentItem | |||
| _ControllingObject | _ControllingObject | |||
| _BudgetPeriod | _BudgetPeriod | |||
| _PlanningCategory | _PlanningCategory | |||
| _ProjectBasicData | _ProjectBasicData | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _ServiceDocument | _ServiceDocument | |||
| _ServiceDocumentItem | _ServiceDocumentItem |
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 I_FinStatisticalKeyFigItemBsc.
-- 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 I_FinStatisticalKeyFigItemBsc AS
SELECT
P_Finsskf.stagr AS StatisticalKeyFigure,
P_Finsskf.recid AS StatisticalKeyFigureItem,
P_Finsskf.date_from AS ValidityStartDate,
P_Finsskf.grtyp AS StatisticalKeyFigureCategory,
P_Finsskf.runit AS StatisticalKeyFigQtyUnit,
P_Finsskf.msl AS StatisticalKeyFigureQuantity,
P_Finsskf.timestamp AS LastChangeDateTime,
P_Finsskf.rbukrs AS CompanyCode,
P_Finsskf.rrcty AS GLRecordType,
P_Finsskf.category AS PlanningCategory,
P_Finsskf.rcntr AS CostCenter,
P_Finsskf.prctr AS ProfitCenter,
P_Finsskf.rfarea AS FunctionalArea,
P_Finsskf.rbusa AS BusinessArea,
P_Finsskf.kokrs AS ControllingArea,
P_Finsskf.segment AS Segment,
P_Finsskf.vorgn AS ControllingBusTransacType,
P_Finsskf.accasty AS AccountAssignmentType,
P_Finsskf.logsys AS LogicalSystem,
P_Finsskf.objnr AS ControllingObject,
P_Finsskf.hrkft AS ControllingKeySubNumber,
P_Finsskf.scope AS ControllingObjectClass,
P_Finsskf.aufnr AS OrderID,
P_Finsskf.autyp AS OrderCategory,
P_Finsskf.ps_psp_pnr AS WBSElementInternalID,
P_Finsskf.ps_posid AS WBSElement,
P_Finsskf.ps_prj_pnr AS ProjectInternalID,
P_Finsskf.ps_pspid AS Project,
P_Finsskf.nplnr AS ProjectNetwork,
P_Finsskf.nplnr_vorgn AS RelatedNetworkActivity,
P_Finsskf.prznr AS BusinessProcess,
P_Finsskf.kstrg AS CostObject,
P_Finsskf.rfund AS Fund,
P_Finsskf.rgrant_nbr AS GrantID,
P_Finsskf.rbudget_pd AS BudgetPeriod,
P_Finsskf.kdauf AS SalesDocument,
P_Finsskf.kdpos AS SalesDocumentItem,
P_Finsskf.lstar AS CostCtrActivityType,
P_Finsskf.service_doc_type AS ServiceDocumentType,
P_Finsskf.service_doc_id AS ServiceDocument,
P_Finsskf.service_doc_item_id AS ServiceDocumentItem
FROM P_Finsskf
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA