Recursive Material

136 Views

Hi All,

I have a peculiar requirement

Please find it below.

There is a Select Options for Material.

Based on the Material BOM Explosion should happen.

Now in the resultant set of Materials if the Material (in Select Options) is present and this is treated as Recursive.

For Ex:

s_matnr = 1

now when material 1 is exploded its giving

2 3 4 1

Hence in the above case since 1 is appearing in the exploded set it is treated as "Directly Recursive"

Now again when 2 is exploded

we get 5 6 7

and when 3 is exploded

we get 8 9 10

and so on so forth.

If in any hierarchy / level the material in s_matnr ( 1 ) is appearing then its "Indirectly recursive".

The Explosion will continue for all the resultant set of exploded materials.

Please give me some kind of clue about this.'

The report they want is to display all the Materials with Direct/Indirect Recursive.

Waiting eagerly for your Hints/Replies

Hope you all have understood the requirement.

Please revert for further clarification i shall articulate the requirement .

Thanks

Sri