Table link to get superior order using suborder

[shiva43124]

Hi,

In my case i have order hierarchy upto 4 levels, Example Order A is superior to B,

B is superior to C

C is superior to D

D is superior to E

Here I want to get superior order A by passing sub Order E.

Is there any table link or FM to get this?

I have checked table AFKO here i get only sub order by passing superior order (MAUFNR) not superior order.

Please help..

Regards,

Shiva.

[shiva43124 · Accepted solution]

Got it!!

In table AFKO if we pass sub order we will get superior order (MAUFNR)

and lead superior order (LEAD_AUFNR)

Thanks.

[former_member596716]

I think you would have to hit AFKO repeatedly to get this info. I don't believe there is a standard function module to retrieve this data; one of my clients wrote their own to do this.