Question on Function module
I have a set of ECC tables from which I need to extract the data from. Some calculations need to be made on the fly based on some of these fields. and the entire set need to be loaded into BW.
Can any one tell me what is the best way to handle this scenario?
In ECC there is a program which extracts the data from multiple tables and does the calculations. But, this is a non-executable Program and this is executed by a ZTCode.
I thought of writing a function module to execute the Tcode and build an extractor based on the Function module, but the problem is, the ZTcode when executed has input value screen and can accept only one value at a time.
I need to calculate the data for all the records not one at a time.