topic Re: SELECT STATEMENT in Application Development and Automation Discussions

SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 13:24:11 GMT

hi all,

i m not getting any values for below code..as it contains some values in table..

SELECT SINGLE PSPNR POSID USR11 FROM PRPS INTO LT_PRPS WHERE PSPNR = LV_WBS_ELEM_E1.

READ TABLE LT_PRPS INTO WA_PRPS WITH KEY LV_USR11 = 'X'.

IF SY-SUBRC = 0.

MOVE 'X' TO LV_CHECK.

ENDIF.

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 13:28:12 GMT

SELECT SINGLE PSPNR POSID USR11 FROM PRPS INTO LT_PRPS WHERE PSPNR = LV_WBS_ELEM_E1.

READ TABLE LT_PRPS INTO WA_PRPS WITH KEY LV_USR11 = 'X'.

IF SY-SUBRC = 0.

MOVE 'X' TO LV_CHECK.

ENDIF.

Please change the query like below.

Clear: PRPS

SELECT SINGLE * FROM PRPS WHERE PSPNR = LV_WBS_ELEM_E1.

IF SY-SUBRC = 0 AND PRPS-LV_USR11 = 'X'.

.MOVE 'X' TO LV_CHECK.

ENDIF.

Thanks,

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 13:28:28 GMT

Hi,

Check in debug mode if you need to remove leading zeros.

If yes you can use function module Conversion_exit_alpha_output.

Hope it helps.

Regards,

Siddhesh S.Tawate

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 13:35:45 GMT

HI BABA,

there is NO INTO statement..it is giving error..pls help

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 14:03:13 GMT

You write code like this.

DATA: LV_CHECK LIKE PRPS-US11.

SELECT SINGLE PSPNR POSID USR11

FROM PRPS

INTO LT_PRPS

WHERE PSPNR = LV_WBS_ELEM_E1.

READ TABLE LT_PRPS

INTO WA_PRPS

WITH KEY USR11 = 'X'.

IF SY-SUBRC = 0.

MOVE WA_PRPS-USR11 TO LV_CHECK.

ENDIF.

REGARDS,

KAMALA.

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 14:15:37 GMT

SELECT SINGLE PSPNR POSID USR11 FROM PRPS INTO LT_PRPS WHERE PSPNR = LV_WBS_ELEM_E1.

READ TABLE LT_PRPS INTO WA_PRPS WITH KEY LV_USR11 = 'X'.

IF SY-SUBRC = 0.

MOVE 'X' TO LV_CHECK.

ENDIF.

Please change the query like below.

Clear: PRPS

SELECT SINGLE * FROM into LT_PRPS WHERE PRPS WHERE PSPNR = LV_WBS_ELEM_E1.

IF SY-SUBRC = 0 AND PRPS-LV_USR11 = 'X'.

.MOVE 'X' TO LV_CHECK.

ENDIF.

Re: SELECT STATEMENT

Former Member — Fri, 15 Feb 2008 14:29:46 GMT

your select doesnt look, bad, so are you really sure there is data in the Table?

and i dont mean any data, i mean data matching your where condition.

Re: SELECT STATEMENT

Former Member — Mon, 18 Feb 2008 10:39:22 GMT

Use below code..

SELECT SINGLE USR11 FROM PRPS INTO LV_USR11

WHERE POSID = LV_WBS_ELEM_E.

MOVE LV_USR11 TO LV_CHECK.

Re: SELECT STATEMENT

Former Member — Mon, 18 Feb 2008 10:40:21 GMT

Thanks for ur code..its working...