topic for all entries-itab empty in Application Development and Automation Discussions

for all entries-itab empty

Former Member — Thu, 21 Jun 2007 14:33:59 GMT

if internal table used in for all entries is empty then what happens?

Former Member — Thu, 21 Jun 2007 14:37:22 GMT

Your going to get all data...It's like using a SELECT-OPTION without data....

Greetings,

Blag.

Former Member — Thu, 21 Jun 2007 14:38:07 GMT

If internal table is empty then

select statement selects all the fields in the DB table...

Regards

Ravi

Former Member — Thu, 21 Jun 2007 14:38:16 GMT

Hi Ramnaryana,

1. If internal table is empty,

then <b>ALL RECORDS will come.</b>

2. Hence, we should always use like this.

<b> if ITAB[] is not initial.

select.... query...

endif.</b>

regards,

amit m.

Former Member — Thu, 21 Jun 2007 14:38:20 GMT

u have to check like this

if itab[] is not initial.

select * from mara into corresponding fields of table itab_2

for all entries in itab

where matnr = itab-matnr.

endif.

Regards

Peram

Former Member — Thu, 21 Jun 2007 14:38:50 GMT

Hello,

You will get all the information...it will select all the data like an empty where.

Bye

Gabriel