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

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

58 Views

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

Ashok