Dear All
In ALV Report for the column with quan , curr type the total is not coming even aftet setting do_sum = 'X'.
If I click on 'sum' icon at the report output, system gives the following message.
'Desired operation cannot be perfomed on column ...'
Its a internal table refrring to the Quan field data element('ZAVAIL_CT')
and in the fieldscat i have given ls_fcat-rollname = 'ZAVAIL_CT'.
kindly advice
Thanks
2 Answers
-
Former MemberPosted on Nov 30, 2007 at 06:46 AMHI,
For quan and prec data type i think it is not possible to do tht..Otherwise u can do it like convert to a integer and put in the same internal table after creating a new fiels od int type..
So tht u can copy all the quan field contents to it and u can sum it and display..
Use transporting stmt for this kind of situations..SUrely it will work..If it is not converting directly means first u convert it to char and then to int..
REWARD IF USEFUL
Add a comment
-
Former MemberPosted on Nov 30, 2007 at 06:54 AM
hi,
<b>For getting the total and subtotal, field shuld be a non characteric field.</b>
after that, decalte the data type in field catlog.
<b>eg:</b>
<b>it_fieldcat-datatype = 'CURR', "depends on the type of field</b>
it_fieldcat-do_sum = 'X',
Add a comment
Add a comment