How Group 10 sets of records per group of Internal Table in ABAP.
Good Afternoon All,
I have one internal table which have 400 records ,i need to group these records in set of 10 records .
for example:
ID value
2 100
1 95
3 90
4 85
6 80
7 75
8 70
10 65
9 60
----------------------------------
Total : 720---------------------------------------1st group
-------------------------------
11 59
13 58
12 55
14 54
15 52
18 51
16 50
17 49
19 40
20 39
-------------------------------
Total : 507 -----------------------2nd Group
------------------------------
..........
..........
........
please help me ....how i get this in abap.
Thanks
Answers were Sorted based on User's Feedback
Answer / prakash
CLEAR:lv_lines,lv_n,lv_mod,lwa_final,lv_p,lv_ch,lv_a,lv_b..
SORT lit_final BY vtweg vkorg vkbur pltyp matnr.
DESCRIBE TABLE lit_final LINES lv_lines.
lv_p = lv_lines / 10.
lv_ch = lv_p.
SPLIT lv_ch AT '.' INTO lv_a lv_b.
IF lv_b NE '00'.
lv_n = lv_a + 1.
ELSE.
lv_n = lv_a.
ENDIF.
lv_mod = lv_lines MOD 10.
lit_finaltp[] = lit_final[].
DO lv_n TIMES.
lit_final[] = lit_finaltp[].
REFRESH : lit_finalt[],lit_finaltp[].
CLEAR : lwa_finaltt.
LOOP AT lit_final INTO lwa_final.
IF sy-tabix LE 10.
APPEND lwa_final TO lit_finalt.
MOVE-CORRESPONDING lwa_final TO lwa_finaltt.
CLEAR lwa_final.
ELSE.
APPEND lwa_final TO lit_finaltp.
CLEAR lwa_final.
ENDIF.
ENDLOOP.
lit_final[] = lit_finalt[].
ENDDO.
You have to do the sum in a variable and print the sum
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / manoranjan
use control break statements.
AT END OF ID = 10
SUM .
ENDAT.
LIKE THIS U CAN GROUP ALL RECORDS.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the data types of the abap/4 layer? : abap data dictionary
real time report in material management and sales and distribution with codes
What is meant by hide area?
how do you supress blank spaces in sap scripts?
what is the format of the text used in sapscript
. How to transport scripts ?
functional spec given by whom?
What are the three ways for searching for Enhancements ?
What is sap luw or update transaction?
Is multiple implementation possible for one BADI definition? If possible the how can you know that which BADI is active.
shell we use select-options in mpp?then how?
Define batch input session?