Select

[Former Member]

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

[Former Member]

You can do the following :

SELECT *

FROM ZFtable

INTO IT_cus

WHERE ZSTAT = IT_CUSBAL-ZSTAT

AND ZINVIND = ' '

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

[Former Member]

hi ravi,

with keeping sapce also it is not working.

thanks and regards

kiran kumar

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member404244]

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