sql query

[Former Member]

Hi ,

Can anybody tell me how to pick the latest date.

I am using a sql query

Select * into table itab from mseg as A inner join mkpf as B where A_{mblnr = B}mblnr where budat = max ( budat).

endselect.

regards

Mave

[Former Member]

try using the option "MAX" or sort the internal table by date

[Former Member]

Hi,

Select * into table itab from mseg as A inner join mkpf as B where A_{mblnr = B}mblnr where budat = budat.

sort itab Ascending by mblnr budat.

delete adjacent duplicates from itab comparing mblnr.

hope this helps.

regards

chandu.

[Former Member]

Hi,

small change.

For latest date use descending not ascending.

regards

chandu

[former_member15255]

Hi,

SELECT A_{FIELD1 A}FIELD2 MAX( b_{BUDAT )FROM MSEG A INNER JOIN BKPF AS B ON A}MBLNR = B~MBLNR.

try this out i think this would solve ur problem

regards

suresh krishnan