topic Re: query for select statement in Application Development and Automation Discussions

query for select statement

Former Member — Fri, 22 May 2009 04:21:56 GMT

Dear all

is there any option in select statement to automatically generate serial number respect of data.

for eg.

1 101100110 shetal trade

2 1110001178 CHEMICAL SOAP WORKS

3..

4..

i don't want to use loop (sy-tabix) ..

thanks,

Abhi

Re: query for select statement

Former Member — Fri, 22 May 2009 04:31:18 GMT

Hi abhilash,,

Pls ellaborate your question .its still not clear.

regards,

ajit.

Re: query for select statement

Former Member — Fri, 22 May 2009 04:36:54 GMT

Hi,

You can select data from dbtable using select, and fill the internal table with corresponding data. You cannot generate serial number while selecting data from the dbtable and fill in it in the internal table, to achieve this you have to write separate logic.

Regards,

George

Re: query for select statement

former_member188827 — Fri, 22 May 2009 04:40:14 GMT

no select statement itself cannot return serial numbers.if you use select endselect structure then you can use any variable to display serial number..

select ,,,,,,,from ....into....where.....

count = count + 1.

write:/ count,......

endselect.

Re: query for select statement

Former Member — Fri, 22 May 2009 05:03:54 GMT

Hi ,

i don't want to use loop (sy-tabix) ..

any particular reason for this ?

as u cannot automatically generate serial number, u have to go for loop....endloop.

Thanks

Karthik

Re: query for select statement

Former Member — Sat, 19 Dec 2009 03:51:38 GMT

solved