A database table contains 3
fields(Student_no,Section,Total_marks).I want retrieve top 10
students from each section.Note:(Section contains data like
A,B,C.Each section contains more than 10 students).
Answer Posted / 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.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are Pull and Push Methods?
What are the layers of data description in r/3? : abap data dictionary
What are the functional areas, user groups? How does abap query work in relation to these?
What is logo in sap script?
SM35 transaction, How to automate BDC ?
Explain the inside concept in select-options?
How to convert the Unit for 'Distance' (The value from one Unit to another).
In which table the material master data is stored?
Application Category?
What are the different methods of bdc? : abap bdc
Can we access static attribute from instance method
Difference between transparent tables and pooled tables? : abap hr
What are differences between at selection-screen and at selection-screen output?
Difference between sy-tabix and sy-index? Where it is used?
What is the syntax for ‘call transaction’?