Select statement

[Former Member]

Hi all,

I need to retrieve records from mseg for some materials with respect to the lastest document of that particular material.

for example.

table : mseg

_____________

Doc No. Mat

001 a

002 a

011 b

012 b

____________

i need to retrieve doc 002 and 012 for mat a and b.

Thanks for ur suggestion,

Rajesh.

[Former Member]

Hi,

After retreiving the data from the table, sort the internal table on material document no and material in the descending sequence.

E.g.

sort itab by matnr mblnr descending.

Loop at itab1.

on change of itab-matnr.

read itab with key matnr = itab1-matnr.

endon.

endloop.

P.S. mark all helpful asnwers for points

JLN

[Former Member]

Hi,

Select MBLNR

MATNR

into table itab.

sort ITAB by MBLNR MATNR DESCENDING.

itab1[] = itab[].

LOOP AT ITAB.

AT NEW ITAB-MATNR.

read table itab1 index sy-tabix.

append itab1 into itfinal.

ENDAT.

ENDLOOP.

ITFINAL will have the req. records.

Best regards,

Prashant

[Former Member]

Hi,

You can use aggregate function MAX in the select statement.

Ex. select max ( MBLNR ) into table itab where

...

Hope this helps.

[Former Member]

i think its code help u.:

First sort table on docno & mat

sort T_mseg.

loop at T_mseg.

AT END OF NAME.

WRITE: / T_mseg-Doc, T_mseg-Mat.

ENDAT.

Endloop.

[Former Member]

SELECT MATNR MAX(mblnr) into table itab

from mseg

group by matnr

where matnr in s_matnr.

Itab should have the required data

[Former Member]

Thanks Anurag and everybody for your help.

Rajesh.