P_StatisticalKeyFigureItem

DDL: P_STATISTICALKEYFIGUREITEM SQL: PFISTKEYFIGITM Type: view COMPOSITE

P_StatisticalKeyFigureItem is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_ControllingArea, I_ControllingObjectEnhanced, I_StatisticalKeyFigure, P_StatisticalKeyFigureItem1) and exposes 44 fields with key fields ControllingObject, StatisticalKeyFigure, FiscalYear, FiscalPeriod.

4 data source(s) 44 fields

Data Sources (4)

SourceAliasJoin Type
I_ControllingArea I_ControllingArea left_outer
I_ControllingObjectEnhanced I_ControllingObjectEnhanced inner
I_StatisticalKeyFigure I_StatisticalKeyFigure inner
P_StatisticalKeyFigureItem1 P_StatisticalKeyFigureItem1 from

Annotations (8)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PFISTKEYFIGITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject P_StatisticalKeyFigureItem1 ControllingObject
KEY StatisticalKeyFigure P_StatisticalKeyFigureItem1 StatisticalKeyFigure
KEY FiscalYear P_StatisticalKeyFigureItem1 FiscalYear
KEY FiscalPeriod P_StatisticalKeyFigureItem1 FiscalPeriod
StatisticalKeyFigQtyUnit P_StatisticalKeyFigureItem1 StatisticalKeyFigQtyUnit
StatisticalKeyFigureQuantity P_StatisticalKeyFigureItem1 StatisticalKeyFigureQuantity
FunctionalArea P_StatisticalKeyFigureItem1 FunctionalArea
Segment P_StatisticalKeyFigureItem1 Segment
Fund P_StatisticalKeyFigureItem1 Fund
GrantID P_StatisticalKeyFigureItem1 GrantID
BudgetPeriod P_StatisticalKeyFigureItem1 BudgetPeriod
ControllingArea I_ControllingObjectEnhanced ControllingArea
CompanyCode I_ControllingObjectEnhanced CompanyCode
AccountAssignmentType I_ControllingObjectEnhanced AccountAssignmentType
CostCenter I_ControllingObjectEnhanced CostCenter
CostCtrActivityType I_ControllingObjectEnhanced CostCtrActivityType
BusinessProcess I_ControllingObjectEnhanced BusinessProcess
OrderID I_ControllingObjectEnhanced OrderID
InternalOrder I_ControllingObjectEnhanced InternalOrder
ProjectInternalID
WBSElementInternalID
SalesDocument I_ControllingObjectEnhanced SalesDocument
SalesDocumentItem I_ControllingObjectEnhanced SalesDocumentItem
ProjectNetwork I_ControllingObjectEnhanced ProjectNetwork
ServiceDocumentType I_ControllingObjectEnhanced ServiceDocumentType
ServiceDocument I_ControllingObjectEnhanced ServiceDocument
ServiceDocumentItem I_ControllingObjectEnhanced ServiceDocumentItem
CostObject I_ControllingObjectEnhanced CostObject
StatisticalKeyFigureCategory I_StatisticalKeyFigure StstcKeyFigCategory
FiscalYearVariant I_ControllingArea FiscalYearVariant
_BusinessProcess I_ControllingObjectEnhanced _BusinessProcess
_ControllingArea I_ControllingObjectEnhanced _ControllingArea
_CostCenter I_ControllingObjectEnhanced _CostCenter
_CostCtrActivityType I_ControllingObjectEnhanced _CostCtrActivityType
_InternalOrder I_ControllingObjectEnhanced _InternalOrder
_Order I_ControllingObjectEnhanced _Order
_ProjectBasicData I_ControllingObjectEnhanced _ProjectBasicData
_SalesDocument I_ControllingObjectEnhanced _SalesDocument
_SalesDocumentItem I_ControllingObjectEnhanced _SalesDocumentItem
_ServiceDocument I_ControllingObjectEnhanced _ServiceDocument
_ServiceDocumentItem I_ControllingObjectEnhanced _ServiceDocumentItem
_ServiceDocumentType I_ControllingObjectEnhanced _ServiceDocumentType
_WBSElementBasicData I_ControllingObjectEnhanced _WBSElementBasicData
_StatisticalKeyFigureCat I_StatisticalKeyFigure _StatisticalKeyFigureCat 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PFISTKEYFIGITM'
@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Statistical Key Figure Items'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
define view P_StatisticalKeyFigureItem as 
select from P_StatisticalKeyFigureItem1 
inner join I_ControllingObjectEnhanced on P_StatisticalKeyFigureItem1.ControllingObject = I_ControllingObjectEnhanced.ControllingObject  
inner join I_StatisticalKeyFigure on P_StatisticalKeyFigureItem1.StatisticalKeyFigure = I_StatisticalKeyFigure.StatisticalKeyFigure and
                                     I_ControllingObjectEnhanced.ControllingArea = I_StatisticalKeyFigure.ControllingArea                                   
left outer join I_ControllingArea on I_StatisticalKeyFigure.ControllingArea = I_ControllingArea.ControllingArea 
                   
{
key P_StatisticalKeyFigureItem1.ControllingObject, 
key P_StatisticalKeyFigureItem1.StatisticalKeyFigure, 
key P_StatisticalKeyFigureItem1.FiscalYear, 
key P_StatisticalKeyFigureItem1.FiscalPeriod, 

@Semantics.unitOfMeasure:true
P_StatisticalKeyFigureItem1.StatisticalKeyFigQtyUnit,
 
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} } P_StatisticalKeyFigureItem1.StatisticalKeyFigureQuantity,
 
P_StatisticalKeyFigureItem1.FunctionalArea, 
P_StatisticalKeyFigureItem1.Segment, 
P_StatisticalKeyFigureItem1.Fund, 
P_StatisticalKeyFigureItem1.GrantID, 
P_StatisticalKeyFigureItem1.BudgetPeriod, 

I_ControllingObjectEnhanced.ControllingArea, 
I_ControllingObjectEnhanced.CompanyCode, 
I_ControllingObjectEnhanced.AccountAssignmentType, 
I_ControllingObjectEnhanced.CostCenter, 
I_ControllingObjectEnhanced.CostCtrActivityType, 
I_ControllingObjectEnhanced.BusinessProcess, 
I_ControllingObjectEnhanced.OrderID, 
I_ControllingObjectEnhanced.InternalOrder, 
// I_ControllingObjectEnhanced.ProjectInternalID, 

cast( I_ControllingObjectEnhanced.ProjectInternalID as fis_projectint_no_conv preserving type ) as ProjectInternalID,
// I_ControllingObjectEnhanced.WBSElementInternalID, 

cast( I_ControllingObjectEnhanced.WBSElementInternalID as fis_wbsint_no_conv preserving type ) as WBSElementInternalID,
I_ControllingObjectEnhanced.SalesDocument, 
I_ControllingObjectEnhanced.SalesDocumentItem, 
I_ControllingObjectEnhanced.ProjectNetwork, 
I_ControllingObjectEnhanced.ServiceDocumentType, 
I_ControllingObjectEnhanced.ServiceDocument, 
I_ControllingObjectEnhanced.ServiceDocumentItem, 
I_ControllingObjectEnhanced.CostObject, 

I_StatisticalKeyFigure.StstcKeyFigCategory as StatisticalKeyFigureCategory,

I_ControllingArea.FiscalYearVariant,

/* Associations */
I_ControllingObjectEnhanced._BusinessProcess, 
I_ControllingObjectEnhanced._ControllingArea, 
I_ControllingObjectEnhanced._CostCenter, 
I_ControllingObjectEnhanced._CostCtrActivityType, 
I_ControllingObjectEnhanced._InternalOrder, 
I_ControllingObjectEnhanced._Order, 
I_ControllingObjectEnhanced._ProjectBasicData, 
I_ControllingObjectEnhanced._SalesDocument, 
I_ControllingObjectEnhanced._SalesDocumentItem, 
I_ControllingObjectEnhanced._ServiceDocument, 
I_ControllingObjectEnhanced._ServiceDocumentItem, 
I_ControllingObjectEnhanced._ServiceDocumentType, 
I_ControllingObjectEnhanced._WBSElementBasicData,
I_StatisticalKeyFigure._StatisticalKeyFigureCat
    
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTENHANCED",
"I_STATISTICALKEYFIGURE",
"P_STATISTICALKEYFIGUREITEM1"
],
"ASSOCIATED":
[
"I_BUSINESSPROCESS",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_INTERNALORDER",
"I_ORDER",
"I_PROJECTBASICDATA",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SERVICEDOCUMENTTYPE",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SRVCDOCITEMBYDOCUMENTTYPE",
"I_STATISTICALKEYFIGURECAT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_CONTROLLINGOBJECTENHANCED",
"I_STATISTICALKEYFIGURE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More