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.