Wednesday, April 9, 2008

To read first record using READ TABLE INDEX 1

How you want to read first record or latest record. You can do so by using READ TABLE index 1.
Concept to implement:
You had 2 column A & B.You want to get latest record.

SORT internal table by date ASCENDING. "This will sort the internal table.
READ TABLE itab INDEX 1. "It will read first record after sorting.


Executable example.


REPORT ZFZ0001 .


TYPES: BEGIN OF it,
name(20) TYPE c,
age TYPE i,
END OF it.

TYPES mytab TYPE STANDARD TABLE OF it WITH DEFAULT KEY.

DATA watab TYPE it.
DATA itab TYPE mytab WITH HEADER LINE.

watab-name = 'A'.
watab-age = 23.
append watab TO itab.

watab-name = 'B'.
watab-age = 15.
append watab TO itab.

watab-name = 'C'.
watab-age = 55.
append watab TO itab.

*to sort ascending.
SORT itab by age ASCENDING.

LOOP AT itab INTO watab.
WRITE:/ watab-name, watab-age.
ENDLOOP.

*to get first record data using read index 1.

READ TABLE itab INDEX 1.

WRITE : /'Oldest person'.
WRITE : /'Name', watab-name.
WRITE : /'Age', watab-age.

No comments: