on 12-11-2008 5:04 AM
Hi Guru's
I'm using routine to pull the customer, date, billing no etc, Here I need to display grouping customer wise sub-total need to display.
Like below example:
Customer date billing Amt
10000004 10/02/2005 148 10
10000004 10/03/2005 149 20
Sold-to total 30
10000005 10/01/2005 123 20
10000005 10/02/2005 125 20
Sold-to total 40
Please Help me How to do this...
hi,
in the driver pgm u have to use the control break statement.
if u want to print the customer no.
first u have to sort the internal table by customer.
loop at itab.
call function 'WRITE_FORM'
element = 'X'
at last statement.
call function 'WRITE_FORM'
element = 'X1'
end at.
endloop.
in the script pgm u have to use the 2 textelement in main window. 1 for print all details
and another for print the sub tot.
regards
sathis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Murali,
LOOP AT itab.
"Write item
CALL FUNCTION 'WRITE_FORM'
EXPORTING
element = 'ITEM'
window = 'MAIN'
.
AT END OF field.
SUM.
"Display Subtotal
"Write item
CALL FUNCTION 'WRITE_FORM'
EXPORTING
element = 'SUBTOTAL'
window = 'MAIN'
.
END AT.
ENDLOOP.
In you sapscript Main Window...
/E ITEM
/: &itab-field1&,,&itab-field2
/E SUBTOTAL
/: &itab-totalfield
/: NEW-PAGE
Regards,
Flavya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Murali,
use "on change of customer" in your program.
regards,
Lokesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.