topic Re: it table in Application Development and Automation Discussions

it table

Former Member — Tue, 08 Nov 2005 12:11:00 GMT

LOOP AT mdeqp.

LOOP AT mdcw.

SELECT equnr

FROM viser02

INTO viser02-equnr

WHERE sdaufnr = mdcw-zs_vbeln

AND posnr = mdcw-zs_posnr

AND equnr = mdeqp-equnr.

IF sy-subrc = 0.

mdcw-zs_equnr = viser02-equnr.

ENDIF.

MODIFY mdcw.

ENDSELECT.

ENDLOOP.

i get error not defined viser02-equnr

i tried select single too and it's working.

thanks

Re: it table

Former Member — Tue, 08 Nov 2005 12:12:12 GMT

tried select single too and it's not working.

sorry.

Re: it table

Former Member — Tue, 08 Nov 2005 12:12:48 GMT

Hi,

Did you declare VISER02 with TABLES statement?

Like,

TABLES: VISER02.

Otherwise do the following,

LOOP AT mdeqp.

LOOP AT mdcw.

SELECT equnr FROM viser02

<b>INTO mdcw-zs_equnr</b>

WHERE sdaufnr = mdcw-zs_vbeln

AND posnr = mdcw-zs_posnr

AND equnr = mdeqp-equnr.

<b>*IF sy-subrc = 0.

*mdcw-zs_equnr = viser02-equnr.

*ENDIF.

IF sy-subrc NE 0.

CLEAR mdcw-zs_equnr.

ENDIF.</b>

MODIFY mdcw.

ENDSELECT.

ENDLOOP.

Sri

Message was edited by: Srikanth Pinnamaneni

Re: it table

Former Member — Tue, 08 Nov 2005 12:14:37 GMT

Yehiel,

Add the following code to u r program:

tables: viser02.

Thanks

Kam

Re: it table

Former Member — Tue, 08 Nov 2005 12:14:45 GMT

Hi Braha,

Try declaring VISER02 in the Tables statement.

Tables : VISER02. at the top of the program.

Thanks,

Vinod.

Don't forget to reward points if u got the solution.

Re: it table

Former Member — Tue, 08 Nov 2005 12:14:57 GMT

Try this declaration:

TABLES: viser02.

It would help to re-visit your code, the select is not optimized and might run into performance issues. Why not try a SELECT..FOR ALL ENTRIES?

Sudha

Re: it table

Former Member — Tue, 08 Nov 2005 12:20:28 GMT


DATA:
  lv_equnr type equnr.

LOOP AT mdeqp.
  LOOP AT mdcw.

    SELECT SINGLE equnr
           INTO lv_equnr
           FROM viser02
           WHERE sdaufnr = mdcw-zs_vbeln
             AND posnr = mdcw-zs_posnr
             AND equnr = mdeqp-equnr.
    IF sy-subrc EQ 0.
      mdcw-zs_equnr = lv_equnr.
      MODIFY mdcw.
    ENDIF.
  ENDLOOP.
ENDLOOP.

hth, Tim

Re: it table

Former Member — Tue, 08 Nov 2005 12:25:22 GMT

hi,

data : l_equnr like viser02-equnr.

SELECT equnr

FROM viser02

>>INTO viser02-equnr

into l_equnr

WHERE sdaufnr = mdcw-zs_vbeln

AND posnr = mdcw-zs_posnr

AND equnr = mdeqp-equnr.

IF sy-subrc = 0.

mdcw-zs_equnr = l_equnr.

ENDIF.

note: your using nested loop and select endselect inside the nested loop, it will affect the performence very much.

cheers,

sasi