Table Details for Standard CC Hierarchy

Hi Experts,

For a report that is being designed in BI, we need to pull one detai in from standard hierarchy. In client's std hierarchy there are seven nodes (levels) & Cost centre appears on the last node i.e. 7th. We need to show FI actuals with cost centres with level 5.

So I tried to find the tables wherein I can see the details like cost centre & all nodes (at least upto level 4...going backward from level/node 7 where CC lies) but so far no success.

Can you enlighten me about this ?

thanks in anticipation,

rgds,

Sameer