topic Re: regarding resb table in Application Development and Automation Discussions

regarding resb table

Former Member — Tue, 22 Jul 2008 21:33:35 GMT

hai,

is it possible to count the no of records by year wise in resb table and in that table 16 millions records are present.if it is possible means, tell me the solution as soon as possible.

with regards,

r.dhinesh raj.

Re: regarding resb table

Former Member — Tue, 22 Jul 2008 22:19:24 GMT

hi,

write a query like,



data: ws_cnt type i,
      ws_gjahr type gjahr.

select count(*) gjahr into (ws_cnt, ws_gjahr)
  from bkpf GROUP BY gjahr.

write: ws_cnt, ws_gjahr.
  endselect.

regards,

Subramanian