topic Re: Database Table in Application Development and Automation Discussions

Database Table

Former Member — Fri, 25 Jan 2008 08:11:24 GMT

Hi,

How to find the total number of records in a database table? and how to fetch the last record?

Regards,

Kalaivani P

Re: Database Table

former_member188829 — Fri, 25 Jan 2008 08:13:54 GMT

Hi,

To find out total number of records in a database table use Function module..TABLECOUNT

and in this one Pass Table name and client number as input

Re: Database Table

Former Member — Fri, 25 Jan 2008 08:16:19 GMT

Use SY-DBCNT system varaible

sy-dbcnt -Nunber of records in database table

To get the last record use describe statment.

data: lv_line type i.

Describe table itab lines lv_line.

read table itab into wa_itab index lv_line.

Rewards if useful.

Re: Database Table

Former Member — Fri, 25 Jan 2008 08:27:06 GMT

data : l_count(10).

select count(*) from ( table ) into l_count.

l_count will be the last record number

But reading the last record from the database table you need to get those in one internal table and later

read table itab with index l_count.

Re: Database Table

Former Member — Fri, 25 Jan 2008 08:27:52 GMT

use system field

sy-dbcnt.

u can use the last value of the system field to get the value of the last record in the dtabase table

rewrd if useful

Re: Database Table

former_member404244 — Fri, 25 Jan 2008 08:28:44 GMT

Hi,

U can get the totl number of records by this syntax..

SELECT COUNT(*) FROM ztable INTO variable.

Regards,

Nagaraj

Re: Database Table

Former Member — Fri, 25 Jan 2008 09:25:51 GMT

How to fetch the last record from the database table?

Re: Database Table

Former Member — Fri, 25 Jan 2008 10:43:47 GMT

Hi,

To get the last record from the table use SY_DBCNT

This will give the database count ( number of records in the table ).

Read the last record with the index as SY-DBCNT values.

Select * from table into itab.

lv_lines = sy-dbcnt.

read table itab into wa index lv_lines.

In this code the wa contains the last record of the table.

Hope this clarifies you

Reward points if helpful

Re: Database Table

shivani08 — Mon, 21 Feb 2022 08:51:47 GMT

SY-DBCNT is used to get the number of records in the table. Sort the table descending order and on that read the table index 1, then you can retrieve the last records in the table.