topic Re: Select a particular record in Application Development and Automation Discussions

Select a particular record

Former Member — Wed, 16 Jul 2008 11:40:24 GMT

Hi,

How to select a particular record, say record number 45 from a database table?

Thanks,

Sachin.

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 11:47:03 GMT

Hey!

I didn't get your question. what is your requirement?

Re: Select a particular record

former_member125931 — Wed, 16 Jul 2008 11:47:34 GMT

Suppose you r selecting a particular record like material no : 100 from MARA table

write query like below

select matnr from mara into tablr itab

where matnr = '100'.

if you want total record of this materia no then write like below

select * from mara into table itab

where matnr = '100'.

Hope it will helpful.

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 11:47:47 GMT

If you know the index, then it's easy...

If not, I would like to ask why you want to retrieve a specific record number. If this is a recurring need, you should consider defining such a field (counter, record number) as part of the key, or as a secondary index.

If not, I can only say I don't really see the need...

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 11:49:06 GMT

Hi Sachin,

Try the following:

Select *

from <dbtable>

into <itab>

where rec_no = 45.

dbtable = database table

itab = internal table

Hope this helps you.

Regards,

Chandra Sekhar

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 11:54:27 GMT

hi,

Did you mean fetching a record on the particular line in the table.

try this

w_index = sy-tabix.

select * from <table> into <structure>

where index EQ w_index.

Hope this will Help.

Regards

Sumit Agarwal

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 11:55:22 GMT

Hi Trond,

I actually want to insert some records after the last record in the table, and for the reocrds to be inserted, I need a value from the last record.

All the records have a field Storage Bin. Now, suppose its value is 125.

I have to insert the reocrds in increasing order, like next bin should be 126, then 127 and so on. All these values are not provided in any file, rather than the program is generating them depending on whatever the number of last bin in database was.

Thanks,

Sachin.

Re: Select a particular record

Former Member — Wed, 16 Jul 2008 12:12:09 GMT

Hi Sachin Bhatnagar ,

Try this logic, it will work,,,

select * from dbtable into itab ,,,

Loop at itab.

AT ENDOF Storage Bin.

Storage Bin. = Storage Bin + 1.

Endat.

End loop.

Hope it is helps.

Regards,

T.Durai murugan.

Re: Select a particular record

former_member125931 — Wed, 16 Jul 2008 12:14:52 GMT

Have u checked my logic,give me ur requirement i will provide you the suitable code or logic

but I given you the answer is appropriated try it once.

Re: Select a particular record

Former Member — Fri, 18 Jul 2008 04:05:43 GMT

Hi Murugan,

Thanks.. It worked...