MAP price issue in BEX report
I am creating a Inventory report on 0IC_C03 cube , I have a requirement to display the MAP price based on calender date . I have done that by extracting data from MBEW and MBEWH tables . I am facing a issue while displaying the data in BEX report . I am using Material , plant and storage location in row in my BEX report .Now the problem is MAP price is not based on storage location , it's based on plant . So if I am running the report for stock as of 30.09.2015 , my report should should show the MAP price of based on 30.09.2015 . I am using a aggregation for MAp key figure as "Last value " based on calday . Now since i am using storage location in row , for few material in particular storage location is no movement happened in period 09, it is picking the last month map price.
as shown in above example , it should show MAP price as 0.49 for both the line where as it's showing 0.43 for storage location SW26 .
Is there any way I can populate MAp price without considering storage location ? I know the fact that if I remove Storage location I can achieve that but i can't remove Storage location .
I am looking for any alternative method. Request you all BEX gurus to help me on this . It's kinda urgent .