I am having 1 measuring point and for that 3 measuring document numbers.I want to take latest document number.
suggest me how to do it.
point : 000000000835
document : 00000000000000001287
I want to take latest 00000000000000001690 pls help me.
you can only select one field this way (i. e. with SELECT MAX)
select MAX( MDOCM )
where idate = dt.
Now you have mdocm and you can select the whole record with a SELECT SINGLE
An other option would be to select all lines into an internal table, sort the internal table by mdocm descending and now you have highest doc number in the first line of the internal table.