topic Re: simple QA in Application Development and Automation Discussions

simple QA

Former Member — Sun, 09 Apr 2006 11:36:24 GMT

select matnr sernr equnr from viser02

into ( i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr)

whats wrong?

Re: simple QA

athavanraja — Sun, 09 Apr 2006 11:44:33 GMT

whats the error you are getting.

i just copy pasted your code and found two issues.

1. remove the space between ( and imatnrs-matnr

2. add endselect.

data: i_matnrs type viser02 .

select matnr sernr equnr from viser02

into (i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr) .

endselect .

Regards

Raja

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:45:24 GMT

use endselect after the select statement.

or extract into internal table.

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:46:14 GMT

i made endselect

your suggest dont work

Re: simple QA

athavanraja — Sun, 09 Apr 2006 11:49:35 GMT

you have ot give us more info to get better help.

are you getting error message or

the data is not getting populated into the variable

did you copy/paste the code sample i have posted. its a tested one.

Regards

Raja

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:49:52 GMT

i hope u have given spaces before and after ')','('.

what's the error msg??

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:51:06 GMT

into ( i_matnrs-matnr , i_matnrs-sernr,i_matnrs-equnr )

err----comma without precedind ...(SELECT)

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:51:59 GMT

select matnr sernr equnr from viser02

into ( i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr )

this dont work again

i am exosted

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:52:14 GMT

give space after ,

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:53:40 GMT

i made

into ( i_matnrs-matnr, i_matnrs-sernr, i_matnrs-equnr )

err again

Re: simple QA

athavanraja — Sun, 09 Apr 2006 11:54:49 GMT

select matnr sernr equnr from viser02

into (i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr) .

space after into

no space after (

no space before )

or just copy paste the statement above.

Regards

Raja

Re: simple QA

Former Member — Sun, 09 Apr 2006 11:57:40 GMT

i made

- = 'space'

select matnr sernr equnr from viser02

into-(i_matnrs-matnr-,-i_matnrs-sernr-,-i_matnrs-equnr)

i get err

Re: simple QA

athavanraja — Sun, 09 Apr 2006 12:04:32 GMT

copy paste your code - the select statement and the declaration for i_matnrs.

i will correct it and post it back here.

Raja

Re: simple QA

Former Member — Sun, 09 Apr 2006 12:09:22 GMT

Rani,

data: i_matnrs type viser02 .

select matnr sernr equnr from viser02

into (i_matnrs-matnr, i_matnrs-sernr, i_matnrs-equnr).

endselect .

This shoulf work, however, if you are looking for dumping the data into a table, the declare i_matnrs as a internal table and APPEND i_matnrs before ENDSELECT.

regards,

Ravi

Re: simple QA

Former Member — Sun, 09 Apr 2006 12:23:21 GMT

select matnr sernr equnr from viser02

into (i_matnrs-matnr , i_matnrs-sernr , i_matnrs-equnr)

where sdaufnr = vbdka-vbeln and

posnr = tvbdpa-posnr.

Re: simple QA

Former Member — Sun, 09 Apr 2006 13:08:57 GMT

hv u solved the query?

Re: simple QA

Former Member — Mon, 10 Apr 2006 03:26:58 GMT

Hi Rani,

select matnr sernr equnr from viser02

into (i_matnrs-matnr , i_matnrs-sernr , i_matnrs-equnr)

where sdaufnr = vbdka-vbeln and

posnr = tvbdpa-posnr.

In the above program code that you have posted, I suppose I_MATNRS is an internal table of VISER02 with header line. I also suppose that the table is VBDPA and not TVBDPA.

You need not have to provide space between the bracket & the character or between comma & character.

Just look at the code that I have modified.

tables: vbdka,vbdpa,viser02.

data: i_matnrs type viser02 occurs 0 with header line.

select matnr sernr equnr

into (i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr)

from viser02

where sdaufnr = vbdka-vbeln and

posnr = vbdpa-posnr.

endselect.

This will not give any compilation errors.

Regards,

SP.