Skip to Content
0
Feb 20, 2009 at 08:58 AM

Latest record to get from MSEG Table

231 Views

Hi frnds,

I am getting multiple records against material no. i want single record and latest one.

SELECT DISTINCT MBLNR MATNR LIFNR

FROM MSEG

INTO TABLE IT_MSEG

WHERE MATNR IN S_MATNR

ORDER BY MATNR MBLNR DESCENDING.

S_MATNR = multiple matnr

eg: matnr mblnr lifnr

test 1 abc

test 2 abc

test2 4 xyz

test3 3 abc

test3 5 vvvv

I want in my ITAB.

eg: matnr mblnr lifnr

test 1 abc

test2 4 xyz

test3 5 vvvv

Here I am sorting with mblnr to pick latest record.

How i will get.

Regards.