04-09-2006 12:36 PM
select matnr sernr equnr from viser02
into ( i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr)
whats wrong?
04-09-2006 12:44 PM
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
04-09-2006 12:46 PM
04-09-2006 12:49 PM
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
04-09-2006 12:49 PM
i hope u have given spaces before and after ')','('.
what's the error msg??
04-09-2006 12:51 PM
into ( i_matnrs-matnr , i_matnrs-sernr,i_matnrs-equnr )
err----comma without precedind ...(SELECT)
04-09-2006 12:51 PM
select matnr sernr equnr from viser02
into ( i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr )
this dont work again
i am exosted
04-09-2006 12:52 PM
04-09-2006 12:53 PM
i made
into ( i_matnrs-matnr, i_matnrs-sernr, i_matnrs-equnr )
err again
04-09-2006 12:54 PM
select matnr sernr equnr from viser02
into (i_matnrs-matnr,i_matnrs-sernr,i_matnrs-equnr) .
space after <b>into</b>
no space after <b>(</b>
no space before <b>)</b>
or just copy paste the statement above.
Regards
Raja
04-09-2006 12:57 PM
i made
- = 'space'
select matnr sernr equnr from viser02
into-(i_matnrs-matnr-,-i_matnrs-sernr-,-i_matnrs-equnr)
i get err
04-09-2006 1:04 PM
copy paste your code - the select statement and the declaration for i_matnrs.
i will correct it and post it back here.
Raja
04-09-2006 1:09 PM
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
04-09-2006 1:23 PM
select matnr sernr equnr from viser02
into (i_matnrs-matnr , i_matnrs-sernr , i_matnrs-equnr)
where sdaufnr = vbdka-vbeln and
posnr = tvbdpa-posnr.
04-09-2006 2:08 PM
04-10-2006 4:26 AM
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.
04-09-2006 12:45 PM
use endselect after the select statement.
or extract into internal table.