Skip to Content
avatar image
Former Member

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

MAP.png (6.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2015 at 03:54 AM

    HI,

    As per my assumption, You are taking MAP rice from DSO Based on MBEW/MBEWH.

    For historical period, (30.09.2015), You need to convert to fiscal period and Less than/Equal to in Key figure restriction with aggregation last value. This can be handled by customer exit variable (Convert input date into fiscal period )

    Additionally, MAP data should be kept separate and display using multi provider.

    Let me know if any doubts.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member RUSHIKESH YEOLE

      Hi Rushikesh

      Thanks for the reply . But my problem is Storage location . I am using Storage location in row in my report (Key- material , plant and storage location).

      If I use a multiprovider also combining both the data , from cube and DSO . how I will be able to populate the MAP price ...as in DSO storage location field is not present .

      Request you to kindly help .

      Regards,

      Jagriti Jha