Answer / anonymous

Those mark the answer as No. pls provide the right answer

Answer / sivaramakrishna

according to our requirment
get allthe records using select * from st_db into stu_itab1.
1.first sort the stu_itab1 by marks field.
now use the select single section from st_db into stu_itab2.
now we have to use select for all entries as below.
select section marks from stu_itab1 into table stu_itab3
for all entries in stu_itab2 upto 10 rows.

it may be not exact . but do try in this way

Answer / waseem

**Sorry guys for above wrong code which I posted, You can **use this code with 100 % result****

tables : ywt_student, ywt_result.
data : begin OF itab OCCURS 0, "structure from 2 tables
usn like ywt_student-usn,
name like ywt_student-name,
dob like ywt_student-dob,
cls like ywt_result-class,
marks like ywt_result-marks,
end of itab.

**"selecing values from 2 tables*****
select ywt_student~usn name dob class marks
INTO TABLE itab
from ywt_student INNER JOIN ywt_result on ywt_student~usn = ywt_result~usn.

**Sorting for testing Perpose*****

sort itab by cls ASCENDING marks DESCENDING.
LOOP AT itab.
on CHANGE OF itab-cls.
skip.
ENDon.
WRITE :/ itab-usn, itab-name, itab-dob, itab-cls, itab-marks.

ENDLOOP.



skip 2.
***Actual Logic of Requirement***
data : m LIKE ywt_result-marks.
data : count TYPE i value 0.
CLEAR itab.
sort itab by cls ASCENDING marks DESCENDING.
CLEAR itab.
LOOP AT itab.
m = itab-marks.
on CHANGE OF itab-cls.
skip 2.
count = 0.
ENDon.
AT NEW cls.
itab-marks = m.
count = count + 1.
IF count LE 10.
WRITE :/ itab-usn, itab-name, itab-dob, itab-cls, itab-marks.
CLEAR itab.
ENDIF.
ENDAT.
ENDLOOP.

Answer / shaheen

This can be achived by '...group by' addition in the select
statement.

Regards,
Shaheen

Answer / sateesh

for this initially we can SORT in assending order,
then using "select up to 10 rows".

Answer / waseem

DATA itab LIKE zabc OCCURS 10 WITH HEADER LINE.
SELECT * FROM zbad5 INTO TABLE itab.
SORT itab BY sclass smarks.
data : count type i value 0.
LOOP AT itab.

AT NEW sclass.
count = count + 1.
IF ( count LE 10 ).
WRITE: / itab."-sno1, itab-sclass, itab-smarks.
ENDIF.
ENDAT.

AT END of sclass.
count = 0.
ENDAT.



ENDLOOP.

Answer / balamurugan

REPORT zscenario.
DATA itab LIKE zabc OCCURS 10 WITH HEADER LINE.
SELECT * FROM zbad5 INTO TABLE itab.
SORT itab BY sclass smarks.
LOOP AT itab.

AT NEW sclass.

WRITE: / itab."-sno1 itab-sclass itab-smarks.

ENDAT.
This display the report based upon the class.But i don't know how to retrieve 10 records from each class.

ENDLOOP.

What is a data class? : abap data dictionary

0 Answers  

While sorting field groups we cannot use more than one key field. State true or false. : abap modularization

0 Answers  

what is the differnce between normal funcational and ALV funcational module

1 Answers   IBM,

Difference between /N and /BEND?

0 Answers  

can we insert a table in a table? structure in a structure, structure in a table and table in a structure?

3 Answers  

What is the purpose of Edit Masking?

3 Answers   IBM,

Explain what is the significance of hide?

0 Answers  

What is database utility?

0 Answers  

how to run bdc program in background?

2 Answers   HCL,

what are SPA and GPA parameters?What the Purpose?Examples? under ABAP Memory.

3 Answers  

What are the data types of the external layer? : abap data dictionary

0 Answers  

what is the client on which u have worked? In real time ?

1 Answers   IBM,