table maintenance

[aris_hidalgo]

Hello experts,

I was recently asked by my boss to create a table. The name of the table is zts_lgort. Now, I know the basic stuff like putting fields and it and activating it. My problem is, he wants it to be maintained via transaction SM30 so the users can add data to it. And also, when a user enters data in the column storage_location, the description column will automatically get data BASED on what the user inputted in the storage_location column. So for example, I typed in 5080 in the storage_location column, the description column will have a value that it will get in table t001L table. How do I do this guys? thanks so much!

(the table will contain fields namely mandt, plant, storage_location and description.

[RichHeilman]

I don't think that it is a good idea to store the storage location description in to different tables.

Just my opinion.

Regards,

Rich Heilman

[Former Member]

You need a maintainance view.

[aris_hidalgo]

Hi,

What is maintenance view? where do I go?thanks a lot!

[Former Member]

Please close this post

You have two posts with the same question:

Here I've just explained how to create a maintenace view by trx SE11

Max

[Former Member]

SE11