@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PFISTKEYFIGITM1'
@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_StatisticalKeyFigureItem1 as
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('001' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP01Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('002' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP02Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('003' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP03Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('004' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP04Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('005' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP05Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('006' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP06Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('007' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP07Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('008' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP08Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('009' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP09Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('010' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP10Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('011' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP11Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('012' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP12Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('013' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP13Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('014' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP14Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('015' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP15Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
union all
select from I_PeriodStatisticalKeyFigure
{
key ControllingObject,
key StatisticalKeyFigure,
key FiscalYear,
key cast( cast('016' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,
@Semantics.unitOfMeasure:true
StatisticalKeyFigQtyUnit,
@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( CtrlgObjStstcKeyFigP16Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,
FunctionalArea,
Segment,
Fund,
GrantID,
BudgetPeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERIODSTATISTICALKEYFIGURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/