topic Re: READING INTERNAL TABLE RECORDS in Application Development and Automation Discussions

READING INTERNAL TABLE RECORDS

Former Member — Mon, 08 Oct 2007 07:49:35 GMT

I WANT TO READ JUST THE LAST RECORD OF AN INTERNAL TABLE.

HOW CAN I DO IT? I WANT TO STORE THAT LAST RECORD IN A VARIABLE.

HOW TO DO THAT...

amit_khare — Mon, 08 Oct 2007 07:51:15 GMT

Describe table itab length v_len.

read table itab into wa_itab index v_len.

Regards,

Amit

Reward all helpful replies.

jayanthi_jayaraman — Mon, 08 Oct 2007 07:52:49 GMT

Hi,

describe table itab lines ln.

read table itab index ln.

former_member188827 — Mon, 08 Oct 2007 07:53:00 GMT

data count type i.

loop at itab.

count = sy-tabix.

endloop.

*count holds last row index of internal table...

read table itab index count.

plz reward points if dis helps

Former Member — Mon, 08 Oct 2007 08:17:21 GMT

1. Last means what ? It may mean,

the last entered, as per some date/time field in the table.

2. So its better to select all records first

in some internal table (for the same person number)

3. Then SORT ITAB field5 descending.

4. Read ITAB INDEX 1.

once u get data from table into a int table.

describe table itab lines FILL.

fill will return u the no of records in the int table.

read table itab ..... index FILL.

if sy-subrc = 0.

write 😕 itab.

endif.

<b>Reward if usefull</b>