topic Re: ALV Grid subtotal function - two columns as one in Application Development and Automation Discussions

ALV Grid subtotal function - two columns as one

Former Member — Mon, 14 Feb 2011 19:45:27 GMT

Hello experts,

I am using a ALV GRID with function ... and i have a problem with subtotals, how can i a take 2 columns as one in the subtotal

i mean i have 4 columns .... CODE1 DESC1 and CODE2 DESC2 and the amount columns AMOUN1 AMOUNT2

if i subtotalize by colums i am going to have 4 leveles plus the gran total.

HOw can i make te CODE1 and DESC1 act as just one colums ... that theyll be at the same level. So ill just have 2 leves plus the gran total.

Thx in advance .

Re: ALV Grid subtotal function - two columns as one

Former Member — Mon, 14 Feb 2011 20:19:57 GMT

Hello!

Im not sure if it's what you need, but this FIELDCAT-SP_GROUP defines a group in your fieldcat, and the columns added to this group act as one. I never tried using this, let us know if it works and fixes your problem.

See ya.

Thales Schmidt

Re: ALV Grid subtotal function - two columns as one

Former Member — Tue, 15 Feb 2011 06:51:44 GMT

in Fieldcar Cat loge

DATA: ls_fieldcat TYPE slis_fieldcat_alv.

CLEAR wa_fieldcat.

Use this condition where u Defin. tax for Column Name

*Total

wa_fieldcat-fieldname = 'TOTAL'.

wa_fieldcat-key = ''.

*wa_fieldcat-do_sum = 'X'.

wa_fieldcat-emphasize = 'C300'.

wa_fieldcat-outputlen = 20.

wa_fieldcat-seltext_l = 'Current Total '.

APPEND wa_fieldcat TO t_fieldcat.

CLEAR wa_fieldcat.

at end of Field Use

gs_sort-fieldname = 'TXT50'.

gs_sort-spos = 2.

gs_sort-up = 'X'.

Re: ALV Grid subtotal function - two columns as one

Former Member — Tue, 15 Feb 2011 06:52:02 GMT

in Fieldcar Cat loge

DATA: ls_fieldcat TYPE slis_fieldcat_alv.

CLEAR wa_fieldcat.

Use this condition where u Defin. tax for Column Name

*Total

wa_fieldcat-fieldname = 'TOTAL'.

wa_fieldcat-key = ''.

*wa_fieldcat-do_sum = 'X'.

wa_fieldcat-emphasize = 'C300'.

wa_fieldcat-outputlen = 20.

wa_fieldcat-seltext_l = 'Current Total '.

APPEND wa_fieldcat TO t_fieldcat.

CLEAR wa_fieldcat.

at end of Field Use

gs_sort-fieldname = 'TOTAL'.

gs_sort-spos = 2.

gs_sort-up = 'X'.

Edited by: Shailesh Dhanani on Feb 15, 2011 7:52 AM

Re: ALV Grid subtotal function - two columns as one

Former Member — Tue, 15 Feb 2011 06:57:56 GMT

Hello

http://wiki.sdn.sap.com/wiki/display/Snippets/DisplaysubtotaltextinALV+grid

this z usefull for u pls try it.

Re: ALV Grid subtotal function - two columns as one

RaymondGiuseppi — Tue, 15 Feb 2011 07:14:58 GMT

In the sort parameter (type LVC_T_SORT in OO or SLIS_T_SORTINFO_ALV in old REUSE library)

- Define all key fields as sort criteria CODE1, DESC1 -> UP = 'X'

- Only define only one field as sub-total level, e.g. text DESC1 -> SUBTOT = 'X'

Ref: [Fields of the Sort Table|http://help.sap.com/saphelp_erp2004/helpdata/en/9e/2c7b38180fee45e10000009b38f8cf/frameset.htm]

Regards,

Raymond

Re: ALV Grid subtotal function - two columns as one

former_member184635 — Tue, 15 Feb 2011 12:24:31 GMT

Hi,

R u sure, you will need six (6) cloumns. Will three (3) columns will not suffice.

In the field catlogue just mark the field do_sum = 'X' for the Amount column.

Rest cloumns do the sorting.

Hope this will help.

Regards,

Dadarao.