MAP price issue in BEX report

[Former Member]

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

[Rushikesh_Yeole]

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.

[Rushikesh_Yeole]

Additionally suggestion is, on Monthly basis you should extract MBEWH data and overwrite MBEW data with current fiscal period. This will give correct MAP in all cases.

[Former Member]

Hi Rushikesh

I am already doing a monthly load to extract MBEWH data and overwriting MBEW data . But I am populating this MAP value in 0IC_C03 cube itself .  I am populating MAP price against every stock movement based on their posting date (Period).

Now data in cube 0IC_C03 is perfect . Only problem is coming while running the report . Since I am using Material , plant and storage location as key in report (MAP price is based on Plant not based on storage location as per SAP standard) .

So when I am running the report for 30.09.2015 , say of material X , which has two storage location XA and XB.

Data in Cube 0IC_C03

material  Storage Location     Calday                MAP

X              XA                       28.09.2015           13

X              XB                       16.08.2015           11

So when I run the inventory report as of 30.092015 data comes like

MATERIAL    SLOC    MAP

X                    XA        13

X                    XB        11

But ideally MAp for both storage location should be 13 , but since there is no movement for material X in SLOC XB  , in my cube value is populated as the last period MAP price only .

Am I  missing something. I hope my clarifies my problem here . It would be really great if you can help me out in this.

Regards,

Jagriti Jha

[Rushikesh_Yeole]

HI,

If you add batch/any additional dimension in report level, then it will create more problems.

As per my knowledge, the KF in inventory cube will not give correct results.

I will suggest, as you have already MAP data available in DSO.

DSO Key fields: Material, Plant.

Using multi provider, you can link with cube data with above fields.

Fiscal period should not be linked in multi provider. Because for every Mat /Plant / fiscal period combination entry will not be present in MAP DSO.

Using customer variable you can display MAP [Exception aggregation and restriction of  fiscal period variable on MAP key figure]

Please let me know your thoughts.

Key figure MAP should not have basic aggregation as SUM (Key figure properties)

[Former Member]

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