reports

[Former Member]

hi gurus,

what is the use of select for all entries in an internal table?

and

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).

[Former Member]

hi Yogi,

if the first internal table doent have any record then all records will be fetched in the 2nd internal table irrespective of the first internal table.

and for all entries can be considered an alternative to nner join.

hope it solves your query

regards,

Navneeth.K

[Former Member]

hi navneeth,

can u give me one example to use this for all entries with sample code.if it's usefull full points pls help me...

thanx,

loki

[Former Member]

For all entries is a substitute of join and efficient than join( took lesser time).

If the first internal table in empty then all the records will be selected in the second internal table. So we always have to check the first internal table before selecting data to second internal table.

[Former Member]

the use of for all entries is here it is goin got check with dat of all the fields of a record if whole recordd matches then only it retrives the data.. in other cases it checks with only one field..

if no record matches in 1st table then it cannot retrive data from second