topic Internal Tab in Application Development and Automation Discussions

Internal Tab

Former Member — Thu, 23 Aug 2007 12:01:29 GMT

Hi,

when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal

table. What will be the result? (2nd internal table contains records).

Re: Internal Tab

seshatalpasai_madala — Thu, 23 Aug 2007 12:03:34 GMT

Hi,

The bahavior of SELECT with FOR ALL ENTRIES when ITAB Is initial is it just ignores the ITAB and fetches data according to the REST OF THE WHERE CLAUSE.

This is what happends when you use your first internal table.

When you use your second internal table which has some data then only those fields whihc match the WHERE CLAUSE are retrived.

Regards,

Sesh

Re: Internal Tab

Former Member — Thu, 23 Aug 2007 12:04:01 GMT

Hi!

Because the first is empty, FOR ALL ENTRIES will check for ALL ENTRIES in the select.

This means a very high runtime and a pathetic performance.

Before using for all entries, check is the table initial or not.

For example: IF NOT gt_table[] IS INITIAL.

Regards

Tamá