topic Re: Problem in using for all entries in Application Development and Automation Discussions

Problem in using for all entries

Former Member — Mon, 22 May 2006 07:36:42 GMT

Hi,

I am populating one field of an internal table for all entries existing in that internal table.That field is getting populated but rest of the fields changed to its default values.

Please check the code

SELECT a_{matnr a}werk a_{lmenge01 a}lmenge02 a_{lmenge03 a}lmenge04 a_{lmenge05 a}lmenge06 a~lmenge07

a_{lmenge08 a}prueflos a_{art a}charg b_{vcode b}vdatum

INTO CORRESPONDING FIELDS OF TABLE i_out

FROM qals AS a INNER JOIN qave AS b

ON a_{prueflos = b}prueflos

WHERE a~matnr IN s_matnr

AND a~werk IN s_werk

AND a~art IN s_art

AND a~stat33 = 'X'

AND b~vcodegrp IN s_vcdgrp

AND b~vcode IN s_vcode

AND b~vdatum IN s_vdatum.

I am getting error here i_out is getting populated in teh first select statement

SELECT mncod

INTO CORRESPONDING FIELDS OF TABLE i_out

FROM qmsm

FOR ALL ENTRIES IN i_out

WHERE qmnum = i_out-qmnum.

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:42:45 GMT

Hai Mukesh

qmnum field not declared/Select in i_out at the above select query

check it and try again

Thanks & regards

Sreeni

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:43:09 GMT

Hi Mukesh,

u should specify a different internal table in the addition

"INTO CORRESPONDING FIELDS OF TABLE i_out"

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:44:05 GMT

SELECT mncod

INTO CORRESPONDING FIELDS OF TABLE i_out---->wrong

FROM qmsm

FOR ALL ENTRIES IN i_out

WHERE qmnum = i_out-qmnum.

how u can select into same table for all entries of same table....

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:44:17 GMT

Hi Mukesh,

In your first internal table i_out there is no field seleced qmnum[/b, but you used for all entries while selecting data from qmsm table with WHERE clause WHERE qmnum = i_out-qmnum.

select qmnum field and put it into i_out internal table.

I hope it helps you, if the same please reward points

Regards

Prabhu

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:55:32 GMT

send me solution not my problem

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:56:27 GMT

Try changing your query in the following way....


SELECT a~matnr a~werk a~lmenge01 a~lmenge02 a~lmenge03 a~lmenge04
a~lmenge05 a~lmenge06 a~lmenge07
a~lmenge08 a~prueflos a~art a~charg b~vcode b~vdatum
<b>c~mncod</b>
FROM qals AS a INNER JOIN qave AS b
ON a~prueflos = b~prueflos
<b>join qmsm as c
ON a~prueflos = c~qmnum</b>
INTO CORRESPONDING FIELDS OF TABLE i_out
WHERE a~matnr IN s_matnr
AND a~werk IN s_werk
AND a~art IN s_art
* AND a~stat33 = 'X'
AND b~vcodegrp IN s_vcdgrp
AND b~vcode IN s_vcode
AND b~vdatum IN s_vdatum.

with the above you can do the two steps only once .

you need not to go for for all entries .

Regards

vijay

Re: Problem in using for all entries

Former Member — Mon, 22 May 2006 07:57:39 GMT

declare internal table i_out1 same as i_out.

SELECT a_{matnr a}werk a_{lmenge01 a}lmenge02 a_{lmenge03 a}lmenge04 a_{lmenge05 a}lmenge06 a~lmenge07

a_{lmenge08 a}prueflos a_{art a}charg b_{vcode b}vdatum

INTO CORRESPONDING FIELDS OF TABLE i_out

FROM qals AS a INNER JOIN qave AS b

ON a_{prueflos = b}prueflos

WHERE a~matnr IN s_matnr

AND a~werk IN s_werk

AND a~art IN s_art

AND a~stat33 = 'X'

AND b~vcodegrp IN s_vcdgrp

AND b~vcode IN s_vcode

AND b~vdatum IN s_vdatum.

i_out1[] = i_out[].

SELECT mncod

INTO CORRESPONDING FIELDS OF TABLE i_out1

FROM qmsm

FOR ALL ENTRIES IN i_out

WHERE qmnum = i_out-qmnum.