topic Re: itab problem in Application Development and Automation Discussions

itab problem

Former Member — Tue, 26 Feb 2008 20:08:01 GMT


I've a itab with following values
 

kunnr 	zdelval		zvarval		zcurval 

23456
34344
43646
43553


Now I need to get all remaining values from ZTABLE


query should be like this

SELECT atwb INTO itab-zdelval FROM ZTAB 	      
	WHERE kunnr = 23456
        AND   zval  = '0003'.

SELECT atwb INTO itab-zvarval FROM ZTAB 	      
	WHERE kunnr = 23456
        AND   zval  = '0004'.

SELECT atwb INTO itab-zcurval FROM ZTAB 	      
	WHERE kunnr = 23456
        AND   zval  = '0005'.

How can I write in single SELECT statement
to get all corresponding values with in loop???

please guide me....

Re: itab problem

Former Member — Tue, 26 Feb 2008 20:11:03 GMT

Hi,

you can do this in two ways.

1) FOR ALL ENTRIES : you can use the FOR ALL ENTRIES addition to get the desired output.

2) RANGES : you can loop through the original table and fill the RANGES. then the multiple selects can be reduced using IN addition and the Ranges variable.

Regards,

Nirmal

Re: itab problem

Former Member — Tue, 26 Feb 2008 20:13:57 GMT

thank you for reply nirmal...

please let me know how can i use FOR ALL ENTRIES in more detail...

Re: itab problem

Former Member — Tue, 26 Feb 2008 20:20:40 GMT

Hi,

If you don't want to use 3 selects you can do that in one select.

loop at itab.

SELECT * FROM ZTAB

WHERE kunnr = itab-kunnr.

case ztab-zval.

when '003'.

...

when '004'.

....

when '004'.

....

endcase.

endselect.

endloop.

Re: itab problem

Former Member — Tue, 26 Feb 2008 22:43:20 GMT

I think if you want to do all of this in one SELECT statement, you'll have to JOIN the ZTAB to itself 3 times.

Rob

Re: itab problem

Former Member — Wed, 27 Feb 2008 09:23:17 GMT

Any more suggetions please.!! if possible sample code as well....

Thanks