Group of Vendors

[Former Member]

Hi Gurus,

I have a doubt on Grouping can anyone please help me regarding this. The issue is i displayed the vendors and many materials they are supplying like

Vendor, No.of Material

100, 5

200, 11

1000, 25

and so on....................

Now i want to group the the vendors based on materials like

Range of Materials, No.of Vendors

1 - 10, 5

10-20, 25

>20, 45

So, can anyone help me how to display the report in this way.

Thanks in Advance,

Regards

Ramakrishna Kamurthy

[Former Member]

Issue Solved

[Former Member]

Is the vendor assigned to the material in MM? If yes, you could load it in the master data and then use vendor in 0material or 0mat_plant as a navigational attribute.

[Former Member]

You should create an structure in query for materials. Then you can create 3 selections in this structure with the ranges of materials.