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: 

Sub totaling for the field in va05

Former Member
0 Kudos

Hi Experts,

I have add custom field in va05. Now i want to do total and subtotal for the custom field. Is there a way for aching this requirement. Could.Could any body help me out in this situation.

Regards,

Quddus.

1 ACCEPTED SOLUTION

pranab_kumarjha
Explorer
0 Kudos

Hi,

Yes, if your field is a numeric field, then its possible to do a summation on the same.

There is already an option in the ALV display of VA05 to fo the summation.Just select the column and then summation.

Also do let me know if you are looking for automatic summation.

That you can do via change layout(the last icon after summation), add the custom field to the left and click on aggregation Check box. Save the layout for default.

4 REPLIES 4

pranab_kumarjha
Explorer
0 Kudos

Hi,

Yes, if your field is a numeric field, then its possible to do a summation on the same.

There is already an option in the ALV display of VA05 to fo the summation.Just select the column and then summation.

Also do let me know if you are looking for automatic summation.

That you can do via change layout(the last icon after summation), add the custom field to the left and click on aggregation Check box. Save the layout for default.

0 Kudos

Hi Pranab,

Thank you.

raymond_giuseppi
Active Contributor
0 Kudos

This report is an ALV, so it is easy to select the column and click on the Sum icon (if you used a correct numeric type for field of course)

NB: If your actual requirement was to get this by default, as there is no option to save a default variant (Check for your version) you have to debug/analysis to find step where SAP build the fieldcatalog, and using an implicit enhancement spot (or any available BAdI) to set the SUM field of the field catalog for our field.

Hint: set a break-point in form as REUSE_ALV_LIST_DISPLAY or ALV_LIST_OUTPUT of  program SAPMV75A.

Regards,

Raymond

0 Kudos

Hi Raymond,

We can create layout variant. After executing the report. Goto systems->user profile->own data.

In that maintain the following entry, Parameter: SD_VARIANT_MAINTAIN Value: A.

Now you can create the layout variant.