Skip to Content
0
Former Member
Mar 19, 2009 at 07:11 AM

Problem in SELECT SINGLE Query

466 Views

Hi,

I am writing a small quesry in PS, Though the entry exist in database table PRPS, The sy-subrc is 4 for this query.Can u help me.

data : wa_src_prps like prps-posid.

start-of-selection.

wa_src_prps = '3-3310-02-01-01-10-20'.

DATA: lv_pbukr LIKE prps-pbukr.

CLEAR: lv_pbukr.

SELECT SINGLE pbukr INTO lv_pbukr

FROM prps

WHERE posid EQ wa_src_prps.

if sy-subrc = 0.

write:/5 wa_src_prps, lv_pbukr.

endif.