topic Select Statment in Application Development and Automation Discussions

Select Statment

Former Member — Mon, 20 Nov 2006 22:43:06 GMT

Hello,

I am trying to select field name ETENR with the highest value. with respect to VBELN table name vbep. so in VBEP there is one vbeln with more that one ETENR. I want to select the Highest ETENR for that Specific Vbeln. can anyone please help. I am new to ABAP.

Thanks.

Re: Select Statment

Former Member — Mon, 20 Nov 2006 22:46:24 GMT

Hi,

Use order by descending..

DATA: V_ETENR LIKE VBEP-ETENR.

SELECT ETENR UP TO 1 ROWS

INTO V_ETENR

FROM VBEP

WHERE VBELN = '121212'

ORDER BY ETENR DESCENDING.

ENDSELECT.

IF SY-SUBRC = 0.

WRITE: / 'Last number - ', V_ETENR.

ENDIF.

Thanks,

Naren

Re: Select Statment

Former Member — Mon, 20 Nov 2006 22:49:26 GMT

Please find the query here

SELECT MAX(ETENR)

INTO V_ETENR

FROM VBEP

WHERE VBELN = '100034'

ORDER BY ETENR DESCENDING.

ENDSELECT.

Regards

Kathirvel

Re: Select Statment

former_member186741 — Mon, 20 Nov 2006 22:51:54 GMT

SELECT MAX( ETENR ) as etenr

INTO Vbep-ETENR

FROM VBEP

WHERE VBELN = '100034'

Re: Select Statment

venkata_ramisetti — Mon, 20 Nov 2006 22:52:10 GMT

Hi heba,

Since ETENR is a numeric field, you can also write code like below.

DATA: V_ETENR TYPE VBEP-ETENR.

SELECT MAX( ETENR ) INTO V_ETENR

FROM VBEP

WHERE VBELN = V_VBELN.

I think this more efficient one.

Thanks

Ramakrishna