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 |
I have 1 basic list and 9 secondary list in interactive report. If i am in 5th list, how can i come directly to the basic list?
scripts are client independent then how to transfer from one client to (i know RSTXR3TR AND SCC1 TCODE )another client?
why we call smartform as a client independent? (as we are able to retrive data from any client dependent d/b table in smartforms. )
how many indexes can be created for a table?
what will you do in Recording method?
what is the difference between select single * and slect upto 1 rows...
Explain client-dependent and client-independent tables.
Can we change the IDoc number ? if yes..How ?
diff b/w call trans. and session method.
What is the difference between BAPI and RFC?
Hi All, Can u tell me the difference between RFC and BAPI. I know Both are remote enabled.
what is a fiscal year ?