Report requirement includes a specific order that is to be maintained.
Finished goods as well as the description is there and three key fields and the raw materials used.
The format is :
Finished Good MATNR as Central line(first raw)
Then under that the corresponding description also has to come. Under this the key figures should come.. As for each finished goods 4 key figures . But the user want to display only one time the FG number and below its description.
Then there should be a fixed format of Raw materials and that also should be in drill down format. So each key fiigure holds the value with respect to the raw materials.
FGMATNR
MATNR DESCRIPTION
KEY1 KEY2 KEY3 KEY 4
Raw material TYPE1
x 1 2 3 4
y 11 12 13 14
Raw material TYPE2
q 1 2 3 4
w 11 12 13 14
etc....
<b>But what I am getting is</b>
KEY1 KEY2 KEY3 KEY 4
MATNR MATNR MATNR MATNR
DESC DESC DESC DESC
Raw material TYPE1
x 1 2 3 4
y 11 12 13 14
q 1 2 3 4
w 11 12 13 14
How to modify the report so that to get the report in the format the client specifying. Can some one explian the same in detail?