topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Thu, 26 Apr 2007 03:58:58 GMT

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

Re: reports

Former Member — Thu, 26 Apr 2007 04:00:57 GMT

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

Re: reports

Former Member — Thu, 26 Apr 2007 04:03:54 GMT

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.

Re: reports

Former Member — Thu, 26 Apr 2007 04:04:07 GMT

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

Re: reports

Former Member — Thu, 26 Apr 2007 04:04:09 GMT

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