Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, My question is " How to display 3rd highest salary
record from the internal table. The internal table has 2
fields named emno(Employee number) and salary.".
Send answer to my mail shaiksha.it@gmail.com.
Thanking you.
- 9 Answers
- 18119 Views
- Yash Technologies, I also Faced
- E-Mail Answers
Answer Posted / jitendra
TYPES : BEGIN OF TY,
ENO(6) TYPE c,
SAL TYPE LABST,
END OF TY.
DATA : ITAB TYPE STANDARD TABLE OF TY,
WA_IT TYPE TY.
DATA : SAAL TYPE LABST.
WA_IT-ENO = '1000'.
WA_IT-SAL = '10000'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1001'.
WA_IT-SAL = '19000'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1002'.
WA_IT-SAL = '10500'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1003'.
WA_IT-SAL = '10080'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1004'.
WA_IT-SAL = '10200'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1006'.
WA_IT-SAL = '10400'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
WA_IT-ENO = '1005'.
WA_IT-SAL = '10400'.
APPEND WA_IT TO ITAB.
CLEAR WA_IT.
SORT ITAB BY SAL DESCENDING.
READ TABLE ITAB INTO WA_IT INDEX '3'.
SAAL = WA_IT-SAL.
clear wa_it.
LOOP AT ITAB INTO WA_IT where sal eq saal.
*append wa_it to itab1.
write :/ wa_it-eno, 10 wa_it-sal.
ENDLOOP.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between open_form and close_form?
How can a lock object be called in the transaction?
How to add a column to a table control while using alphanumerical layout editor ?
Cds views
What are the screen elements.
What is the difference between a pool table and a transparent table?
What is abap dictionary or data dictionary? What is the transaction to access abap dictionary? : abap data dictionary
What is logical database? : abap hr
what are the two methods of modifying sap standard tables? : abap data dictionary
What is gui status? How to create /edit gui status?
Why do we use dynamic where conditions?
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
why particularly lock object name starts with EZ OR EY?
What is the significance of the memory table ‘screen’?
What is a function group? : abap modularization
