topic Re: Table Maintenance generator - add filter in Application Development and Automation Discussions

Table Maintenance generator - add filter

Former Member — Mon, 22 Aug 2011 12:11:17 GMT

Hi,

I have a requirement where i have to add filter on the table maintenance generator screen of a Z table.

Now i added a text box.

But how do i apply the filter?

AS in...when i go to the maintenance screen through the tcode i get the entire data of the table. now after i put the filter i just want that specific data.

what i dont get is...which internal table is getting populated to update the screen fields?

I have written the query mention below:

  CASE sy-ucomm.
    WHEN 'FILT'.
      if GD_MATNR is NOT INITIAL.
      SELECT * FROM ZFI_ECC_PROC
        INTO CORRESPONDING FIELDS OF TABLE internal_table
        WHERE matnr = gd_matnr.
      ENDSELECT.
      ENDIF.
  ENDCASE.

what should come in place of internal_table

Please help.

Regards,

Shraddha

Re: Table Maintenance generator - add filter

Former Member — Mon, 22 Aug 2011 12:15:25 GMT

There's just the standard filter: why do you need to replicate it?

Max

Re: Table Maintenance generator - add filter

Former Member — Mon, 22 Aug 2011 12:17:17 GMT

Oh ok ok...under Selection...got it got it...thanx a lot

Re: Table Maintenance generator - add filter

Former Member — Mon, 22 Aug 2011 12:19:17 GMT

But is there a way to get the same on the screen, instead of going under the Selection tab?

regards,

Re: Table Maintenance generator - add filter

ThomasZloch — Mon, 22 Aug 2011 12:21:50 GMT

You might also be able to work with the subset functionality for views. Create a maintenance view for your Z-table, mark e.g. the MATNR field with "S" (subset), and generate the maintenance dialog for the maintenance view, not the table. When entering through SM30, you will be asked to enter selections (i.e. filter).

Thomas

Re: Table Maintenance generator - add filter

Former Member — Mon, 22 Aug 2011 12:29:04 GMT

Yes

Thomas has said all could be said

If you want to open a selection screen as soon as the maintenance dialog is called you need to manage the subset

Max

Re: Table Maintenance generator - add filter

Former Member — Tue, 23 Aug 2011 05:49:40 GMT

hi,

Actually i wanted a button on the screen which could perform the same function as standard filter under Selection. So i added a button and under its functionality i called Perform SUCHEN.

This calls the filter functionality which is under Selection.

This solved my problem.

Thanx anyways

Regards

Re: Table Maintenance generator - add filter

Former Member — Tue, 06 Sep 2011 10:55:37 GMT

Hi Shraddha,

We have similar requirement, can you please let me know how can we get the code for form SUCHEN and what is the form for sort button.

Please let me know how you are able to add the code for filter button which works exactly as ALV filter button.

Thanks and Regards,

Umesh J D

Re: Table Maintenance generator - add filter

Former Member — Wed, 07 Sep 2011 05:42:36 GMT

Hi,

When i created the table maintenance generator i just call form SUCHEN under the functioning of a button i added on the screen.

This perform takes care of sort and filter.

Regards,

Re: Table Maintenance generator - add filter

Former Member — Wed, 07 Sep 2011 10:34:28 GMT

Hi Shraddha,

Thanks for reply. I need to add filter and sort buttons similar to ALV buttons in SM30. These buttons should work as alv buttons.

Please let me know how to achieve this.

Thanks and Regards,

Umesh J D

Edited by: JDumesh on Sep 7, 2011 4:24 PM