Lookup Table/Screen

[Former Member]

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

[Former Member]

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.

[gabriel_braun]

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