topic Re: Lookup Table/Screen in Application Development and Automation Discussions

Lookup Table/Screen

Former Member — Tue, 11 Mar 2008 14:03:51 GMT

How do everyone,

I have created a customised table to hold details relating to cost centres. There are only

three columns for each row held on the table. Rather than having to use SM30 to maintain

the data I was hoping to write a new transaction so that the user could maintain their own

data without the need for transports.

Is there a quick and easy way of creating a new screen to maintain the data. Very much in

the way you can with Microsoft access for instance??

Many thanks

Andy

Re: Lookup Table/Screen

Former Member — Tue, 11 Mar 2008 14:12:11 GMT

HI,

try using Function VIEW_MAINTENANCE_CALL in which you can choice what the user is able to do calling SM30, put this into a custom program linked to your custom transaction.

Re: Lookup Table/Screen

gabriel_braun — Tue, 11 Mar 2008 14:19:23 GMT

Hello Andy,

You can define a Parameter Transaction with SE93.

In the Create Transaction Screen select Transaction with parameters.

In the Screen Create Parameter Transaction enter SM30 in the field Transaction and check the checkbox Skip initial screen.

In the Table Default values enter VIEWNAME in the column Name of screen field and the name of the table that you want to maintain in the column Value.

In the second line of th table enter UPDATE in the column Name of screen field and an X in the column Value.

Then save the new transaction code.

Good luck