topic small query.... in Application Development and Automation Discussions

small query....

Former Member — Mon, 04 Aug 2008 12:43:54 GMT

Hi frnds,

In case of FOR ALL ENTRIES, we are checking the prerequisite,

whether the table contains data or not, by using

if TABLE IS NOT INITIAL.

my doubt is, if we doesn't use the statement IF TABLE IS NOT INITIAL, then what happens.................kindly let me know the ans..

regards,

rav.

Re: small query....

Former Member — Mon, 04 Aug 2008 12:45:04 GMT

Then all the data of second database table (i.e. one in next SELECT statement ) will be selected.

regards,

anirban

Re: small query....

bpawanchand — Mon, 04 Aug 2008 12:45:13 GMT

well if table is initial then what it will read so teh SY-SUBRC value will be 4.

Regards

pavan

Re: small query....

RichHeilman — Mon, 04 Aug 2008 12:45:49 GMT

If you do NOT check that the table has data, then the next SELECT statement with the FOR ALL ENTRIES, will bring back ALL records for that database table, and this would be wrong, and take a lot of time, potentiallly.

Regards,

Rich Heilman

Re: small query....

Former Member — Mon, 04 Aug 2008 12:46:57 GMT

Hi RAVKP ,

Even though if u don't use if TABLE IS NOT INITIAL.statement it will work unless the table contains value .

Regards,

Vikram.S

Re: small query....

Former Member — Mon, 04 Aug 2008 12:47:51 GMT

Hi,

1. If we don't check IF ITAB[] is not inital,

then suppose the itab does not have any records.

So logically, we should not get any matching records.

2. BUT, it does not happen, and the system fetches

ALL records.

It is similar as if we had not written/used for all entries.

regards,

amit m.

Re: small query....

Former Member — Mon, 04 Aug 2008 12:47:52 GMT

hiii

if data is there in first internal table then if you use select with for all entries without using if TABLE IS NOT INITIAL..then it will not effect...but if data is not there then how select query will work as it will have JOIN condition with for all entries like

SELECT matnr " Material Number

werks " Plants

prctr " Profit Center

FROM marc

INTO TABLE i_marc

FOR ALL ENTRIES IN i_mara

WHERE matnr = i_mara-matnr

AND werks IN s_werks.

in this if i_mara will not have any value then this statement wil not work properly..so it will give you a wrong output or error.

regards

twinkal

Re: small query....

Former Member — Mon, 04 Aug 2008 12:48:50 GMT

Hi,

It will bring all the data records from the corresponding table.

suppose

select carrid

connid

for all entries t_spfli

from sflight.

where carrid eq t_spfli-carrid.

in this case if t_spfli is empty

then it will bring all records irrespective condition from sflight.