topic Data come from difference data source in Application Development and Automation Discussions

Data come from difference data source

Former Member — Mon, 14 May 2007 01:32:31 GMT

In my saturation, my program's data are come from difference data source. For example, the program will retrieve PO balance, material consumption, future consumption and so on. In my program logic, i retrieve all of the material number, the retrieve the PO balance, material consumption... into internal table, then loop the internal table of material number and update this table from internal table of po balance, material consumption..., but i found that the program's running time is long. How to improve the performance or any suggestion for the program logic. Thanks.

Re: Data come from difference data source

Former Member — Mon, 14 May 2007 09:03:16 GMT

good

run your program using SLIN and extended code checker and then you see which are the areas you need to check for the error,besicall you have to change the code in the select statements.

thanks

mrutyun^

Re: Data come from difference data source

Former Member — Mon, 14 May 2007 09:12:44 GMT

Hi,

Few Guildlines:

1. program is slow mainly because Database load is too high, try to reduce it and that load can be shared by ABAP. gotrhough SE30-perfromance tuning.

Also, in Se30 u will get all most important Tips and tricks, follow it,...

2. Try to find out summary table and dont try always to get data from basic tables.

3. Try to use perfect SELECT statemetn with porper joins, which is most important in reduction of load on DB.

4. you can make ABAP part faster, following coding standard like use of Binary search.

5. Use SLIN to find out which part of program is taking too much time, try to reduce it.

Hope this will guide u.

Jogdand M B

Re: Data come from difference data source

Former Member — Mon, 14 May 2007 13:42:16 GMT

Please send me your code. I will be able to help you only if I can see exactly what you are doing.