10-17-2006 1:19 PM
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
10-17-2006 1:24 PM
You can do the following :
SELECT *
FROM ZFtable
INTO IT_cus
WHERE ZSTAT = IT_CUSBAL-ZSTAT
AND ZINVIND = ' '
AND TRANSINST <b>= SPACE.</b>
10-17-2006 1:24 PM
You can do the following :
SELECT *
FROM ZFtable
INTO IT_cus
WHERE ZSTAT = IT_CUSBAL-ZSTAT
AND ZINVIND = ' '
AND TRANSINST <b>= SPACE.</b>
10-17-2006 1:31 PM
hi ravi,
with keeping sapce also it is not working.
thanks and regards
kiran kumar
10-17-2006 1:30 PM
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
10-17-2006 1:31 PM
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
10-17-2006 1:37 PM
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
10-17-2006 1:40 PM
It seems that the value in the field for TRANSINST is not SPACE. Hence It is not returning you any data.
10-17-2006 1:48 PM
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