Data come from difference data source

[Former Member]

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.

[Former Member]

hi

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^

[Former Member]

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

[Former Member]

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