Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MAP price issue in BEX report

Hi All

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 .

Regards,

Jagriti Jha

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question