Skip to Content
Former Member
Aug 26, 2010 at 09:40 AM

how to fetch the latest change number from CDPOS Table..?


Hi All,

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

INTO wa_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..?