Skip to Content
author's profile photo Former Member
0
Former Member

Table Maintenance

Posted on Oct 13, 2005 at 05:10 PM 105 Views

Hi,

I have created a maintenance view for a custom table.

The table has customer and customer description fields. I would like to get the description automatically populated with I enter the customer number in SE30 and save the data.

I checked relevant topics in this forum, but could not implement the solutions. Could any one describe how to do this in detail, as I am a novice in this area.

I tried creating events, but I am not sure how I do this. When I select entry 01 and a mention Form Name, I get a dialog box asking me to select from a grounp of modules (strarting with L*****). And when I click on okay, with out selecting any module, I get a message -- 'Changes to program L**** forbidden by SAP'

Please advise.

Rajesh.

Message was edited by: Rajesh Yerragunta

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Rich Heilman
    Rich Heilman
    Posted on Oct 13, 2005 at 05:15 PM
    2

    Of course, you would have to hack the table maintenance program. Are you looking to get the description from KNA1?

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

    • Srinivas Adavi Former Member
      Oct 13, 2005 at 06:34 PM

      Here are the steps that you need to follow.

      Create your table without the NAME1 field in it. Don't forget to create the foreign key relationship for the field KUNNR with KNA1.

      Create a maintenance view. In the Tables column, enter your table name. Click the button below 'Relationships'. It will bring up a pop-up window with your table name and KNA1. Select the checkbox and press 'copy'. Now you will see both your table and KNA1.

      In the view fields tab, enter all your ztable fields and NAME1 field from KNA1 and select 'R' under the column 'P'. Save it and activate it.

      Next go to SE54, enter your view name, select 'Generated Objects' and press 'Create'. A pop-up will come to confirm. Once you create the maintenance dialogue, you can now go to SM30 and enter your maintenance view name there and maintain it. <b>Remember, you will not use your table name for maintenance, you will use this view instead.'</b>

      Srinivas

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.