Skip to Content
0
Feb 23, 2005 at 01:51 PM

Select Endselect or Select single

1087 Views

Consider the following code:

SELECT * FROM hrp1000

UP TO 1 ROWS

WHERE plvar = ls_i1001-plvar

AND otype = ls_i1001-otype

AND objid = ls_i1001-sobid

AND istat = '1'

AND begda =< lv_begda

AND endda => lv_endda

AND langu = sy-langu

ORDER BY PRIMARY KEY.

ENDSELECT.

Could this be replaced by a SELECT SINGLE?

We have a QA process which forbids SELECT...ENDSELECTs. In this instance I believe a SELECT SINGLE to be erroneous.

Any thoughts anyone?

Thanks in advance

Ian