View a Particular Node of Hierarchy at Query Level

[Former Member]

Hi All,

We have requirement wherein we have to display 0MATERIAL and some specific nodes of the Hierarchy maitained on 0MATERIAL and not all nodes above or below those specific nodes.

Required format of report is as follows:

Profitcenter OperationCode Material Volume

In the structure of hierarchy (on 0MATERIAL) the required objects are at the levels as specified below:

Profit center - Level 2

Operation code u2013 Level 3

Material - Level 8

Thanks in advance,

Warm Regards,

Shwati

[Former Member]

Hi Shwati,

One question. you want the columns profit center &operation code in the report? in that case you can keep the material hier unexpanded.

Or you only have to display only that level of hier of material. so that your report has only material and vol as columns?

Regards,

Rathy