Problem with Seleection

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks for your lines.

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

[h_senden2]

What you mean by 'there is no result' ?

Maybe the resulting XBLNR is empty.

regards,

Hans

Please reward all helpful answers !!!!!

[Former Member]

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)

[Former Member]

Hi,

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

[Former Member]

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...

[Former Member]

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

[Former Member]

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

[former_member588853]

Hi,

check with the table on which u r selecting..

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

regards,

nazeer

[Former Member]

hi

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^