2008 Feb 12 11:49 AM
i want to create report using write statement as per format given below.
item name item code amount
____________________________________
capital 1 101 1000
capital 2 102 2000
capital 3 103 3000
____________________________________
Total 6000
How to create this report using write statement ?
2008 Feb 12 11:54 AM
Hi,
loop at itab.
write: / itab-name,
itab-number,
itab-sno,
itab-amount.
w_sum = w_sum + itab-amout.
endloop.
write: w_sum.
Plzz reward points if it helps.
Hi Santosh,
Its as simple as you need to WRITE statement before what you need. Is it not??
If you want create empty line use SKIP statement.
WRITE:/ 'item name item code amount'.
SKIP.
WRITE:/ '____________________________________'.
WRITE:/ 'capital 1 101 1000'.
WRITE:/ 'capital 2 102 2000'.
WRITE:/ 'capital 3 103 3000'.
WRITE:/ '____________________________________'.
SKIP.
WRITE:/ 'Total 6000'.
Thanks,
Vinay
2008 Feb 12 11:54 AM
HI,
Use the following logic.
put the netries into the table itab.
Write 😕 'item name',
15 'item',
20 'code',
25 'amount'.
write : uline.
loop at itab.
write 😕 itab-itmname,
15 itab-item,
20 itab-code,
25 itab-amt.
endloop.
write :uline.
REward appropraite points
Regards,
MAnsi.
2008 Feb 12 11:54 AM
Hi
after filling ur internal table,
write:/5item 8 name 10 item code 15 amount.
write:syuline.
loop at itab.
write:?
endloop.
at end of amount.
sum.
endat.
write:sy-uline.
2008 Feb 12 11:54 AM
Hi,
loop at itab.
write: / itab-name,
itab-number,
itab-sno,
itab-amount.
w_sum = w_sum + itab-amout.
endloop.
write: w_sum.
Plzz reward points if it helps.
2008 Feb 12 11:55 AM
Hi Santosh,
Its as simple as you need to WRITE statement before what you need. Is it not??
If you want create empty line use SKIP statement.
WRITE:/ 'item name item code amount'.
SKIP.
WRITE:/ '____________________________________'.
WRITE:/ 'capital 1 101 1000'.
WRITE:/ 'capital 2 102 2000'.
WRITE:/ 'capital 3 103 3000'.
WRITE:/ '____________________________________'.
SKIP.
WRITE:/ 'Total 6000'.
Thanks,
Vinay
2008 Feb 12 11:58 AM
If U have all the data in an internal table ..
say Itab .. with 3 fields f1 f2 f3 ..
sort itab by f1.
write :/2 'item name',
15 'item code',
25 'amount'.
write 😕 sy-uline(80).
Loop at itab.
write :/2 itab-f1,
15 itab-f2,
25 itab-f3.
at last.
sum.
write :/2 itab-f3.
endat.
endloop.
write 😕 sy-uline(80).
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |