cancel
Showing results for 
Search instead for 
Did you mean: 

Purchasing Report

Former Member
0 Kudos

Hi All,

I am using a Purchasing Variance Report which has material as the variable . i have material material , budget price , actual price as columns i also have plant in the free characteristics.

When i run the report it display all the information but when i restrict the plant the budget prices disappear..

Can someone help me as to how to restrict the plant under the material i.e i have material 400000 in plants xy01 , xy02 and xy03 but i want to view the material details only for xy01 and xy02...

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

May you check in the budget data is maintained against plants in your cube.

In many of cases budget data is maintained at country/Sales org level not at Plant/Location level. So there are chances that your plant characteristics in blank in cube where ever budget qunatities are available in records.

I hope it will help.

Thanks,

S

Former Member
0 Kudos

hi,

I now have plant included in the budget infocube , now the functional people have given me the plant , material and budget values, but theres a problem again...

If a material is available in one plant then the budget value , actual value & Variance values come fine

but the there are 3 plants so for the other 2 plants the budget value is what is given but the actual value is empty so there is a differnece in the variance values.

How do i filter out the plants for which the actual values are null.

Former Member
0 Kudos

Hi,

Do you want to filter for all materials on plants xy01 and xy02 or only for material 400000? You can always drilldown on plant followed by applying a filter for xy01 and xy02. If it is only for material, you can further filter on material 400000. If you need to hardcode for plants xy01 and xy02 alone at all times, you can apply a global filter/characteristic restriction on plant in your query.

--Priya