topic Re: table maintenance in Application Development and Automation Discussions

table maintenance

aris_hidalgo — Mon, 10 Apr 2006 13:20:27 GMT

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.

Re: table maintenance

RichHeilman — Mon, 10 Apr 2006 13:24:29 GMT

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

Re: table maintenance

Former Member — Mon, 10 Apr 2006 13:27:10 GMT

You need a maintainance view.

Re: table maintenance

aris_hidalgo — Mon, 10 Apr 2006 13:30:32 GMT

Hi,

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

Re: table maintenance

Former Member — Mon, 10 Apr 2006 13:31:28 GMT

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

Re: table maintenance

Former Member — Mon, 10 Apr 2006 13:32:29 GMT

SE11