topic Re: Select not retreiving data in Application Development and Automation Discussions

Select not retreiving data

Former Member — Mon, 30 Jul 2007 18:49:40 GMT

Hello All,

I have a question regarding select statement.

Here is the select code

SELECT belnr

perio

wkgbtr

wogbtr

objnr

gjahr

wrttp

vrgng

parob

parob1

uspob

bukrs

owaer

FROM coep

INTO CORRESPONDING FIELDS OF TABLE gt_coep_recv

WHERE perio IN s_perio

AND gjahr IN s_gjahr

AND bukrs IN s_bukrs

AND kstar LIKE '001124%'

AND objnr LIKE 'LKIRST%'

AND parob LIKE 'LKIRSTP%STCC%'

AND wrttp = '11'

AND vrgng = 'RKL'.

This select return a sy-subrc value of 4 when executed. But when I go the COEP table and try to select data basing on the same conditions, I am able to retrieve data.

Any idea why?

Thanks,

Amy

Re: Select not retreiving data

former_member194669 — Mon, 30 Jul 2007 18:58:43 GMT

Hi,

For testing this

Test 1: keep only

WHERE perio IN s_perio.

Test 2: keep only

WHERE perio IN s_perio

AND gjahr IN s_gjahr.

Test 3: keep only

WHERE perio IN s_perio.

AND gjahr IN s_gjahr

AND bukrs IN s_bukrs.

and so on.

one point of time you will get an sy-subrc eq 4 . and you can easily identify the field in which you are doing wrong.

aRs

Re: Select not retreiving data

Former Member — Mon, 30 Jul 2007 19:00:55 GMT

one of the condition in where clause might not be matching..

check the corresponding data in the corresponding table.

Reward if useful

Regards

Pradeep

Re: Select not retreiving data

Former Member — Mon, 30 Jul 2007 19:05:32 GMT

I guess below conditions are problem :

AND kstar LIKE '001124%'

AND objnr LIKE 'LKIRST%'

AND parob LIKE 'LKIRSTP%STCC%'

Try to keep one by one and see the results.

Thanks

Seshu

Re: Select not retreiving data

Former Member — Mon, 30 Jul 2007 19:06:16 GMT

WHERE perio IN s_perio

AND gjahr IN s_gjahr

AND bukrs IN s_bukrs

AND kstar LIKE '001124%'

AND objnr LIKE 'LKIRST%'

AND parob LIKE 'LKIRSTP%STCC%'

AND wrttp = '11'

AND vrgng = 'RKL'.

KSTAR, OBJNR, PAROB may be having conversion exits so your LIKE may not be correct. Try to isolate the problem to one or more of the where clause conditions and then see why it is wrong. My guess is it is to do with the conversion exits.

Re: Select not retreiving data

Former Member — Mon, 30 Jul 2007 19:14:53 GMT

Thanks guys !

Turns out I was missing one character in the objnr comparision string..... thanks for all your inputs... appreciate it.

Amy

Re: Select not retreiving data

Former Member — Mon, 30 Jul 2007 19:19:36 GMT

HI,

its difficult to suggest some thing in this scenerio but.. one advice try commenting the like part and see if it is working if it works try adding like for one field at a time and check ..

SELECT belnr

perio

wkgbtr

wogbtr

objnr

gjahr

wrttp

vrgng

parob

parob1

uspob

bukrs

owaer

FROM coep

INTO CORRESPONDING FIELDS OF TABLE gt_coep_recv

WHERE perio IN s_perio

AND gjahr IN s_gjahr

AND bukrs IN s_bukrs

AND kstar LIKE '001124%'

AND objnr LIKE 'LKIRST%'

<b>AND parob LIKE 'LKIRSTP%STCC%' " I doubt this is the problem</b>

AND wrttp = '11'

AND vrgng = 'RKL'.

Thanks

mahesh