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 ?
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?