P_StatKeyFigValueAssignment

@AbapCatalog.sqlViewName: 'PWUSKFVA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  private: true,
  viewType: #CONSUMPTION
}
define view P_StatKeyFigValueAssignment
  as select from I_FinStatisticalKeyFigureItem
  association [1..1] to I_Ledger                 as _Ledger                 on  I_FinStatisticalKeyFigureItem.Ledger = _Ledger.Ledger
  association [0..1] to I_CostCenterActivityType as _CostCenterActivityType on  $projection.ControllingArea     =  _CostCenterActivityType.ControllingArea
                                                                            and $projection.CostCtrActivityType =  _CostCenterActivityType.CostCtrActivityType
                                                                            and $projection.ValidityStartDate   >= _CostCenterActivityType.ValidityStartDate
                                                                            and $projection.ValidityStartDate   <= _CostCenterActivityType.ValidityEndDate
  association [0..1] to I_ProfitCenter           as _ProfitCenter           on  $projection.ControllingArea   =  _ProfitCenter.ControllingArea
                                                                            and $projection.ProfitCenter      =  _ProfitCenter.ProfitCenter
                                                                            and $projection.ValidityStartDate >= _ProfitCenter.ValidityStartDate
                                                                            and $projection.ValidityStartDate <= _ProfitCenter.ValidityEndDate
  association [0..1] to I_CostCenter             as _CostCenter             on  $projection.ControllingArea   =  _CostCenter.ControllingArea
                                                                            and $projection.CostCenter        =  _CostCenter.CostCenter
                                                                            and $projection.ValidityStartDate >= _CostCenter.ValidityStartDate
                                                                            and $projection.ValidityStartDate <= _CostCenter.ValidityEndDate
{
      //I_FinStatisticalKeyFigureItem

  key Ledger,
  key CompanyCode,
  key StatisticalKeyFigure,
  key FiscalYear,
  key FiscalPeriod,
  key StatisticalKeyFigureItem,
      FiscalYearPeriod,
      FiscalYearVariant,
      IsSpecialPeriod,
      StatisticalKeyFigureCategory,
      StatisticalKeyFigQtyUnit,
      StatisticalKeyFigureQuantity,
      StatisticalKeyFigFixedQty,
      StatisticalKeyFigSumQty,
      StatisticalKeyFigureActlQty,
      StatisticalKeyFigurePlanQty,
      StatisticalKeyFigActlFixedQty,
      StatisticalKeyFigPlanFixedQty,
      StatisticalKeyFigActlSumQty,
      StatisticalKeyFigPlanSumQty,
      IntmdStatisticalKeyFigFixedQty,
      IntmdStatisticalKeyFigSumQty,
      StstclKeyFigIntmdActlFixedQty,
      StstclKeyFigIntmdPlanFixedQty,
      StstclKeyFigIntmdActlSumQty,
      StstclKeyFigIntmdPlanSumQty,
      GLRecordType,
      PlanningCategory,
      CostCenter,
      ProfitCenter,
      FunctionalArea,
      BusinessArea,
      ControllingArea,
      Segment,
      ControllingBusTransacType,
      AccountAssignmentType,
      ControllingObject,
      ControllingObjectClass,
      _ControllingObject.ControllingObjectType,
      OrderID,
      OrderCategory,
      WBSElement,
      Fund,
      GrantID,
      BudgetPeriod,
      SalesOrder,
      SalesOrderItem,
      CostCtrActivityType,
      ServiceDocumentType,
      ServiceDocument,
      ServiceDocumentItem,
      _FiscalPeriod.FiscalPeriodStartDate as ValidityStartDate,
      _FiscalPeriod.FiscalPeriodEndDate   as ValidityEndDate,
      /* Associations */
      //I_FinStatisticalKeyFigureItem

      _BudgetPeriod,
      _BusinessArea,
      _CompanyCode,
      _ControllingArea,
      _ControllingObject,
      _CostCenter,
      _CostCenterActivityType,
      _FiscalPeriod,
      _FiscalYear,
      _FiscalYearVariant,
      _FunctionalArea,
      _Ledger,
      _LedgerCompanyCodeVH,
      _Order,
      _PlanningCategory,
      _ProfitCenter,
      _SalesDocument,
      _SalesDocumentItem,
      _Segment,
      _StatisticalKeyFigure,
      _StatisticalKeyFigureCat,
      _UnitOfMeasure
}
where
  _Ledger.IsLeadingLedger = 'X'