If you have 17 branches, create an internal table with 17 records. lets say it_17.
Now create a loop node with thsi internal table.
- Under this loop create a program lines node
- first table node - to hold the records of each branch except last 3 lines
- second table node- to hold last 3 records of the each branch
(design these tables as per your requirement)
Now keep this logic in your program lines node:
LOOP AT zs_sf1 INTO wa_sf1.
wa_new = wa_sf1-carrid.
IF sy-tabix eq 1.
wa_old = wa_sf1-carrid.
ELSE.
IF wa_new eq ' '.
delete zs_sf1 INDEX sy-tabix.
ELSE.
describe table zs_sf2 lines count.
IF count ge 2.
count3 = count - 2.
append lines of zs_sf2 from count3 to count to zs_sf3_last3.
count3 = count3 - 1.
append lines of zs_sf2 from 1 to count3 to zs_sf3.
delete zs_sf1 INDEX 1.
exit.
ENDIF.
ENDIF.
ENDIF.
APPEND wa_sf1 to zs_sf2.
ENDLOOP.
In the table node one include zs_sf3 as internal table
and in second table node include zs_sf3_last3 as internal table.
So, the logic goes like this:
In first iteration of it_17:
zs_sf3 holds the records of first branch
and zs_sf3_last3 holds last 3 records of first branch
and the table node prints the first branch data
In second iteration of it_17:
zs_sf3 holds the records of second branch
and zs_sf3_last3 holds last 3 records of second branch
and the table node prints the second branch data
And this loop continues for 17 branches.
(Declare the internal tables and work areas in the global data section, and pass them as input/output paramaters while using in program lines node)
Check if this helps you. This is done with the same sflight example. try to map with your internal tables.
DATA: zsflight_out TYPE TABLE OF sflight,
wa_zsflight_out TYPE sflight,
zs_sf1 type TABLE OF sflight,
zs_sf2 type TABLE OF sflight,
wa_total TYPE sflight-price,
fg TYPE c.
select * FROM sflight INTO TABLE zsflight_out.
BREAK-POINT.
sort zsflight_out by connid. " Connid should eb replaced by the field - Ktgrm_d
LOOP AT zsflight_out INTO wa_zsflight_out .
at END OF connid.
sum.
wa_total = wa_zsflight_out-price. " price should be replaced by field - Value
fg = 'X'.
endat.
append wa_zsflight_out to zs_sf1.
IF fg = 'X'.
wa_zsflight_out-price = wa_total.
append wa_zsflight_out to zs_sf2.
APPEND LINES OF zs_sf1 to zs_sf2.
clear fg.
refresh zs_sf1[].
CLEAR wa_total.
ENDIF.
ENDLOOP.
BREAK-POINT.
Thank you for supporting me. I got a prob in smart form. Ive dev the smart form and dev the custom programme for that form.
my final itab got items with subtotal. Just iam passing the final itab to smart form. there iam using directly.
my requirement is i need to get the all sub tottal records should be bold/color.... how to make it? subtotal will be come end of the item. ive 8 iteams.. its like a
my final itab data
Items
--------
A 10
A 10
A 10
Subtot 30 "should be yellow color /bold
B 10
B 10
b 10
subtot 30 " should be yellow color /bold
I coded in smart form level as below as. but it doesnt work out.
if &lwa_out-ktgrm_d& = 'subtotal'.
s2 &lwa_out-ktgrm_d& "bold pharagraph format
else
s4 &lwa_out-ktgrm_d& " normal pharagraph format
endif
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.