im trying to fetch teh change number from CDPOS with the below select, but my requirement is always i wants to fetch the latest change number.
SELECT SINGLE objectid changenr FROM cdpos
WHERE objectid = wa_e1kna1m-kunnr
AND ( tabname = 'KNA1' OR tabname = 'KNVV')
AND fname = 'AUFSD'
AND ( value_new = '01' OR value_new = space ).
Please let me know how to achive this..?