Select Statment

[Former Member]

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.

[Former Member]

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

[Former Member]

Please find the query here

SELECT MAX(ETENR)

INTO V_ETENR

FROM VBEP

WHERE VBELN = '100034'

ORDER BY ETENR DESCENDING.

ENDSELECT.

Regards

Kathirvel

[former_member186741]

SELECT MAX( ETENR ) as etenr

INTO Vbep-ETENR

FROM VBEP

WHERE VBELN = '100034'

.

[venkata_ramisetti]

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