query for select statement

[Former Member]

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

[Former Member]

Hi abhilash,,

Pls ellaborate your question .its still not clear.

regards,

ajit.

[Former Member]

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

[former_member188827]

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.

[Former Member]

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

[Former Member]

solved