select query

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi friend

Try like this

SELECT a~stlnr

a~stlkn

MAX ( 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)) .

Reward points if helpfull