Skip to Content
0
Former Member
Sep 02, 2007 at 09:30 AM

Maintaining a Format in BEx.. How?

9 Views

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?