Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

manipulating table maintenance dialog

Former Member
0 Kudos
287

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.

4 REPLIES 4

0 Kudos
43

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

andreas_mann3
Active Contributor
0 Kudos
43

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

Former Member
0 Kudos
43

Problem solved . Thanks guys.

0 Kudos
43

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