Supress the Total line in an ALV

[former_member603051]

<Modified subject line>

Hello everybody,,

I have a ALV objects with subtotals by Currency and summation by amount, I have done this ALV with i_sort internal table and field do_sum = 'AMOUNT' in fieldcatalog.

CLEAR lwa_sort. 
    lwa_sort-spos = 1.                            
    lwa_sort-fieldname =  'CURRENCY'. 
    lwa_sort-up = 'X'. 
    lwa_sort-subtot = c_flag. 
    APPEND lwa_sort TO li_sort.

<Added code tags>

Invoice Currency Amount

Example A EUR 1430.00

C EUR 1000.00

2430.00

D ZAR 13.00

E ZAR 1.00

14.00

TOTAL 2444.00

I need to know how to withdraw this Total because does not have sense.

Thanks in advance

Moderator Message: Please use meaningful subject lines & use code tags when using a code snippet

Edited by: Suhas Saha on Jun 29, 2011 4:25 PM

[SuhaSaha]

Hello,

I need to know how to withdraw this Total because does not have sense. 

You have to pass NO_TOTALLINE = 'X' in the layout definition.

BR,

Suhas

[raymond_giuseppi]

Don't withdraw the sub-total but correct you field catalog establishing the link between amount and currency code, so ALV will perform a sub-total per currency code, you wont need to add currency to sort criteria.

([Value Display with Currency/Quantity Unit|http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/ff/4649b1f17411d2b486006094192fe3/content.htm])

Regards,

Raymond