topic Re: Database Select - Regdg. in Application Development and Automation Discussions

Database Select - Regdg.

Former Member — Thu, 19 Apr 2007 04:32:23 GMT

Hi,

I want to read the last record in the Database Table. How to write such an select statement.I don't want to use Internal tables for this purpose. Is there any way.

regards,

Navneeth.K

Re: Database Select - Regdg.

Former Member — Thu, 19 Apr 2007 04:38:48 GMT

try this

<b>DESCRIBE TABLE i_mvke LINES ws_lines.

READ TABLE i_mvke INTO wa_mvke INDEX ws_lines.</b>

You will have a latest record in wa_mvke

regards

ravish

<b>plz reward points if helpful</b>

Re: Database Select - Regdg.

Former Member — Thu, 19 Apr 2007 04:42:54 GMT

Hi Ravish,

I dont want to use any internal tables , is there any other way.

regards,

Navneeth.K

Re: Database Select - Regdg.

former_member195930 — Thu, 19 Apr 2007 04:45:14 GMT

Hi Navneeth,

Try this query

SELECT * FROM <tablename> LIMIT < last row number in the table>,-1.

Regards,

ANusha

Re: Database Select - Regdg.

Former Member — Thu, 19 Apr 2007 04:47:30 GMT

Hi,

As SAP uses internal tables to manipulate the data, i dont think you can directly get the last record from database table directly.

You can get the number of records directly using count(*) or getting sy-dbcnt.

Sandeep

Re: Database Select - Regdg.

aris_hidalgo — Thu, 19 Apr 2007 04:49:36 GMT

Hi,

Please take a look at my example below.

tables: vbak.

select vbeln erdat

from vbak up to 1 rows

into (vbak-vbeln, vbak-erdat)

order by erdat descending.

write: vbak-vbeln, vbak-erdat.

In my example above, it gets the last record from VBAK table according to the date. Hope this helps...

P.S. Please award points if it helps...