Knowledge Management

Question:
Hi Every one
This is Critical Issue... I have Enhance Report One time Customer which is Done using ALV Report For Every sold-to-Customer should have to be in New-Page and and subtotal should be displayed for every sold-to-customer and Total after all the pages are Displayed If anybody can help me...
Thanks
Regards
Satish
Answer:
Set LS_SORT-GROUP = '*'
Where LS_SORT TYPE SLIS_SORTINFO_ALV.
Have a look at Data Element / Domain of ALVDYNP-GROUPLEVEL.
KRK
Answer:
you have do this
I_SORT-SPOS = '1'.
I_SORT-TABNAME = 'i_detail_alv'. " internal table name
I_SORT-FIELDNAME = 'WERK'. " field to sort
I_SORT-UP = 'X'.
I_SORT-DOWN = SPACE.
I_SORT-GROUP = '*'. "PAGE BREAK
I_SORT-SUBTOT = 'X'.
APPEND I_SORT.
Answer:
Hi Kummr ZXXXGuest Your Both Code work Good For New Page with SubTotals and Totals...
One More Issue I have that is For Same Ehnhancement that is also ALV we have feilds like SALES ORDER, INVOICE, NAME4, TOT-INV, NET-VALUE, TOT-PAID, BAL,REFUND DUE. so we customer buys product near us more than one product there is Possibility that More than one Sales INVOICE is generated for for One SALES-ORDER. we are doing calulation if TOT-PAID is greater than TOT-INV REFUND DUE = TOT_PAID-TOT-INV.
and if TOT-INV is Greater than TOT-PAID Then BALANCE = TOT-INV-TOT-PAID...
SO The same are working good for single sales order & Single Invoice
if we have Single Sales Order and Multiple invoice Customer Send one check for both invoice that time what ever chech he is sendding going to REFUND...
SO S-INV T-INV N-VAL T_PAID T-BAL T-REF
001 123 12.5 26 26 0 13.5
001 124 13.5 26 26 0 12.5
look sames salesorder two invoice what ever he send is rufunded back..
inorder to avoid this CAN ANY ONE HELP ME PLEASE THIS IS ALV ONE TIME CUSTOMER REPORT.... ONCE AGAIN I THANKS U LOT BROTHER'S IF U CAN HELP ....
REGARDS
SATISH