topic Re: Problem with Seleection in Application Development and Automation Discussions

Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:24:10 GMT

Hello Gurus.

It is an normal simple Select. But the Subrc is 0 and the is no result.

SELECT k~xblnr

INTO lv_xblnr

FROM dfkkko AS k

INNER JOIN dfkkop AS p

ON p_{opbel = k}opbel

WHERE k~opbel = wa_erdk-opbel

AND p~augst = space.

Thanks for your help

chris

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:26:07 GMT

hi,

go in debugging mode and check out the value in wa_erdk-opbel.

there may be some problem with the where condition.

regards,

Navneeth.K

Re: Problem with Seleection

h_senden2 — Wed, 11 Apr 2007 07:26:48 GMT

What you mean by 'there is no result' ?

Maybe the resulting XBLNR is empty.

regards,

Hans

Please reward all helpful answers !!!!!

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:27:13 GMT

THe XBLNR you are trying to select is having initial value, hence the result. Try with a selection screen field for restricting selection OR use an internal table to get data and see for yourself the data that is selected (you will see some fields with XBLNR as space)

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:27:22 GMT

Hi,

Check the Decalaration of the field LV_XBLNR, it has to be same as XBLNR.

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:27:43 GMT

Hi,

The statement should like this...

SELECT k~xblnr

INTO lv_xblnr

FROM dfkkko AS k

INNER JOIN dfkkop AS p

<b>ON k_{opbel = p}opbel</b>

WHERE k~opbel = wa_erdk-opbel

AND p~augst = space.

Regards,

Ram

Pls reward if useful...

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:27:53 GMT

HI Chris

Can you check in SE16 if any possible entries exist in table DFKKKO and DFKKOP for the value in WA_ERDK-OPBEL???

Kind Regards

Eswar

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:28:31 GMT

Hi,

What's the field wa_erdk-opbel ? is it selection screen field or some internal table field.If it is internal table field then ,it may be empty. check in debugging the value of this field.

Also check whether a value exist in table dfkkko in SE16 for the field XBLNR.

if the value exits then something wrong with the field wa_erdk-opbel .

And also check whether data exist in the other table joined for the same OPBEL.

reward if useful

regards,

ANJI

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:28:35 GMT

Hi,

check with the table on which u r selecting..

May be the content you are looking for is blank..

regards,

nazeer

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:29:38 GMT

Thanks for your lines.

I Think the problem ist the Dataelement XBLNR_KK with an conversion routine.

Re: Problem with Seleection

Former Member — Wed, 11 Apr 2007 07:33:18 GMT

good

debug the program and check whether the internal table having data or not,if the internal table does not contain any data than the select statement ll retrun no value.

thanks

mrutyun^