topic Re: manipulating table maintenance dialog in Application Development and Automation Discussions

manipulating table maintenance dialog

Former Member — Thu, 17 Jun 2004 09:52:35 GMT

Hello again people.

Is there a possibility to manipulate the table maintenance dialog so that the fields displayed would be filtered? I have a database table which contains several fields, including <i>company code</i>. The only fields i want to display are those belonging to a specific company code.

I have an initial screen that passes the verified value of the company code to the table maintenance dialog. The plan is, once CALL TRANSACTION is used and the table maintenance opens, only those with the company code specified in the first screen would be displayed, while those with different company codes would just remain in the database table, but will not be displayed.

Hope my explanation is not too messed up. Thank you in advance.

Re: manipulating table maintenance dialog

tathagata_sengupta — Thu, 17 Jun 2004 10:16:34 GMT

Hi Vanessa,

One of the approaches could be:

1. Generate the table maintenance for your table.

2. Goto the function group you had specified in the table maintenance generator screen.

3. Display the screen which is for your table.

4. Add a module in the PAI to display the fields you want. Select the relevant fields here and carry on with the desired processing.

The above steps would help you to have your own screen to enter the company code. Next you can call the SM30 transaction from the code, skipping the first screen and this would allow you to display only those fields which you want to display.

Hope this helped.

Regards,

Tathagata

Re: manipulating table maintenance dialog

andreas_mann3 — Thu, 17 Jun 2004 10:56:00 GMT

Hi Vanessa,

perhaps it's possible to solve your problem with

the function VIEW_MAINTENANCE_CALL

example:

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

ACTION = 'S'

VIEW_NAME = 'YOUR_TABLE'

complex_selconds_used = 'X'

TABLES

dba_sellist = seltab.

append your filter-criteria to seltab ( Type VIMSELLIST )

Good speed!

Andreas

Re: manipulating table maintenance dialog

Former Member — Fri, 18 Jun 2004 02:06:54 GMT

Problem solved . Thanks guys.

Re: manipulating table maintenance dialog

Former Member — Fri, 18 Jun 2004 04:01:27 GMT

Hi Vanessa,

The best approach that I have seen, thus far is to start table maintenance with restrictions, there you might specify the condition like display only the rows that have company code 1000 and so on.

Please explore on that.

Regards,

Pavan