how get quantity based Material wise ?

[Former Member]

My req is to get the data based on material ..in SAP QUERY

Suppose in table ZMATQ.

Input:

Material. Quantity currency(price).

1001 10 20.00

1001 20 25.00

1001 25 30.00

2001 40 45.00

2001 45 28.99

2001 50 37.00

In this they need drill down of quantity.

Like 1001 they need all quantity in drill down.

N in list it sld display only one material no at time

E.x

Output:

Material quantity currency(price)

1001 drill down of all quantity Which come in 1001 material respective price

2001 drill down of all quantity Which come in 2001 material respective price.

How to do this as I m taking from single table ..

[Former Member]

Thxs