topic Re: loop at itab where.. in Application Development and Automation Discussions

loop at itab where..

Former Member — Tue, 23 Sep 2008 04:53:12 GMT

Hi all,

Can I restrict for more than one value in my where condition for looping at internal table?

For ex. I have an internal table(ITAB) for purchase order details of different document types.I'ld like to call the data of only document type(BSART) = 'XXXX','YYYY','ZZZZ' only. How can write the loop statement . I have tried with LOOP AT ITAB WHERE BSART CS ( 'XXXX' , 'YYYY' , 'ZZZZ' ).But it's showing syntax error.please help.

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 04:54:34 GMT

Hi,

Try this

LOOP AT ITAB WHERE BSART IN ( 'XXXX' , 'YYYY' , 'ZZZZ' )

Regards,

Surinder

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 04:54:52 GMT

Hi,

Loop at itab where doctype = 'XXX' or
                           doctype = 'YYY' or
                           doctype = 'ZZZ'.




Endloop.

Best regards,

Prashant

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 04:55:45 GMT

Hi Jayasree,

U can try this...

LOOP AT ITAB WHERE BSART IN ( 'XXXX' , 'YYYY' , 'ZZZZ' ).

This should work...

Regards,

Navin

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 04:56:49 GMT

I think you can try the following

Loop at itab where bsart = 'XXXX' or

bsart = 'YYYY' or

bsart = 'ZZZZ'.

endloop.

Loop at itab.

if itab-bsart = 'XXXX' or

itab-bsart = 'YYYY' or

itab-bsart = 'ZZZZ'.

endif.

endloop.

Regards

Re: loop at itab where..

naveen_inuganti2 — Tue, 23 Sep 2008 04:57:59 GMT

Hi...

You cantry like this..,

loop at itab Field1 = A or Field1 = B or Field1 = C

Thanks,

Naveen.I

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:00:05 GMT

Hi Jayasri,

Use :

Loop at itab where BSART = 'XXX' or BSART = 'YYY' or

BSART = 'ZZZ'.

Regards,

Chandra Sekhar

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:02:19 GMT


> Try this
> 
> LOOP AT ITAB WHERE BSART IN ( 'XXXX' , 'YYYY' , 'ZZZZ' )
> Surinder

STNTAX ERROR

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:04:03 GMT


> Hi Jayasree,
> 
> U can try this...
> 
> LOOP AT ITAB WHERE BSART IN ( 'XXXX' , 'YYYY' , 'ZZZZ' ).
> This should work...
> 
> Regards,
> Navin

Sorry It will not work!!

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:15:02 GMT

You can use Ranges and use IN in Where condition.

data: r_basrt type range of bsart.

"populate the range values.


loop at itab where bsart in r_bsart.

endloop.

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:16:32 GMT

Yes,I have already tried that and got syntax error.

Of course, we can write conditions using OR if the doc. type values are two or three. Is there any other solution if there are no. of such particular values to be mentioned in WHERE condition?

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:17:35 GMT

Hi vijay,

I am new to this syntax.Let me try once.Thank u.

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:26:19 GMT

hi,

Try this below code. it will work.

loop at i_po_data into wa_po_data where bsart eq 'XYZ' or bsart eq 'ABC' or basrt eq 'PQR'.

endloop.

Regards,

Siva.

Re: loop at itab where..

Former Member — Tue, 23 Sep 2008 05:27:41 GMT

Thank u Vijay,

my problem is solved. It's working fine.