Customer Hierarchy reporting when using common division

Hello,

We have a situation, that I hope is not unique and someone can help with a solution. We are using the Standard Customer Hierarchy (6 levels) for both rebate processing and sales reporting. We have many sales organizations and in some cases (not all) we are using "common division". In these cases, we can only link the customer in the customer hierarchy to one division (the common one). However, we report sales at a line item level in which the division is specific to the material. How do I link these results back to the customer hierarchy.

We are currently on R/3 4.5B.

I appreciate any of your comments and advice.

Regards, Ginny