Skip to Content
0
Former Member
Nov 08, 2006 at 07:09 PM

What should be the Approach ?

9 Views

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,