07-03-2007 7:38 AM
Hi,
Plz let me know How to retrieve the first 5 records of cutomer master from the database
07-03-2007 7:41 AM
Hi
Use select .. Upto 5 Rows
or
Select all the data into an ITAB
select * from KNA1 into table ITAB.
sort ITAB by KUnnr.
then move the first 5 Records into another ITAB1.
then use that ITAB1 for your use.
Reward points for useful Answers
Regards
Anji
07-03-2007 7:41 AM
Hi
Use select .. Upto 5 Rows
or
Select all the data into an ITAB
select * from KNA1 into table ITAB.
sort ITAB by KUnnr.
then move the first 5 Records into another ITAB1.
then use that ITAB1 for your use.
Reward points for useful Answers
Regards
Anji
07-03-2007 7:42 AM
07-03-2007 7:43 AM
REPORT ZGS_TEST1 .
data : it_kna1 like kna1 occurs 0 with header line.
select * from kna1 into table it_kna1 up to 5 rows.
Reward points to get 1 point yourself,
Aleem.
07-03-2007 7:45 AM
07-03-2007 7:47 AM
If you need only first five records,then use select upto 5 rows.
If you want the five records on the sorting order of any field,select all the records in to internaltable ,sort that internal table on the basis ofthat field then move first 5 records in to another internal table.
reward if useful.
sastry.