Skip to Content
0
Sep 02, 2011 at 02:33 PM

Static or global internal table vs buffered table.

952 Views

Hi experts

Please, let me know your thoughts about wich statement is better in terms of performace.

Facts:

my_table is a transparent table with 10 records.

The statement is called 5000 times in the program (like a formula in SD Pricing)

1st Statement:

( the table my_table is NOT buffered in SE13)

Statics: gt_my_table type standard table of my_table.

if gt_my_table[] is initial.
   select * from my_table into table gt_my_table.
endif.
   read table gt_my_table with key field1 = lv_field1.

2nd Statement

(in the second statement the table is fully buffered in SE13)

data: wa_my_table type my_table.

select single * from my_table into wa_my_table
 where field = lv_field1.

Thanks in advance

Matías