Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How Calculate TOTALS,SUBTOTALS in ALV Reporting?

Answer Posted / gogo

1. You need 2 internal tables: FIELDCATALOG table and SORT table
DATA: gt_fieldcatalog TYPE lvc_t_fcat,
gt_fieldcatalog_sort TYPE lvc_t_sort,
lw_fcat TYPE lvc_s_fcat,
lw_fcat_sort TYPE lvc_s_sort.

2. Fill fieldcatalog table fields
lw_fcat-fieldname = 'YOUR FIELD NAME'.
* Subtotal for this field
lw_fcat-do_sum = 'X'.
APPEND lw_fcat TO gt_fieldcatalog.

3. Fill sort table fields
* Mark the fields that you want to make subtotals after
(e.g. VKORG KUNNR VBELN = keys ; NETWR = sum)
CASE 'YOUR FIELD NAME'.
WHEN 'VKORG' OR 'KUNNR'.
lw_fcat_sort-fieldname = u_fieldname.
lw_fcat_sort-up = 'X'.
lw_fcat_sort-subtot = 'X'.
APPEND lw_fcat_sort TO gt_fieldcatalog_sort.
WHEN OTHERS.
ENDCASE.

Risult
VKORG | KUNNR | VBELN |NETWR
1 a 001 10
1 a 002 20
1 a 003 30
----------------------------
subtotal 1 a 60
----------------------------
1 b 001 5
----------------------------
subtotal 1 b 5
----------------------------

Hope it helps!

Is This Answer Correct ?    25 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you activate a function exit?

992


What is hotspot?

1393


What is the tcode to create indexes?

1001


Explain the difference between a dialog program and a report?

959


What is repository info. Systems?

1066


What are the data types of internal tables?

1046


What happens if only one of the commands set screen and leave screen is used without using the other?

1049


What are the two ways for restricting the value range for a domain? : sap abap data dictionary

1232


Name a few data dictionary objects? : abap data dictionary

1083


What are the organizational related infotypes? : abap hr

1143


How can you access the function code from menu painter?

1132


What is a multiple line field? : abap bdc

1057


The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary

1253


What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?

1255


how to read the standard field value in your custom program.

1438