Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

for all entries

Former Member
0 Kudos

Dear Experts,

Can I use the below statement ???

select a

          b

          c

          from table3

          into table it_table3

          for all entries in it_table2 it_table3

          where<conditions>.

Please suggest whether i can use to internal table name in one for all entries statement or not ?

Kind Regards,

Ajit

1 ACCEPTED SOLUTION

atul_mohanty
Active Contributor
0 Kudos

Hi Ajit -

You can only use one internal table while using for all entries. For all entries are used to avoild nested select.

Also check the internal table to be not blank while using for all entries,

Example -

IF not it_table2 is inital.

select a

          b

          c

          from table3

          into table it_table3

          for all entries in  it_table2

          where a =  it_table2-a.

ENDIF.

Let us know , in case any further help,

3 REPLIES 3

Former Member
0 Kudos

I think no..

you can't add more then one Itab with for all entries after that .

karun_prabhu
Active Contributor
0 Kudos

Ajit,

No. Only one can be used.

Refer help(F1) / ABAPDOCU tcode to understand basic ABAP syntax.

atul_mohanty
Active Contributor
0 Kudos

Hi Ajit -

You can only use one internal table while using for all entries. For all entries are used to avoild nested select.

Also check the internal table to be not blank while using for all entries,

Example -

IF not it_table2 is inital.

select a

          b

          c

          from table3

          into table it_table3

          for all entries in  it_table2

          where a =  it_table2-a.

ENDIF.

Let us know , in case any further help,