Standard Layout, Filter option in a Table Control (Custom Module Pool)

[Former Member]

Hi All,

I have this typical requirement. There is already an existing custom module pool program which has a table control in it. The user additionally wants the sort, filter and layout options on top of it. It will work in the same way as it is in SE16 for ALV grid display. I had already taken care of the sort functionality

Please note that there is no OOPS concept being used in the development and the user is not willing to change the table control to ALV using custom control

Is there anyone who faced similar issue and having a solution to this?

Thanks in advance...

Regards,

Sourav

[Former Member]

Hi All,

I have this typical requirement. There is already an existing custom module pool program which has a table control in it. The user additionally wants the sort, filter and layout options on top of it. It will work in the same way as it is in SE16 for ALV grid display. I had already taken care of the sort functionality

Please note that there is no OOPS concept being used in the development and the user is not willing to change the table control to ALV using custom control

Is there anyone who faced similar issue and having a solution to this?

Thanks in advance...

Regards,

Sourav

[Former Member]

Hello friends,

I have used following two function modules to handle the filter option.

1. CEP_DOUBLE_ALV: You will get the pop up to select you filtering fields.

2. LVC_FILTER_DIALOG: Second pop up to select the filtering data for the fields selected.

But I am still struggling with the layout part (set layout, select layout, save layout). If anyone has any idea, please do share.

Regards,

Sourav

[Former Member]

Hi,

I'm facing problem in using following 2 function modules for filter option in table control.

CEP_DOUBLE_ALV : You will get the pop up to select you filtering fields.

LVC_FILTER_DIALOG : Second pop up to select the filtering data for the fields selected.

please give me sample code for this ...

Thanks in advance

[Former Member]

Hi Anjali,

Can you please let me know what is the problem with your code? You have to first populate the fields in the RIGHT table, the structure of RIGHT and LEFT tables should be same. This is for the first FM.

And once u get the fields in LEFT table, use those fields to populate your filter table and then use tthe next FM to get the filtering values.

Based on the filter table, populate range tables for each field and use them in DELETE statement.

Let me know if this works.

Sourav

[Former Member]

Hi Sourav,

I have tried to use the first FM i.e. CEP_DOUBLE_ALV but how do we populate fields in T_LEFTX & T_RIGHTX .. do we have to manually add or the fields cause there is no struture available so that we can pass on the fields .

[Former Member]

yes you will have to manually populate each field in the left table only, right table will be populated in runtime when user selects some fields from left..

[Former Member]

Hi Geetjanjali,

Please provide the code if you have with you. I also have the similar requirement.

[Former Member]

Hi Sourav,

Have you used any PF-status in the program if yes means then in that give for filter &ILT its a standard thing and it will work accordingly and for sort &ODN and &OUP it will work for ascending and descending.

[Former Member]

Hi Suresh,

Even if I include these statuses in my PF status, it will come as an icon in the application toolbar. But we have to write the background logic to get the layout pop-up and all.

Hope you understand.

Thanks

Sourav

[Former Member]

Hi Sourav,

Were you also able to add the Layout Management functionality to your table control? I also have the same requirements as yours. Please let me know. Thanks in advance.

Joyreen

[Former Member]

Hi

I am sorry, I didn't get the question. What do you mean by Layout management functionality??

I have added the layout fucntionalities like change, select and save layout...

If you require the same please let me know.

Thanks

Sourav

[Former Member]

Hi Sourav,

Yes! That is what I meant. Can you please tell me how to do that?

Also, how were you able to add the filter functionality, when the function modules for Filter (example LVC_FILTER_DIALOG), require ALV-related inputs? May I also know what parameters you have populated for this? Thank you so much!

If you want, please answer my post instead, so you can have points for your answers:

Again, thank you for your response in advance.

Regards,

Joyreen

[Former Member]

Hi

Sorry for being late. I had already posted for the filter criteria in your post. Please excuse me if you have already resolved this issue.

[Former Member]

Hi Joyreen,

i have a similar requirement. i tried working on sourav's suggestion but the FM LVC_FILTER_DIALOG does not popup the dialog for filter, may be i m missing sum paramters

can u please post the code ?

Thanks

[Former Member]

Hi Saurav,

Please provide the code if you have with you. I also have the similar requirement.