Subquery

[Former Member]

Hi All

I want to write a query that contains subquery , any clues on that ? ( for getting max value etc )

Thanks

Sandy

[Former Member]

Hi Sandy,

Extract from the Sap help :

DATA: WA TYPE SFLIGHT. 

SELECT * FROM SFLIGHT 
    INTO WA 
    WHERE SEATSOCC = ( SELECT MAX( SEATSOCC ) FROM SFLIGHT ). 
  WRITE: / WA-CARRID, WA-CONNID, WA-FLDATE. 
ENDSELECT. 

Hope it helps,

Regards,

Erwan.

[Former Member]

Another sap help

http://help.sap.com/saphelp_nw04/helpdata/en/dc/dc7614099b11d295320000e8353423/content.htm

[Former Member]

Hi Sandy,

here is the example.

SELECT * FROM mara

INTO imara

WHERE matnr = ( SELECT max( matnr ) FROM mara ).

write:/1 imara-matnr.

ENDSELECT.

Also you can use EXISTS with some little variations

/Manik

[Former Member]

Hi Manik,

I don't really see in what way your post is different of mine...

Regards,

Erwan.

[Former Member]

Hi Ewan,

It's the same, just the it was a time elapsed between your post and mine

cheers.

/Manik