topic Re: ALV report in Application Development and Automation Discussions

ALV report

Former Member — Tue, 25 Mar 2008 14:20:00 GMT

hi frd,

im my report im display amount field, but the amount value is negative and next value is positive now i have to add the amount for example first amount is -10 and second amount value + 5. while sum the value i want to get as -5. how to include the negative sign in alv report.

im have more than 12,000 record in my display.

how to include the sign in the ALV.

karthi.

Re: ALV report

Former Member — Tue, 25 Mar 2008 14:23:15 GMT

Hi,

While building the fieldcatalog, for amount field use gs_fieldcat-do_sum ='X'. You will get the desired output.

Thanks,

Sriram Ponna.

Re: ALV report

Former Member — Tue, 25 Mar 2008 14:28:42 GMT

selecting the amount from the database table, positive value will come, but if the amount is negative a special indicator is available. how to include the sign value in the ALV report.

karthi.

Re: ALV report

valter_oliveira — Tue, 25 Mar 2008 17:56:09 GMT

Hello.

In the field catalog of ALV, make that field of type "QUANT" or "CURR".

Best regards.

Valter Oliveira.

Re: ALV report

Former Member — Tue, 25 Mar 2008 18:08:10 GMT

hi ,

in the fieldcat there is an option for sign like this..

it_fieldcat-no_sign = 'X'.

for the details use the program BALVBT01 or RFDSLD00

regards,

venkat.