I_FINSTATISTICALKEYFIGITEMBSC
Statistical Keyfigures
I_FINSTATISTICALKEYFIGITEMBSC is a CDS View in S/4HANA. Statistical Keyfigures. It contains 39 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_FinStatisticalKeyFigureItem1 | view | from | COMPOSITE | |
| P_FinStatisticalKeyFigureItem1 | view | union_all | COMPOSITE |
Fields (39)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AccountAssignmentType | accasty | 1 | |
| BudgetPeriod | rbudget_pd | 1 | |
| BusinessArea | rbusa | 1 | |
| BusinessProcess | prznr | 1 | |
| CompanyCode | rbukrs | 1 | |
| ControllingArea | kokrs | 1 | |
| ControllingBusTransacType | vorgn | 1 | |
| ControllingKeySubNumber | hrkft | 1 | |
| ControllingObject | objnr | 1 | |
| ControllingObjectClass | scope | 1 | |
| CostCenter | rcntr | 1 | |
| CostCtrActivityType | lstar | 1 | |
| CostObject | kstrg | 1 | |
| FunctionalArea | rfarea | 1 | |
| Fund | rfund | 1 | |
| GLRecordType | rrcty | 1 | |
| GrantID | rgrant_nbr | 1 | |
| LogicalSystem | logsys | 1 | |
| OrderCategory | autyp | 1 | |
| OrderID | aufnr | 1 | |
| PlanningCategory | category | 1 | |
| ProfitCenter | prctr | 1 | |
| Project | ps_pspid | 1 | |
| ProjectInternalID | ps_prj_pnr | 1 | |
| ProjectNetwork | nplnr | 1 | |
| RelatedNetworkActivity | nplnr_vorgn | 1 | |
| SalesOrder | kdauf | 1 | |
| SalesOrderItem | kdpos | 1 | |
| Segment | segment | 1 | |
| ServiceDocument | service_doc_id | 1 | |
| ServiceDocumentItem | service_doc_item_id | 1 | |
| ServiceDocumentType | service_doc_type | 1 | |
| StatisticalKeyFigQtyUnit | runit | 1 | |
| StatisticalKeyFigure | stagr | 1 | |
| StatisticalKeyFigureCategory | grtyp | 1 | |
| StatisticalKeyFigureItem | recid | 1 | |
| StatisticalKeyFigureQuantity | msl | 1 | |
| ValidityStartDate | date_from | 1 | |
| WBSElement | ps_posid | 1 |
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFIFINSSKF'
@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Statistical Keyfigures'
@VDM.viewType: #BASIC
//@ObjectModel.representativeKey: 'StatisticalKeyFigureItem'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@Analytics: { dataCategory: #CUBE }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
define view I_FinStatisticalKeyFigItemBsc as select from P_Finsskf
association[1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.StatisticalKeyFigQtyUnit = _UnitOfMeasure.UnitOfMeasure
{
stagr as StatisticalKeyFigure,
recid as StatisticalKeyFigureItem,
date_from as ValidityStartDate,
grtyp as StatisticalKeyFigureCategory,
@Semantics.unitOfMeasure:true
@ObjectModel.foreignKey.association: '_UnitOfMeasure'
runit as StatisticalKeyFigQtyUnit,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
msl as StatisticalKeyFigureQuantity,
timestamp as LastChangeDateTime,
rbukrs as CompanyCode,
rrcty as GLRecordType,
category as PlanningCategory,
rcntr as CostCenter,
prctr as ProfitCenter,
rfarea as FunctionalArea,
rbusa as BusinessArea,
kokrs as ControllingArea,
segment as Segment,
vorgn as ControllingBusTransacType,
accasty as AccountAssignmentType,
logsys as LogicalSystem,
objnr as ControllingObject,
hrkft as ControllingKeySubNumber,
scope as ControllingObjectClass,
aufnr as OrderID,
autyp as OrderCategory,
ps_psp_pnr as WBSElementInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID'
ps_posid as WBSElement,
ps_prj_pnr as ProjectInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProjectInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProjectInternalID'
ps_pspid as Project,
nplnr as ProjectNetwork,
nplnr_vorgn as RelatedNetworkActivity,
prznr as BusinessProcess,
kstrg as CostObject,
rfund as Fund,
rgrant_nbr as GrantID,
rbudget_pd as BudgetPeriod,
kdauf as SalesOrder,
kdpos as SalesOrderItem,
lstar as CostCtrActivityType,
service_doc_type as ServiceDocumentType,
service_doc_id as ServiceDocument,
service_doc_item_id as ServiceDocumentItem,
_UnitOfMeasure
}