Skip to Content
0

Does the I_VIEW of incoming planning buffer give the data in aggregated form in AMDP

Mar 30, 2017 at 04:46 PM

42

avatar image

The aggregation level is on a Info Provider which is a infocube , so does any data coming to the I_VIEW (Incoming planning data to a AMDP) comes aggregated by default or un - aggregated . And what would be the case if the Aggregation level was on a DSO .

IF it comes aggregated then I can use a statement

SELLDAYS =   SELECT FISCPER ,  PHSELLDAY FROM :I_VIEW
               WHERE INFOPROV = 'PHFIBPCST' ;

and if un-agrregated, I will need to put group by clause

SELLDAYS =   SELECT FISCPER ,sum( PHSELLDAY) FROM :I_VIEW
               WHERE INFOPROV = 'PHFIBPCST' 
group by FISCPER; 
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers