topic Select in Application Development and Automation Discussions

Select

Former Member — Tue, 17 Oct 2006 12:19:38 GMT

hi to all,

help me in this issue

SELECT *

FROM ZFtable

INTO IT_cus

WHERE ZSTAT = IT_CUSBAL-ZSTAT

AND ZINVIND = ' '

AND TRANSINST EQ ' '

when i keep this transinst eq ' ' it is not collecting any date but date is therein database is there any mistake in select stament.

thanks in advance

kiran kumar

Re: Select

Former Member — Tue, 17 Oct 2006 12:24:03 GMT

You can do the following :

SELECT *

FROM ZFtable

INTO IT_cus

WHERE ZSTAT = IT_CUSBAL-ZSTAT

AND ZINVIND = ' '

AND TRANSINST <b>= SPACE.</b>

Re: Select

Former Member — Tue, 17 Oct 2006 12:30:40 GMT

Hi,

Check the data type of this field "TRANSINST"...

also check the initial value of the data type..

Try to compare it with the initial value.

Regards

Re: Select

Former Member — Tue, 17 Oct 2006 12:31:29 GMT

Hi Kiran,

Kindly try this code:

SELECT * FROM zftable INTO it_cus
WHERE zstat EQ it_cusbal-zstat
AND   zinvind <b>IS INITIAL</b>
AND   transinst <b>IS INITIAL</b>.

hope this helps!

best regards,

Thangesh

Re: Select

Former Member — Tue, 17 Oct 2006 12:31:40 GMT

hi ravi,

with keeping sapce also it is not working.

thanks and regards

kiran kumar

Re: Select

Former Member — Tue, 17 Oct 2006 12:37:47 GMT

Hi kiran,

there are 2 ways.

first create a field like TRANSINST and let it initial.

data TRANSINST like ZFTABE-TRANSINST.

SELECT * FROM ZFTABE where TRANSINST = TRANSINST.

...

ENDSELECT.

Another way is to check with initial.

Regards, Dieter

Message was edited by: Dieter Gröhn

Re: Select

Former Member — Tue, 17 Oct 2006 12:40:28 GMT

It seems that the value in the field for TRANSINST is not SPACE. Hence It is not returning you any data.

Re: Select

former_member404244 — Tue, 17 Oct 2006 12:48:02 GMT

Hi kiran,

u query is fine..but It seems that the value in the field for TRANSINST is not equal to SPACE. So u r not getting any values.Chek the same...

Regards,

nagaraj