topic Re: Subquery in Application Development and Automation Discussions

Subquery

Former Member — Mon, 08 Aug 2005 12:38:03 GMT

Hi All

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

Thanks

Sandy

Re: Subquery

Former Member — Mon, 08 Aug 2005 12:53:00 GMT

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.

Re: Subquery

Former Member — Mon, 08 Aug 2005 12:55:08 GMT

Another sap help

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

Re: Subquery

Former Member — Mon, 08 Aug 2005 13:12:25 GMT

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

Re: Subquery

Former Member — Mon, 08 Aug 2005 13:18:15 GMT

Hi Manik,

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

Regards,

Erwan.

Re: Subquery

Former Member — Mon, 08 Aug 2005 14:32:27 GMT

Hi Ewan,

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

cheers.

/Manik