P_StatisticalKeyFigureItem

 @AbapCatalog.entityBuffer.definitionAllowed: false
 @AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view entity 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, 

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
    
}