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
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
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
Add a comment