Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

ALV Report amount display...

Former Member
0 Kudos

Hi Experts,

I have created alv report with 5 fields in display. In this I am fetching the data from p0057, p0001, p0002 and displaying. I am fetching as Employee number(PERNR), Employee Name(NACHN), policy Number(MTGLN), policy Amount (BETRG) and from this amount(BETRG) is another field for which this will be the total amount of the policy. So, as of my scenario is one employee can have 1 or more policy this will be fetched and policy amount will be displayed and all the policy amount should be calculated and displayed as single amount. As of now I am getting is

O/P:

Employee number Employee Name Policy Number Policy Amount Amount

12345 King 2345889 100.30 0.00

9874536 300.50 400.80

Here I am unable to sort the Amount field because the amount is not similar. I have sorted the emp. no. & emp. name. But I am unable to hide that amount 0.00. Could some one can help me to resolve this issue.

1 REPLY 1

Former Member
0 Kudos

Hi!

Maybe I do not completely understand your request, but why don't you just get rid of the last column (amount) and just subtotalize the column "Policy amount" by employee?

Regards