Select max / Dump

Former Member — Thu, 26 Apr 2007 07:03:05 GMT

Hello gurus I has there a small problem with a selection.

Source base table

1233456789 01.01.2007

9999999999 02.02.2007

I must determine only the first record (select max. ( ) ).

Then with this record I get into the next selection.

The Coding

Deklaration

DATA: BEGIN OF ls_fkkmako,

gpart TYPE fkkmako-gpart,

vkont TYPE fkkmako-vkont,

ausdt TYPE fkkmako-ausdt,

mahnv TYPE fkkmako-mahnv,

mgrup TYPE fkkmako-mgrup,

mahns TYPE fkkmako-mahns,

mstyp TYPE fkkmako-mstyp,

END OF ls_fkkmako.

DATA: lt_fkkmako LIKE TABLE OF ls_fkkmako.

SELECT SINGLE * FROM fkkmako "FR01/ G

WHERE vkont = c_fkkmako-vkont "FR01

AND mahns = '10' "FR01

AND formkey = 'ZB_MAASV1' . "FR01

AND ausdt = ls_fkkmako-ausdt.

IF sy-subrc = 0. "FR01 "Hit found

I Try it like this. But there was a Dump. (SQL) Why ??

SELECT MAX( ausdt )
FROM fkkmako "FR02
INTO ls_fkkmako
WHERE vkont = c_fkkmako-vkont "FR02
AND mahns = '10' "FR02
AND formkey = 'ZB_MAASV1'. "FR02

Thanks for your help .

BY christian

Re: Select max / Dump

kostas_tsioubris — Thu, 26 Apr 2007 07:30:39 GMT

Hi,

the statement

 SELECT MAX( ausdt )
 FROM fkkmako "FR02
 INTO ls_fkkmako
 WHERE vkont = c_fkkmako-vkont "FR02
 AND mahns = '10' "FR02
 AND formkey = 'ZB_MAASV1'. "FR02

will only select the ausdt value but you are reading it into ls_fkkmako structure that's why you get a sort dump. Alternatively you can use this

 SELECT * 
 FROM fkkmako "FR02
 INTO ls_fkkmako
 WHERE vkont = c_fkkmako-vkont "FR02
 AND mahns = '10' "FR02
 AND formkey = 'ZB_MAASV1' "FR02
order by ausdt descending.

exit.
endselect.

Kostas.

topic Select max / Dump in Application Development and Automation Discussions

Select max / Dump

Re: Select max / Dump