Hi you experts,
now here is a real challenge for you. Imagine, there is no heaven, only following BI Data:
FI
0FIAR_C03 (0DEBITOR,0COMP_CODE) with "current account value"
100500 ...... 100.000,-
SD
ZSDINVOICE (0CUSTOMER, 0CUST_SALES, 0COMP_CODE, 0DIVISION) with "yearly revenue"
100500 ...... 35.000,-
100501 ...... 30.000,-
100502 ...... 12.000,-
...
And now the task.
in FI there is ONE CustomerNr.(100500) which is paying for himself and for another Customers as well, so therefore in FI there is e.g. 100500 as Customer and this should be set in relation with SD Invoice Data of customers 100500, 100501, 100502
How can I solve this task?
Does anybody have any idea? MultiCube, InfoSet, Hierarchie??
Thank you very much
Standa