topic Re: sql query in Application Development and Automation Discussions

sql query

Former Member — Mon, 31 Oct 2005 06:00:57 GMT

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 — Mon, 31 Oct 2005 06:16:46 GMT

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

Former Member — Mon, 31 Oct 2005 07:31:57 GMT

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 — Mon, 31 Oct 2005 07:34:06 GMT

Hi,

small change.

For latest date use descending not ascending.

regards

chandu

former_member15255 — Mon, 31 Oct 2005 07:57:08 GMT

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