topic Re: regarding 'Select' statement in Application Development and Automation Discussions

regarding 'Select' statement

Former Member — Fri, 26 Dec 2008 11:15:25 GMT

Hi,

I coded the 'Select' statement like this

SELECT SETCLASS

SUBCLASS

SETNAME

VALFROM

VALTO FROM SETLEAF INTO TABLE T_GLREPAIR WHERE SETCLASS = '0109'

AND SUBCLASS = 'TEIL'

AND SETNAME = '10001'.

Now i will get account range based on Valfrom and Valto for the Account group '10001'..

I have to bring HSL01 and HSL02 values from GLPCT for all the accounts that are between Valfrom and Valto into another internal table. How can i pass this range into RACCT of GLPCT table.Please help in solving this issue.

Thanks

K Srinivas

Re: regarding 'Select' statement

Former Member — Fri, 26 Dec 2008 11:22:27 GMT

use for all entries.

select * from glpct

into t_glpct

for all entries in t_glrepair

where RACCT GE t_glrepair-valfrom

and RACCT LE t_glrepair-valfrom.

Re: regarding 'Select' statement

former_member404244 — Fri, 26 Dec 2008 11:29:04 GMT

Hi,

Try like this

LOOP AT T_GLREPAIR .

Select single from GLPCT into <workarea> where...

Now u check whether the value which u want to select is between VALFROM and VALTO. If yes then

append to another internal table.

ENDLOOP.

Regards,

Nagaraj