how to add a filter functionality in classical reports

[Former Member]

Hi, Experts

I had Developed a  Classical Report, Now my Client want to Add the FILTER FUNCTIONALITY   for the Report.

How to achieve it, is there any FM or class or Standard code for the filter functionality .

Thank you

Regards

  Abhinav N

[Former Member]

HI, Why dont you use an ALV display?

If that's not possible, I guess you can add a button in the output and handle the code for filtering there.

I dont think there are any FM's you can use to acheive this.

[Former Member]

Thank you for your Reply

Actually  i had made ME41 to ZME41 and in the CREATE RFQ: SELECTION LIST: PURCHASE REQUISITION report they need to have a FILTER FUNCTIONALITY , so i have added a Icon on tool bar, Now when i click on the icon(filter) i need the filter functionality.

[Former Member]

Hi,

Why use classical reports? I think you are working on the FI reports.

see this following link

http://www.insiderlearningnetwork.com/paulovigele/blog/2011/09/18/revamping_the_format_of_your_class...

Karthik.R

[Former Member]

Thank you for your Reply

Actually  i had made ME41 to ZME41 and in the CREATE RFQ: SELECTION LIST: PURCHASE REQUISITION report they need to have a FILTER FUNCTIONALITY , so i have added a Icon on tool bar, Now when i click on the icon(filter) i need the filter functionality.

[Former Member]

I think u have to hardcode it

[Former Member]

Thank you.

Do you have any code that when i Click on Button a Pop Screen with select-options will appear.

[Former Member]

Hi Abhinav,

You can use the FM POPUP_GET_VALUES to create dynamic selection options on fields you want.

So after the filter call that FM and when the user enters filter criteria, refresh the report by restricting the output table entries as per user input.

Hope this will be helpful.

Regards,

Karthik D

[Former Member]

Thank you for the Reply Mr.Karthik Dharmarajan

Can you explain me in Detail

Regard's

Abhinav. N

[Former Member]

Hi Abhinav,

On pressing the Filter button you should call the POPUP_GET_VALUES function module with all the report fields.

After the user enters the value for filter you can then use the same to delete the unwanted records from the list output internal table and re write the classical report using the filtered record.

Try this and let me know if it works.

Regards,

Karthik D

[Former Member]

Thank you

I Need a little help, when i click on the button The FM is executing, In this Fm when I press F4 i need to get the Values of the Internal table, and when i select one value and execute , the internal table should be Modified, can you send a Logic for this , tried in many ways but can not.

Regards

Abhinav N

[Former Member]

Thank you

I Need a little help, when i click on the button The FM is executing, In this Fm when I press F4 i need to get the Values of the Internal table, and when i select one value and execute , the internal table should be Modified, can you send a Logic for this , tried in many ways but can not.

Regards

Abhinav N

[Former Member]

Hi Abhinav,

Since the F4 help and other events are handled by the Popup function itself we can't do much in restricting the F4 help values.

In that case you need to create your own function module/screen to get the filter values of the report fields.

Regards,

Karthik D

[Former Member]

Thank You

Can You send any Sample code for this

Regards

Abhinav N

[Former Member]

To modify the data see this thread

http://scn.sap.com/thread/977448