Which CDS Views use P_STATISTICALKEYFIGUREITEM1?

P_STATISTICALKEYFIGUREITEM1 is used by 1 CDS view(s), including: P_StatisticalKeyFigureItem.

How many fields does P_STATISTICALKEYFIGUREITEM1 have?

P_STATISTICALKEYFIGUREITEM1 has 11 fields. Key fields: ControllingObject, FiscalPeriod, FiscalYear, StatisticalKeyFigure.

P_STATISTICALKEYFIGUREITEM1

CDS View

Statistical Key Figure Items

P_STATISTICALKEYFIGUREITEM1 is a CDS View in S/4HANA. Statistical Key Figure Items. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

View	Type	Join	VDM	Description
P_StatisticalKeyFigureItem	view_entity	from	COMPOSITE	Statistical Key Figure Items

Fields (11)

Key	Field	CDS Fields	Used in Views
KEY	ControllingObject	ControllingObject	1
KEY	FiscalPeriod	FiscalPeriod	1
KEY	FiscalYear	FiscalYear	1
KEY	StatisticalKeyFigure	StatisticalKeyFigure	1
	BudgetPeriod	BudgetPeriod	1
	FunctionalArea	FunctionalArea	1
	Fund	Fund	1
	GrantID	GrantID	1
	Segment	Segment	1
	StatisticalKeyFigQtyUnit	StatisticalKeyFigQtyUnit	1
	StatisticalKeyFigureQuantity	StatisticalKeyFigureQuantity	1

@AbapCatalog.entityBuffer.definitionAllowed: false
 @Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view entity P_StatisticalKeyFigureItem1 as 
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('001' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

@Semantics: { quantity : {unitOfMeasure: 'StatisticalKeyFigQtyUnit'} }
cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP01Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('002' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP02Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('003' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP03Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('004' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP04Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('005' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP05Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('006' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP06Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('007' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP07Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('008' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP08Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('009' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP09Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('010' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP10Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('011' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP11Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('012' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP12Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('013' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP13Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('014' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP14Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('015' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP15Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}
union all
select from I_PeriodStatisticalKeyFigure 
{
key I_PeriodStatisticalKeyFigure.ControllingObject,
key I_PeriodStatisticalKeyFigure.StatisticalKeyFigure,
key I_PeriodStatisticalKeyFigure.FiscalYear,
key cast( cast('016' as abap.numc(3)) as fins_fiscalperiod preserving type ) as FiscalPeriod,

I_PeriodStatisticalKeyFigure.StatisticalKeyFigQtyUnit,

cast( I_PeriodStatisticalKeyFigure.CtrlgObjStstcKeyFigP16Qty as fis_smexxx preserving type ) as StatisticalKeyFigureQuantity,

I_PeriodStatisticalKeyFigure.FunctionalArea,
I_PeriodStatisticalKeyFigure.Segment,
I_PeriodStatisticalKeyFigure.Fund,
I_PeriodStatisticalKeyFigure.GrantID,
I_PeriodStatisticalKeyFigure.BudgetPeriod

}

Depth:

P_STATISTICALKEYFIGUREITEM1

CDS Views using this table (1)

Fields (11)

Learn More