topic Re: problem in adding columns to ALV display in Application Development and Automation Discussions

problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 10:12:27 GMT

Hi,

Presently Iam using FM 'LVC_FIELDCATALOG_MERGE' to build field catelog by exporting Ztable.

Now I want to add 3 extra columns in ALV output from a different table(Internal table).

My code is as below.

CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'

EXPORTING

I_BUFFER_ACTIVE =

I_STRUCTURE_NAME = 'ZFXXAPPERRPROC'

I_CLIENT_NEVER_DISPLAY = 'X'
I_BYPASSING_BUFFER =
I_INTERNAL_TABNAME =

CHANGING

ct_fieldcat = pt_fieldcat

EXCEPTIONS

INCONSISTENT_INTERFACE = 1

PROGRAM_ERROR = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Can u pls help me to achieve this.

Thanks in advance.

-Sravanthi

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 10:21:55 GMT

OK, you are using the FIELDCATALOG_MERGE to take the base fieldcatalog. Now you want to add some new fields. Add the information into the working area of the fieldcatalog and then append this into the fieldcatalog.

Actually you are using the FM to download the fieldcatalog from the table structure. The fieldcatalog is a table without a header line, for this reason you are using the working area (LVC_S_FCAT). Add your new fields by appending the wa_fieldcat to fieldcat.

Wiht Regards

George

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 10:23:41 GMT

Hi Shravanthi,

You can try to build a new internal table by combining the currently-used "pt_fieldcat" table and the 3 new columns.

Then, pass this larger internal table to the FM.

Technically, it is not possible to pass two internal tables to this FM. Also, using the above method, you can merge the rows correctly.

Hope this helps! Do revert if you need anything else!!

Cheers,

Shailesh

Always provide feedback for helpful answers!

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 10:27:42 GMT

Hi,

Using field catalog merge, first populate the internal table for field catalog. Then modify this table to add three new columns from your internal table. For that define a work area for the field catalog and populate it with required details and then append it to the internal table of field catalog.

L_FIELDCAT-COL_POS      = V_C_01.
  L_FIELDCAT-FIELDNAME    = V_C_TEXT.
  L_FIELDCAT-TABNAME      = L_C_TABNAME.
  L_FIELDCAT-SELTEXT_L    = TEXT-001.                    "TEXT
  L_FIELDCAT-KEY          = V_C_X.
  L_FIELDCAT-OUTPUTLEN    = L_C_OUT1.
  APPEND L_FIELDCAT TO FP_I_FIELDCAT.
  CLEAR L_FIELDCAT.

Thanks

Sourav

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 10:28:13 GMT

Hi,

By using 'LVC_FIELDCATALOG_MERGE' we can build a fieldcatalog with particular one structure only.

If you want to add 3 more fields from internal table then add those field into your structure ( i.e ZFXXAPPERRPROC) otherwise build the fieldcatalog by appending individual fields (from structure ZFXXAPPERRPROC and 3 more fields from internal table).

Thanks & Regards,

Rajani.

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 16:04:42 GMT

Hi,

Anlternative Solution for your Dynamic fieldcat is:

Steps:

1. We have Structure / Table name

2. Get fields and its details from DD03L Table for the given table / Stucture.

3. Get Field Descriptions from DD04T table for all ROLLNAMES from the DD03L data. (Rollname is Dataelement)

4. Build field catalog from this data.

5. Add additional fields how many you want.

Note: In the given Table / Structure if we have Vurrency / Quantity fields, we need to pass ref field name.

Regards,

Balaji Peethani.

Edited by: Peethani Balaji on Aug 14, 2009 6:05 PM

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 17:05:52 GMT

Hi Sravanthi,

1) Create a new structure ZFXXAPPERRPROC_ALV.

2) Include ZFXXAPPERRPROC in the structure ZFXXAPPERRPROC_ALV.

3) Add the 3 new fields to structure ZFXXAPPERRPROC_ALV.

4) Pass structure ZFXXAPPERRPROC_ALV to the function module instead of table ZFXXAPPERRPROC.

REFRESH pt_fieldcat.

CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
  EXPORTING
    i_structure_name = 'ZFXXAPPERRPROC_AVL'
  CHANGING
    ct_fieldcat      = pt_fieldcat
  EXCEPTIONS
    OTHERS           = 0.

Re: problem in adding columns to ALV display

Former Member — Fri, 14 Aug 2009 17:14:50 GMT

Hi Sravanthi,

after using LVC field cat merge, your field catalog is generated.

its a like a normal internal table.. right?

so just add the rest of the three fields to it with append statements.

this solves yours problem...

Re: problem in adding columns to ALV display

Clemenss — Sat, 15 Aug 2009 19:43:06 GMT

Hi Sravanthi Palepu,

if you want to display more columns, you need:

- a new internal table with more columns

- the columns in the field catalog.

The first task is much more complec then the last:

You may re-create the internal table using runtime dynamic type services but you may run into trouble as soon as any column is not based on a data dictionary domain, i.e. direct type entry.

It may be much easier to create a copy of the existing dictionary structure. Add the new fields here. Use it to define the internal table to display and the fieldcatalog as well.

Regards,

Clemens.

Re: problem in adding columns to ALV display

Former Member — Mon, 17 Aug 2009 05:08:27 GMT

hi ,

you should hide/show the column you want to add.

declare your column in your node, hide it at first, and then when the user clicks on the button 'add' show it. you have to manage this in your modifyView method.

I hope this helps.

-Thanks

Saurabh Goel