Question:
The customer want to have budget information imported into BW, with revenue per months entered into 12 columns. I guess I have to use a return table. I tried to create multiple update rules, but that is not possible towards the same data source.
Does anybody have a how to do list to achieve this? I can get a person skilled in ABAP to help me, but he hasn't done it before either.
Answer:
With the very few info you give, I believe you don't need return tables at all.
Usually, budget figures in R3 are characterized by (at least) cost center, version and year/month.
If you put everything this as characteristic into the cube, then you will have one row per figure.
Just then create a query having cost center drilled down, and year/month drilled across.
Ch