topic Re: select in Application Development and Automation Discussions

select

Former Member — Thu, 31 May 2007 08:54:32 GMT

hi,

i need to extract the highest number for vbeln.

example 12000012, 12000014, 12000018, then i will retrieve 12000018.

1)may i know below can return accurately? do i need to have group by?

2)also can have order by for select single? for this select statement i do not have max( ) but i got error.

SELECT SINGLE max( vbeln ) INTO wa_report-inv FROM vbfa

WHERE vbelv = wa_report-vgbel AND

posnv = wa_report-vgpos AND

vbtyp_n = 'U'.

thanks

Re: select

Former Member — Thu, 31 May 2007 08:56:31 GMT

hi,

i hope aggregate objects will not work single statement.so better remove single from select statement.

reward points if it is helpful

regards,

sangeetha.a

Re: select

Former Member — Thu, 31 May 2007 08:57:27 GMT

Declare an ITAB with required fields

if not wa_report-vgbel [] is initial.

SELECT vbeln INTO table Itab FROM vbfa

WHERE vbelv = wa_report-vgbel AND

posnv = wa_report-vgpos AND

vbtyp_n = 'U'.

endif.

Sort ITAB by vbeln decending .

read table itab index 1.

if sy-subrc = 0.

<b>required VBELN (highest) = itab-vbeln.</b>

endif.

Reward points if useful

Regards

Anji

Re: select

Former Member — Thu, 31 May 2007 08:57:50 GMT

Hi Eliana,

SINGLE is not required for MAX( VBELN ) as MAX( VBELN ) will itself picks highest vbeln from the table.

Check this code.

<b>SELECT max( vbeln )</b> INTO wa_report-inv FROM vbfa

WHERE vbelv = wa_report-vgbel AND

posnv = wa_report-vgpos AND

vbtyp_n = 'U'.

Thanks,

Vinay

Re: select

Former Member — Thu, 31 May 2007 09:03:05 GMT

Hi elina,

this will work fine..

check this one

TABLES: sflight.

DATA wa_report LIKE sflight.

SELECT SINGLE MAX( seatsocc ) INTO wa_report-seatsocc

FROM sflight

WHERE carrid = 'AA'.

Regards

Sarath

Re: select

S0025444845 — Thu, 31 May 2007 09:41:28 GMT

Hi,

You can do like this,

SELECT vbeln INTO it_report FROM vbfa

WHERE vbelv = wa_report-vgbel AND

posnv = wa_report-vgpos AND

vbtyp_n = 'U'.

sort it_report by inv descending.

read table it_report index1.

regards,

sudha.

Re: select

Former Member — Thu, 31 May 2007 09:44:06 GMT

put them in an internal table.

sort itab by vbeln.

loop at itab.

endloop.

now the last entry is that you want.

reward with points if its helpful.