topic select query in Application Development and Automation Discussions

select query

Former Member — Wed, 28 May 2008 11:02:01 GMT

hi friends,

i have problem with this query . can any one help me. here i need to get the max value of stlal comparing matnr.

SELECT a~stlnr

a~stlkn

a~stlal

b~matnr

c~annam

c~idnrk

c~posnr

c~menge

c~meins

c~ausch

INTO TABLE it_final

FROM stas AS a

INNER JOIN mast AS b ON ( b_{stlnr EQ a}stlnr

AND b_{stlal EQ a}stlal )

LEFT OUTER JOIN stpo AS c ON ( c_{stlnr EQ a}stlnr

AND c_{stlkn EQ a}stlkn )

WHERE b~matnr IN so_matnr

AND (( b_{matnr a}stlal ) in (SELECT MATNR MAX( stlal ) FROM mast group by matnr)) .

thank you,

looking for your quick reply.

Re: select query

Former Member — Wed, 28 May 2008 11:18:50 GMT

hi,

i was gone through your code. i cannot directly assign any value to variable .

so first you have to find maximum number and store it in variable.

now use this variable in that query .

if still there is prob reply me.

and try to use FOR ALL ENTRIES with the help of that you can improve your code performance.

Give rewards if Help full.

regards,

vipul.