What should be the Approach ?

[Former Member]

I have to get open Sales Order from SAP to BW and report on it .

The data structure is like :

"partno , desc , order no , del no , qty on order , qty delivered , qty in inventory , qty in 10 w , qty in 11w , qty of type 916 , balance qty ... "

I am planning to write an extractor FM that would fetch all the open SO and then for each get the quantity , do the calculation and then pass it to BW for reporting ? In BW i plan to make a infosuorce of same type and then load into a cube ?

OR

Get the SO in a seperate infosource and Inventory data in a seperate and then create a multiprovider ?

What is the best practice / better approach for this kind of scenario where data is fetched from various SAP tables?

Thanks,

[Former Member]

Hi,

You'll have to weigh the pros and cons of both approaches. Ex if you do all the calculations in the FM and then transfer the data to BW, the initial extraction may take time but the reporting will be fast.

In the second approach, reporting might be slower, as the report runs off the multiprovider.

Cheers,

Kedar