@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'CFIFINSSKFPLNITM'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Plan Statistical Key Figures per Period'
@VDM.viewType: #CONSUMPTION
//@ObjectModel.representativeKey: 'FiscalPeriod'
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
define view C_PlanFinStatisticalKeyFigItem
as select from I_FinStatisticalKeyFigureItem
{
//I_FinStatisticalKeyFigureItem.GLRecordType,
I_FinStatisticalKeyFigureItem.Ledger, // only for DCL C_PlanFinStatisticalKeyFigItem
I_FinStatisticalKeyFigureItem.CompanyCode,
I_FinStatisticalKeyFigureItem.FiscalYear,
I_FinStatisticalKeyFigureItem.FiscalPeriod,
cast(I_FinStatisticalKeyFigureItem.FiscalYearPeriod as abap.char(8)) as FiscalYearPeriod,
//I_FinStatisticalKeyFigureItem.FiscalYearVariant,
I_FinStatisticalKeyFigureItem.PlanningCategory,
I_FinStatisticalKeyFigureItem.StatisticalKeyFigure,
I_FinStatisticalKeyFigureItem.StatisticalKeyFigureCategory,
I_FinStatisticalKeyFigureItem.ControllingArea, // only for DCL C_PlanFinStatisticalKeyFigItem
I_FinStatisticalKeyFigureItem.Segment,
I_FinStatisticalKeyFigureItem.ProfitCenter,
I_FinStatisticalKeyFigureItem.CostCenter,
cast( I_FinStatisticalKeyFigureItem.StatisticalKeyFigQtyUnit as fis_ui_seinh preserving type ) as StatisticalKeyFigQtyUnit,
//-----------------------------------------------------------------//
// the Intermediate Quantities are needed only for calculation
@Consumption.hidden: true
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
I_FinStatisticalKeyFigureItem.IntmdStatisticalKeyFigFixedQty,
@Consumption.hidden: true
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
I_FinStatisticalKeyFigureItem.IntmdStatisticalKeyFigSumQty,
//@Consumption.hidden: true
//@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//I_FinStatisticalKeyFigureItem.StstclKeyFigIntmdActlFixedQty,
@Consumption.hidden: true
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
I_FinStatisticalKeyFigureItem.StstclKeyFigIntmdPlanFixedQty,
//@Consumption.hidden: true
//@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//I_FinStatisticalKeyFigureItem.StstclKeyFigIntmdActlSumQty,
@Consumption.hidden: true
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
I_FinStatisticalKeyFigureItem.StstclKeyFigIntmdPlanSumQty,
//-----------------------------------------------------------------//
// Quantity = Fixed Quantity + Sum Quantity
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.IntmdStatisticalKeyFigFixedQty'
cast( cast(IntmdStatisticalKeyFigFixedQty as abap.quan(23,3)) as fis_ui_fixed_smexxx_long ) as StatisticalKeyFigFixedQty,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.IntmdStatisticalKeyFigSumQty'
cast( cast(IntmdStatisticalKeyFigSumQty as abap.quan(23,3)) as fis_ui_sum_smexxx_long ) as StatisticalKeyFigSumQty,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.StatisticalKeyFigSumQty + $projection.StatisticalKeyFigFixedQty'
cast( cast(StatisticalKeyFigSumQty + StatisticalKeyFigFixedQty as abap.quan(23,3)) as fis_ui_smexxx_long ) as StatisticalKeyFigureQuantity,
//-----------------------------------------------------------------//
// Actual Quantity = Actual Fixed Quantity + Actual Sum Quantity
//@Consumption.hidden: true
//@AnalyticsDetails.query.hidden: true // ==> is available but hidden at start of app
//@AnalyticsDetails.query.axis: #COLUMNS
//@EndUserText.label: 'StatisticalKeyFigFixedQty'
//@DefaultAggregation: #FORMULA
//@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
//@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails: {
// exceptionAggregationSteps: [{ exceptionAggregationBehavior : #LAST,
// exceptionAggregationElements: ['FiscalPeriod']
// }]
// }
//@AnalyticsDetails.query.formula : '$projection.StstclKeyFigIntmdActlFixedQty'
// cast( cast(1 as abap.quan(23,3)) as fis_ui_act_fixed_smexxx_long ) as StatisticalKeyFigActlFixedQty,
//@Consumption.hidden: true
//@AnalyticsDetails.query.hidden: true // ==> is available but hidden at start of app
//@AnalyticsDetails.query.axis: #COLUMNS
//@EndUserText.label: 'StatisticalKeyFigSumQty'
//@DefaultAggregation: #FORMULA
//@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
//@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails: {
// exceptionAggregationSteps: [{ exceptionAggregationBehavior : #SUM,
// exceptionAggregationElements: ['FiscalPeriod']
// }]
// }
//@AnalyticsDetails.query.formula : '$projection.StstclKeyFigIntmdActlSumQty'
// cast( cast(1 as abap.quan(23,3)) as fis_ui_act_sum_smexxx_long ) as StatisticalKeyFigActlSumQty,
//@Consumption.hidden: true
//@AnalyticsDetails.query.hidden: true // ==> is available but hidden at start of app
//@AnalyticsDetails.query.axis: #COLUMNS
//@EndUserText.label: 'StatisticalKeyFigSumQty'
//@DefaultAggregation: #FORMULA
//@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
//@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.StatisticalKeyFigActlFixedQty + $projection.StatisticalKeyFigActlSumQty'
// cast( cast(1 as abap.quan(23,3)) as fis_ui_act_smexxx_long ) as StatisticalKeyFigureActlQty,
//-----------------------------------------------------------------//
// Plan Quantity = Plan Fixed Quantity + Plan Sum Quantity
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.StstclKeyFigIntmdPlanFixedQty'
cast( cast(StstclKeyFigIntmdPlanFixedQty as abap.quan(23,3)) as fis_ui_pln_fixed_smexxx_long ) as StatisticalKeyFigPlanFixedQty,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.StstclKeyFigIntmdPlanSumQty'
cast( cast(StstclKeyFigIntmdPlanSumQty as abap.quan(23,3)) as fis_ui_pln_sum_smexxx_long ) as StatisticalKeyFigPlanSumQty,
@DefaultAggregation: #SUM
@Semantics.quantity.unitOfMeasure: 'StatisticalKeyFigQtyUnit'
//@AnalyticsDetails.query.formula : '$projection.StatisticalKeyFigPlanFixedQty + $projection.StatisticalKeyFigPlanSumQty'
cast( cast(StatisticalKeyFigPlanFixedQty + StatisticalKeyFigPlanSumQty as abap.quan(23,3)) as fis_ui_pln_smexxx_long ) as StatisticalKeyFigurePlanQty,
//-----------------------------------------------------------------------------------------------
I_FinStatisticalKeyFigureItem.FunctionalArea,
I_FinStatisticalKeyFigureItem.BusinessArea,
//I_FinStatisticalKeyFigureItem.BudgetPeriod,
//I_FinStatisticalKeyFigureItem.OrderID,
I_FinStatisticalKeyFigureItem.CostCtrActivityType,
//I_FinStatisticalKeyFigureItem.WBSElementInternalID, // we use the external WBSElement (at time of posting)
I_FinStatisticalKeyFigureItem.WBSElement,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.ProjectInternalID, // not filled
//
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.Project, // not filled
I_FinStatisticalKeyFigureItem.ControllingBusTransacType,
//I_FinStatisticalKeyFigureItem.AccountAssignmentType,
I_FinStatisticalKeyFigureItem.ControllingObject,
I_FinStatisticalKeyFigureItem.ControllingObjectClass
//I_FinStatisticalKeyFigureItem.OrderCategory
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.ProjectNetwork, // not filled
//
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.RelatedNetworkActivity, // not filled
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.BusinessProcess, // not in cloud
//
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.CostObject, // not in cloud
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.Fund,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.GrantID,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.SalesOrder,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.SalesOrderItem,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.ServiceDocumentType,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.ServiceDocument,
//@AnalyticsDetails.query.axis: #FREE
//@AnalyticsDetails.query.totals: #SHOW
//I_FinStatisticalKeyFigureItem.ServiceDocumentItem
//FISCALYEARPERIOD,
//STATISTICALKEYFIGUREITEM,
//ISSPECIALPERIOD,
//CONTROLLINGAREA,
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINSTATISTICALKEYFIGUREITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/