topic Re: internal tables in Application Development and Automation Discussions

internal tables

Former Member — Fri, 09 Feb 2007 15:50:19 GMT

Hi all,

there is an internal table itab1 without headerline.

Now i selected data in to that.

if suppose matnr is field in that.

Now i want to select the data for other internal table by using FOR ALL ENTRIES in itab.

select matnr maktx

from makt

into table itab2

for all entries in itab1

where matnr = itab1-matnr.

please tell me above query is right or wrong because we are using for all entries to the table which has no header line.

Re: internal tables

Former Member — Fri, 09 Feb 2007 15:52:06 GMT

Hello ,

Ur coding is correct.

When using for all entries no need to consider whether the table is having header line or not.

Vasanth

Re: internal tables

Former Member — Fri, 09 Feb 2007 15:53:20 GMT

Its ok. Check for not initial of itab before query.

<b>IF NOT ITAB[] IS INITIAL.</b>

select matnr maktx

from makt

into table itab2

for all entries in itab1

where matnr = itab1-matnr.

<b>ENDIF.</b>

Thanks,

Santosh

Re: internal tables

Former Member — Fri, 09 Feb 2007 15:53:42 GMT

Hi,

Before using for all entries pl make sure the itab1 is not empty.

Cheers.

Re: internal tables

Former Member — Fri, 09 Feb 2007 15:54:56 GMT

It's right FOR ALL ENTRIES option doesn't need a table with header line, you only check if the table has some hits:

if not itab1[] is initial.

select matnr maktx

from makt

into table itab2

for all entries in itab1

where matnr = itab1-matnr.

endif.

Because if itab1 is empty the select'll get all records of MAKT.

Max

Re: internal tables

Former Member — Fri, 09 Feb 2007 16:04:26 GMT

thanks to all

Re: internal tables

Former Member — Fri, 09 Feb 2007 16:09:05 GMT

Hi ,

yes ur query is correct ,

but this will give a error if the itab1 is empty .

so , it is good idea to use if not itab[] is initail.

cheers ,

abhishek