layout build

[Former Member]

hi, I am using some of the features for layout build,

columnwidth_optimize works fine and so does zeba but when I try to use subtotals_text and totals_text, the text I input here is not coming up, can somebody explain me a bit on how this works in general.

thanks.

[ssimsekler]

Hi Jamie

I haven't used before but, there is a field 'TXT_FIELD' at the field catalog that may be utilized for this:

"You can use this field to define a reference to a field that is used as the description for the current field. If a subtotal is calculated for the current field, the ALV Grid Control displays the descriptions in the field assigned.

Example: Your output table contains one column for material numbers and one column for the description of what these numbers mean (such as clockwork). If you calculate subtotals for the material numbers, only these numbers are usually displayed as the subtotals text. Based on the link to TXT_FIELD , you can refer to the corresponding column with the material description. This description is then used as the subtotals text."

Or

You can define your subtotal texts utilizing the event <b>'subtotal_text'</b>.

Regards

*--Serdar <a href="https://www.sdn.sap.com:443http://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.sdn.businesscard.sdnbusinesscard?u=qbk%2bsag%2bjiw%3d">[ BC ]</a>

[Former Member]

form layout_build.

w_layout-no_input = 'X'.

w_layout-colwidth_optimize = 'X'.

w_layout-zebra = space.

w_layout-totals_text = 'Totals'.

w_layout-subtotals_text = 'Subtotals'.

endform.

here is my layout function.

is there anything I am missing b/c the text's are not working.

thanks.

[Former Member]

I tried what you said about the ref field, didn't work for me either, here is my field catatlog, maybe I am doing something that is not cancelling out my text actions.

form fieldcat_init using p_fieldcat type slis_t_fieldcat_alv.

data: ls_fieldcat type slis_fieldcat_alv.

w_sortinfo_alv-tabname = 'I_RESULTS_SORTED'. "

w_sortinfo_alv-fieldname = 'KHINR'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

w_sortinfo_alv-spos = 1.

w_sortinfo_alv-group = '*'.

append w_sortinfo_alv to i_sortinfo_alv.

w_sortinfo_alv-tabname = 'I_RESULTS_SORTED'. " Internal

w_sortinfo_alv-fieldname = 'KOSTL'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

w_sortinfo_alv-spos = 2.

w_sortinfo_alv-subtot = 'X'.

append w_sortinfo_alv to i_sortinfo_alv.

w_sortinfo_alv-tabname = 'I_RESULTS_SORTED'. " Internal

w_sortinfo_alv-fieldname = 'COST_ELEMENT'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

w_sortinfo_alv-spos = 3.

w_sortinfo_alv-subtot = 'X'.

append w_sortinfo_alv to i_sortinfo_alv.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Center'.

ls_fieldcat-seltext_m = 'Cost Center'.

ls_fieldcat-seltext_s = 'Cost Center'.

ls_fieldcat-fieldname = 'KOSTL'. "COST CENTER

ls_fieldcat-ref_fieldname = 'Cost Center Total: '.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Employee Number'.

ls_fieldcat-seltext_m = 'Employee Number'.

ls_fieldcat-seltext_s = 'Employee Number'.

ls_fieldcat-fieldname = 'PERNR'. "Employee Number

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-key = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Employee Name'.

ls_fieldcat-seltext_m = 'Employee Name'.

ls_fieldcat-seltext_s = 'Employee Name'.

ls_fieldcat-fieldname = 'NAME'. "Employee Name

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-key = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Business Area'.

ls_fieldcat-seltext_m = 'Business Area'.

ls_fieldcat-seltext_s = 'Business Area'.

ls_fieldcat-fieldname = 'GSBER'. "B AREA

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'WageType'.

ls_fieldcat-seltext_m = 'WageType'.

ls_fieldcat-seltext_s = 'WageType'.

ls_fieldcat-fieldname = 'WTYPE'. "Wage Type

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'WageType Description'.

ls_fieldcat-seltext_m = 'WageType Description'.

ls_fieldcat-seltext_s = 'WageType Description'.

ls_fieldcat-fieldname = 'WTYPE_TEXT'. "Wage Type

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Element'.

ls_fieldcat-seltext_m = 'Cost Element'.

ls_fieldcat-seltext_s = 'Cost Element'.

ls_fieldcat-fieldname = 'COST_ELEMENT'. "GL

ls_fieldcat-ref_fieldname = 'Cost Element Total: '.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Gross'.

ls_fieldcat-seltext_m = 'Gross'.

ls_fieldcat-seltext_s = 'Gross'.

ls_fieldcat-fieldname = 'GROSS'. "Gross

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'CPP'.

ls_fieldcat-seltext_m = 'CPP'.

ls_fieldcat-seltext_s = 'CPP'.

ls_fieldcat-fieldname = 'CPP'. "CPP

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'EI'.

ls_fieldcat-seltext_m = 'EI'.

ls_fieldcat-seltext_s = 'EI'.

ls_fieldcat-fieldname = 'EI'. "EI

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'MED'.

ls_fieldcat-seltext_m = 'MED'.

ls_fieldcat-seltext_s = 'MED'.

ls_fieldcat-fieldname = 'MED'. "MED

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'GRP'.

ls_fieldcat-seltext_m = 'GRP'.

ls_fieldcat-seltext_s = 'GRP'.

ls_fieldcat-fieldname = 'GRP'. "GRP

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'LTD'.

ls_fieldcat-seltext_m = 'LTD'.

ls_fieldcat-seltext_s = 'LTD'.

ls_fieldcat-fieldname = 'LTD'. "LTD

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'PSA'.

ls_fieldcat-seltext_m = 'PSA'.

ls_fieldcat-seltext_s = 'PSA'.

ls_fieldcat-fieldname = 'PSA'. "PSA

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Sub Total 627100'.

ls_fieldcat-seltext_m = 'Sub Total 627100'.

ls_fieldcat-seltext_s = 'Sub Total 627100'.

ls_fieldcat-fieldname = 'SUB_TOTAL'. "Sub Total

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Pension 627400'.

ls_fieldcat-seltext_m = 'Pension 627400'.

ls_fieldcat-seltext_s = 'Pension 627400'.

ls_fieldcat-fieldname = 'RET_PENSION'. "RET Pension

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Total'.

ls_fieldcat-seltext_m = 'Total'.

ls_fieldcat-seltext_s = 'Total'.

ls_fieldcat-fieldname = 'TOTAL'. "Total

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Level'.

ls_fieldcat-seltext_m = 'Level'.

ls_fieldcat-seltext_s = 'Level'.

ls_fieldcat-fieldname = 'LEVEL'. "LEVEL

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Center Group'.

ls_fieldcat-seltext_m = 'Cost Center Group'.

ls_fieldcat-seltext_s = 'Cost Center Group'.

ls_fieldcat-fieldname = 'KHINR'. "COST CENTER GROUP

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Description'.

ls_fieldcat-seltext_m = 'Description'.

ls_fieldcat-seltext_s = 'Description'.

ls_fieldcat-fieldname = 'DESCRIPT'. "DESCRIPTION

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

endform.

also I wante to page break only after the kostl total, the way I have it now it is page breaking afer cost element total.

thanks.

[Former Member]

actually here is the better feild Catalog, i found a bunch of problems with the old one.

form fieldcat_init using p_fieldcat type slis_t_fieldcat_alv.

data: ls_fieldcat type slis_fieldcat_alv.

w_sortinfo_alv-tabname = 'I_RESULTS'. "

w_sortinfo_alv-fieldname = 'KHINR'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

append w_sortinfo_alv to i_sortinfo_alv.

w_sortinfo_alv-tabname = 'I_RESULTS'. " Internal

w_sortinfo_alv-fieldname = 'KOSTL'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

w_sortinfo_alv-subtot = 'X'.

append w_sortinfo_alv to i_sortinfo_alv.

w_sortinfo_alv-tabname = 'I_RESULTS'. " Internal

w_sortinfo_alv-fieldname = 'COST_ELEMENT'. " Give Fieldname

w_sortinfo_alv-up = 'X'.

w_sortinfo_alv-subtot = 'X'.

append w_sortinfo_alv to i_sortinfo_alv.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Center'.

ls_fieldcat-seltext_m = 'Cost Center'.

ls_fieldcat-seltext_s = 'Cost Center'.

ls_fieldcat-fieldname = 'KOSTL'. "COST CENTER

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Employee Number'.

ls_fieldcat-seltext_m = 'Employee Number'.

ls_fieldcat-seltext_s = 'Employee Number'.

ls_fieldcat-fieldname = 'PERNR'. "Employee Number

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Employee Name'.

ls_fieldcat-seltext_m = 'Employee Name'.

ls_fieldcat-seltext_s = 'Employee Name'.

ls_fieldcat-fieldname = 'NAME'. "Employee Name

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Business Area'.

ls_fieldcat-seltext_m = 'Business Area'.

ls_fieldcat-seltext_s = 'Business Area'.

ls_fieldcat-fieldname = 'GSBER'. "B AREA

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'WageType'.

ls_fieldcat-seltext_m = 'WageType'.

ls_fieldcat-seltext_s = 'WageType'.

ls_fieldcat-fieldname = 'WTYPE'. "Wage Type

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'WageType Description'.

ls_fieldcat-seltext_m = 'WageType Description'.

ls_fieldcat-seltext_s = 'WageType Description'.

ls_fieldcat-fieldname = 'WTYPE_TEXT'. "Wage Type

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Element'.

ls_fieldcat-seltext_m = 'Cost Element'.

ls_fieldcat-seltext_s = 'Cost Element'.

ls_fieldcat-fieldname = 'COST_ELEMENT'. "GL

ls_fieldcat-ref_fieldname = 'Cost Element Total: '.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Gross'.

ls_fieldcat-seltext_m = 'Gross'.

ls_fieldcat-seltext_s = 'Gross'.

ls_fieldcat-fieldname = 'GROSS'. "Gross

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'CPP'.

ls_fieldcat-seltext_m = 'CPP'.

ls_fieldcat-seltext_s = 'CPP'.

ls_fieldcat-fieldname = 'CPP'. "CPP

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'EI'.

ls_fieldcat-seltext_m = 'EI'.

ls_fieldcat-seltext_s = 'EI'.

ls_fieldcat-fieldname = 'EI'. "EI

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'MED'.

ls_fieldcat-seltext_m = 'MED'.

ls_fieldcat-seltext_s = 'MED'.

ls_fieldcat-fieldname = 'MED'. "MED

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'GRP'.

ls_fieldcat-seltext_m = 'GRP'.

ls_fieldcat-seltext_s = 'GRP'.

ls_fieldcat-fieldname = 'GRP'. "GRP

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'LTD'.

ls_fieldcat-seltext_m = 'LTD'.

ls_fieldcat-seltext_s = 'LTD'.

ls_fieldcat-fieldname = 'LTD'. "LTD

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'PSA'.

ls_fieldcat-seltext_m = 'PSA'.

ls_fieldcat-seltext_s = 'PSA'.

ls_fieldcat-fieldname = 'PSA'. "PSA

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Sub Total 627100'.

ls_fieldcat-seltext_m = 'Sub Total 627100'.

ls_fieldcat-seltext_s = 'Sub Total 627100'.

ls_fieldcat-fieldname = 'SUB_TOTAL'. "Sub Total

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Pension 627400'.

ls_fieldcat-seltext_m = 'Pension 627400'.

ls_fieldcat-seltext_s = 'Pension 627400'.

ls_fieldcat-fieldname = 'RET_PENSION'. "RET Pension

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Total'.

ls_fieldcat-seltext_m = 'Total'.

ls_fieldcat-seltext_s = 'Total'.

ls_fieldcat-fieldname = 'TOTAL'. "Total

ls_fieldcat-ref_tabname = 'I_RESULTS'.

ls_fieldcat-inttype = 'P'.

ls_fieldcat-do_sum = 'X'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Level'.

ls_fieldcat-seltext_m = 'Level'.

ls_fieldcat-seltext_s = 'Level'.

ls_fieldcat-fieldname = 'LEVEL'. "LEVEL

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Cost Center Group'.

ls_fieldcat-seltext_m = 'Cost Center Group'.

ls_fieldcat-seltext_s = 'Cost Center Group'.

ls_fieldcat-fieldname = 'KHINR'. "COST CENTER GROUP

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Description'.

ls_fieldcat-seltext_m = 'Description'.

ls_fieldcat-seltext_s = 'Description'.

ls_fieldcat-fieldname = 'DESCRIPT'. "DESCRIPTION

ls_fieldcat-no_out = 'X'.

ls_fieldcat-ref_tabname = 'I_RESULTS'.

append ls_fieldcat to p_fieldcat.

[Former Member]

Hi,

clear ls_fieldcat.

ls_fieldcat-seltext_l = 'Employee Name'.

ls_fieldcat-seltext_m = 'Employee Name'.

ls_fieldcat-seltext_s = 'Employee Name'.

ls_fieldcat-fieldname = 'NAME'. "Employee Name

<b>ls_fieldcat-ref_tabname = 'I_RESULTS'.</b>

The reference table name should be some database table name.

append ls_fieldcat to p_fieldcat

Can aslo check this sample program

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_enhanced.htm

Revert back to me if u have any queries.

Thanks & Reagrds,

Judith.

[Former Member]

thanks, when I use the totals_text option in my layout build method, it doesn't how on the report. I have put a break point to see what my w_layout(layout workarea) has in it and the value for totals_text is correct, but for some reason it doesn't show up on the report.

[jayanthi_jayaraman]

Hi,

Check this link.In this ,they are using totals_text.

http://www.sap4.com/codigo-158.html

[Former Member]

Hi,

Have u checked the code in this link

http://www.sapdevelopment.co.uk/reporting/alv/alvgrid_enhanced.htm

Check with the declaration part once.

call function 'REUSE_ALV_GRID_DISPLAY'

exporting

i_callback_program = gd_repid

i_callback_top_of_page = 'TOP-OF-PAGE' "see FORM

i_callback_user_command = 'USER_COMMAND'

• i_grid_title = outtext

<b> is_layout = gd_layout</b>

it_fieldcat = fieldcatalog[]

• it_special_groups = gd_tabgroup

it_events = gt_events

is_print = gd_prntparams

i_save = 'X'

• is_variant = z_template

tables

t_outtab = it_ekko

exceptions

program_error = 1

others = 2.

Check wither u have passed the workarea in the call function.

Please reward points and close if ur problem got solved.

Message was edited by: Judith Jessie Selvi

[Former Member]

I checked and I am passing it in the function module,

is_layout = w_layout

and I checked the contents of w_layout and subtotals_text and totals_text have the right values.