topic Re: ALV data refresh in Application Development and Automation Discussions

ALV data refresh

Former Member — Mon, 10 Apr 2006 15:31:20 GMT

Hi all,

I am using FM : REUSE_ALV_GRID_DISPLAY to set up an ALV list.

I have added a button to export the data to a particular format of text as a *.txt document.

I use the function REUSE_ALV_GRID_LAYOUT_INFO_GET to know which fields are visible and I also get back the sort and filter criterias.

I now want to apply these criteria to my internal table so that I am only left with the same data as the ALV display.

I have not found a function that applies the filter and sort types to an internal table ...

Has anyone got an idea ?

Nicolas

Re: ALV data refresh

Former Member — Mon, 10 Apr 2006 15:43:50 GMT

Nicolas,

That means you will have to create a internal table at run time with only those fields that have been left out after filtering, right?

As discussed in the previous thread, REUSE_ALV_GRID_LAYOUT_INFO_GET will give you back the fields which are still existing on the screen. Now with those field create another field catalog (say DYNAMIC_FCAT) by manually appending the data. This fieldcat will be of type LVC_T_FCAT. Once you have that field catalog, create a table dynamically using the procedure show in the blog.

/people/ravikumar.allampallam/blog/2005/05/31/expand-the-list-of-columns-in-a-report-dynamically

Once you have a table, loop at the main data table, move the corresponding fields into the work area of the dynamic table and append that to the table. At the end of the loop you will have a separate internal table with only those fields which are selected.

Now, you can download the table data easily.

Hope this solves your issue

Regards,

Ravi

Note : Please mark the helpful answers

Re: ALV data refresh

Former Member — Mon, 10 Apr 2006 15:50:46 GMT

Hi Ravi,

I have got the part about the fields working fine, it's rather the filtering and sorting I need to apply now...

Nicolas

Re: ALV data refresh

Former Member — Mon, 10 Apr 2006 16:12:15 GMT

Nicolas,

SORTING - From the table that is coming back, I am sure you will be able to figure the SORTING Criteria using the FIELDNAME, SORT POS, UP (Ascending), DOWN (Descending).

Then, you can SORT you table as well.

SORT dynamic_table by (fieldname).

FILTERING - This is a little complex. I am only throwing ideas here, as I have never done this myself.

Out of Filter info, the following fields will be of use for us. You need to figure out what data comes into each of these fields.

FIELDNAME TYPE SLIS_FIELDNAME,

TABNAME TYPE SLIS_TABNAME,

SELTEXT(40),

VALUF(80),

VALUT(80),

VALUF_INT(80),

VALUT_INT(80),

SIGN0(1),

SIGN_ICON(4),

OPTIO(2),

STYPE(1),

These fields are acting like SELECT OPTIONS. I can figure out SIGNO and OPTIO are, however I am not sure where are the values for upper limit and lower limit, it has to be two of VALUF and VALUT fields.

Once we figure that out, we need to apply the criteria manually, something like

If SIGN = 'I' and OPTIO = 'EQ'.

LOOP AT THE DATA TABLE WHERE (FIELDNAME) = VALUET - ASSUMING THAT VALUET HAS THE LOWER LIMIT.

ENDIF.

Similarly for the other options as well. I know its painful, but we will have to manually handle all the options of the SELECT OPTIONS.

Hope this makes sense to you.

Regards,

Ravi

Note : Please mark the helpful answers

Re: ALV data refresh

Former Member — Mon, 10 Apr 2006 18:24:44 GMT

Hi,

Did you solve the issue?

Let me know what was the solution implemented.

regards,

Ravi