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.

How do you get your task to perform?

1 Answers   IBM,

What is a type-pool?

0 Answers  

1) How to maintain lists in dialog programming? 2)How to send greeting with different languages to different regions in smartforms? 3)Can we transfer 100 screen data to pass 200 screen? 4)In reports 1st list o/p can be consider as i/p of 2nd list how it maintains? 5) In lsmw data length 20 chars only but there is 24 chars field how can u manage? 6)What is the diff b/w OK_CODE n SY_UCOMM?

2 Answers   CSC,

Can we create a field without data element ? If yes what is the difference?

2 Answers  

What are the problems in processing batch input session?

2 Answers   HP,

How to debug an Idoc at runtime?

1 Answers   TCS,

Have you printed any report?

0 Answers   TCS,

What is SAP Data conversion ?

0 Answers  

How do you see the data in a table?

3 Answers   FutureSoft,

Urgent Openings for Professionals with 4+ yrs in SAP ABAP HR, for a Reputed CMM Level V Organization in Hyderabad

1 Answers  

when we create a simple report with input field as S_VBELN (as select-options)..for any range of values it is displaying the output...i dont want like that..only the existing ranges it must be displayed...for ex. in sales ranges from 4969...but in input from 1 to z also displaying..please send me the solution

2 Answers  

to explicititly intialize the selection screen for each call you must you the event ________________?

2 Answers