Skip to Content
0
Former Member
Sep 06, 2007 at 10:49 PM

Formatting query with Structure selection

15 Views

Hi Friends,

I have a requirement, where user would like to group materials belonging to certain material group into RAW MATERIAL and rest into PACKAGING. I did it with Structure selection. Restricted the selections by material group. Now my problem is

User would like to have report as follows

Plant Parent Material Material Total Cost Total %

1010 12345 RAW MATERIAL 98765 10$ 30%

56789 20$ 60%

Result RAWMATERIAL 30$ 94%

PACKAGING 34567 2$ 3%

45267 2$ 3%

Result PACKAGING 4$ 6%

Result 34$ 100%

Is it possible? Because I am getting following result

Plant Parent Material Material Total Cost Total %

1010 12345 RAW MATERIAL 98765 10$ 33%

56789 20$ 66%

PACKAGING 34567 2$ 50%

45267 2$ 50%

Result RAWMATERIAL 30$ 100%

Result PACKAGING 4$ 100%

I am not getting the result at Parent material level, combining RAW MATERIAL and PACKAGING. I hope I am clear.

Thanks and regards,

Balaraj