04-23-2009 2:05 PM
Hi,
I need to fatch data from T030 table which is a pool table but when i am writing select query its not working.
select KTOPL KOMOK KONTS KONTH from t030 into table fs_t030 where KTOPL = '1000' and
komok = fs_kont-kont1.
Please tell me how should i fatch data?
Thanks & Regards,
Amit
04-23-2009 2:23 PM
Total Posts: 91
Total Questions: 66 (64 unresolved)
Please clean up your old posts.
I don't see anything wrong with what you have written. What do you mean by "its not working"?
Rob
04-23-2009 2:23 PM
Total Posts: 91
Total Questions: 66 (64 unresolved)
Please clean up your old posts.
I don't see anything wrong with what you have written. What do you mean by "its not working"?
Rob
04-24-2009 5:37 AM
Hi,
just put a breakpoint on the select query and .....
if fs_kont-kont1 is the work area of another internal table than
pls make sure that u have some value in fs_kont-kont1 and check wether KTOPL is having value 1000 in the table
also make sure that the table T030 have entries in it.
code
data:
t_to30 type standard table of t030.
select * from t030 into table t_t030
where ktopl eq '1000' and komok eq fs_kont-kont1.
if sy-subrc ne 0.
message 'No Records Found' type 'E'.
endif.
hope this solves the issue...
thanks
ravi
04-24-2009 12:32 PM
hi amit
the query is working fine
may be there is no entry for KTOPL = '1000' in t030 because i didnt fine any value in t030 for KTOPL = '1000' in se11.
so plz check the data in t030.