Skip to Content
0
Apr 28, 2014 at 05:57 AM

Issue in select query

40 Views

Hi All ,

Can anyone help on this , wn im trying to execute the record i should get error message as already exist for records already thr in the table. but my lsmw is not doing so. all records are getting converted .

SELECT SINGLE *

FROM /DS1/SD_MT_BOM

WHERE ZHEADER = DETPROTYPSS-ZHEADER

AND ZITEM = DETPROTYPSS-ZITEM

AND WERKS = DETPROTYPSS-WERKS

AND VFROM = DETPROTYPSS-VFROM

AND ZREL = DETPROTYPSS-ZREL.

IF SY-SUBRC EQ 0.

WRITE : / 'ERROR=>Record already exist for',

'ZHEADER=',DETPROTYPSS-ZHEADER,',',

'ZITEM=',DETPROTYPSS-ZITEM,',',

'WERKS=',DETPROTYPSS-WERKS,',',

'VFROM=',DETPROTYPSS-VFROM,',',

'ZREL=',DETPROTYPSS-ZREL.

SKIP_RECORD.

ELSE.

transfer_record.

ENDIF.