topic Re: Changing Column Names in ALV Object Model in Application Development and Automation Discussions

Changing Column Names in ALV Object Model

Former Member — Fri, 12 Dec 2008 14:36:31 GMT

Hi All,

In a report development using ALV Object Model, I am required to over write the text given in the data elements for all the fields and display customized text, for the ALV column texts. This is proving to be rather tricky and doesn't work.

I read that to do this, we need to delete the DDIC bindings for the columns, which could be done through CL_SALV_WD_COLUMN_HEADER->SET_PROP_DDIC_BINDING_FIELD. To understand it's usage I researched some more and found the thread:

What I understood from this thread is that the above mentioned class is for use in Web Dynpros. My query is, can't this be used in the context outside of Web Dynpro? If yes, please guide me on how to instantiate classes CL_SALV_WD_COLUMN and CL_SALV_WD_COLUMN_HEADER. If no, please suggest an alternative.

Thanks and Regards,

Vidya.

Re: Changing Column Names in ALV Object Model

Former Member — Fri, 12 Dec 2008 18:38:52 GMT

Hi Vidya

You can create the Field Catlog like this in your object oriented ALV also.

lv_fldcat-row_pos = '1'.

lv_fldcat-col_pos = '1'.

lv_fldcat-fieldname = 'VBELN'.

lv_fldcat-tabname = 'IT_OUTPUT'.

lv_fldcat-outputlen = 10.

lv_fldcat-scrtext_m = 'Order'.

lv_fldcat-icon = 'X'.

Neha

Re: Changing Column Names in ALV Object Model

RaymondGiuseppi — Fri, 12 Dec 2008 18:45:00 GMT

You may try with SET_DDIC_REFERENCE or APPLY_DDIC_STRUCTURE methods of CL_SALV_COLUMN class Change DDIC reference for an individual column/for several columns ([Change of DDIC Reference for a Column|http://help.sap.com/saphelp_sm32/helpdata/en/2c/762c41089b6e24e10000000a155106/frameset.htm])

If you only want to change the texts (header, selection) try with SET_LONG_TEXT, SET_MEDIUM_TEXT and SET_SHORT_TEXT methods of CL_SALV_COLUMN. ([Column Header|http://help.sap.com/saphelp_sm32/helpdata/en/e3/e3eb40c4f8712ae10000000a155106/frameset.htm])

Read the documentation in the above given links and try some search at sdn on keywords like

- [GET_COLUMN ALV|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=get_column+alv&adv=false&sortby=cm_rnd_rankvalue]

- [SET_DDIC_REFERENCE|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=set_ddic_reference&adv=false&sortby=cm_rnd_rankvalue]

- [SET_LONG_TEXT|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=set_long_text&adv=false&sortby=cm_rnd_rankvalue]

Regards

Re: Changing Column Names in ALV Object Model

former_member194669 — Fri, 12 Dec 2008 18:47:55 GMT

Try to do this way


data: gr_columns    type ref to cl_salv_columns_table.
...
...
...
gr_column ?= gr_columns->get_column( text-112 ).   " text-112 = SIGNED
gr_column->set_long_text( 'Signed by Approver' ).   " Here Signed by Approver is the custom heading for the column

a®

Re: Changing Column Names in ALV Object Model

Former Member — Fri, 12 Dec 2008 18:57:29 GMT

Hi,

You can use the GET_COLUMNS and SET_COLUMNS method.

With GET_COLUMNS you get a reference to the individual column objects of the ALV output and make all the technical settings for a column. Once you a reference to each column, you case use the SET_COLUMNS method of each column reference.

[GET_COLUMNS|http://help.sap.com/saphelp_nw04/helpdata/en/5e/88d440e14f8431e10000000a1550b0/frameset.htm]

[SET_COLUMNS|http://help.sap.com/saphelp_nw04/helpdata/en/e3/e3eb40c4f8712ae10000000a155106/content.htm]

regards,

Advait

Re: Changing Column Names in ALV Object Model

Former Member — Fri, 12 Dec 2008 19:45:09 GMT

I thank all of you for trying to help me out. But I'd like to mention here that SET_LONG_TEXT, SET_MEDIUM_TEXT and SET_SHORT_TEXT are not overwriting the labels of the data elements. There is a lot of shuffling around and manipulation that needs to be done, with respect to the output length and the length of the customized column text. Hence, it would probably suit me best if I am somehow able to delink the DDIC reference from the column. Do let me know your thoughts.

Thanks and Regards,

Vidya.

Re: Changing Column Names in ALV Object Model

Bhaskar_K1 — Fri, 12 Dec 2008 22:15:18 GMT

Hi Vidya,

I am not sure? But I would re-build my internal table dynamically and use that instead of the structure being used.

Thanks,

Gokul

Re: Changing Column Names in ALV Object Model

Former Member — Thu, 26 Feb 2009 04:18:43 GMT

Re: Changing Column Names in ALV Object Model

Former Member — Thu, 28 May 2009 11:01:46 GMT

Use the DDICTXT field of the fielcat structure.

Re: Changing Column Names in ALV Object Model

Former Member — Mon, 11 Jul 2016 10:46:10 GMT

First of all if you had used "LVC_FIELDCATALOG_MERGE" and "REUSE_ALV_GRID_DISPLAY_LVC" Function modules then the columns name will come form DDIC.

But to overwrite this you can use this code for every single column where you want the different name than DDIC. try this out:-

wa_fldcat-seltext = 'Location'.

wa_fldcat-reptext = 'Location'.

wa_fldcat-scrtext_s = wa_fldcat-scrtext_m = wa_fldcat-scrtext_l = 'Location'.

MODIFY it_fldcat FROM wa_fldcat TRANSPORTING seltext reptext scrtext_l scrtext_s scrtext_m WHERE fieldname = 'BTEXT'.

1. You need to know which name you want as column name like I had used Location instead of "Personnel Subarea Text",

2. and its table field name from which it was earlier picking the name....like I had "BTEXT"

3. define it_fldcat type lvc_t_fcat. and wa_fldcat type lvc_s_fcat.