topic Re: select query on pool table T030 in Application Development and Automation Discussions

select query on pool table T030

Former Member — Thu, 23 Apr 2009 13:05:13 GMT

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

Re: select query on pool table T030

Former Member — Thu, 23 Apr 2009 13:23:09 GMT

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

Re: select query on pool table T030

Former Member — Fri, 24 Apr 2009 04:37:24 GMT

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

Re: select query on pool table T030

Former Member — Fri, 24 Apr 2009 11:32:26 GMT

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.