topic Re: Table Maintenance in Application Development and Automation Discussions

Table Maintenance

Former Member — Thu, 13 Oct 2005 17:10:51 GMT

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

Re: Table Maintenance

RichHeilman — Thu, 13 Oct 2005 17:15:56 GMT

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

Regards,

Rich Heilman

Re: Table Maintenance

Former Member — Thu, 13 Oct 2005 17:20:43 GMT

Rich, Thanks for prompt reply

The customer field is KNA1-KUNNR and the description is KNA1-NAME1.

Re: Table Maintenance

RichHeilman — Thu, 13 Oct 2005 17:22:17 GMT

Right, so in your custom table, what are the fields. Is it just KUNNR. I hope you are not have NAME1 in this table also. What are the fields of the custom table.

Regards,

Rich Heilman

Re: Table Maintenance

Former Member — Thu, 13 Oct 2005 17:26:04 GMT

I have both the Customer and Description fields in the Custom table.

MANDT

KUNNR

NAME1

ZLAB....

The rest of the fields are custom ones .

Thanks Rich.

Rajesh.

Re: Table Maintenance

RichHeilman — Thu, 13 Oct 2005 17:31:31 GMT

Having the NAME1 field as part of your custom table is probably not a good idea. What happens when the customer master is changed and the name changes. Are you going to have a program which will sync up the customer names in KNA1 and your custom table. I would highly suggest not haveing the NAME1 field in your custom table. Just have the key(the customer number) KUNNR and the custom values. Always get the description from KNA1.

Regards,

Rich Heilman

Re: Table Maintenance

Former Member — Thu, 13 Oct 2005 17:35:31 GMT

Rich,

Thats a good suggestion. But I need to have the description in the maintenance view. I am not sure, if I can have the description in the maintenance view (SM30), with out having it in the actual Z Table. If this can be done, I would definitely remove the description from the Table, as it is not mandatory.

Thanks,

Rajesh.

Re: Table Maintenance

RichHeilman — Thu, 13 Oct 2005 17:59:07 GMT

Do you think writing your own table maintenance program is a possibility? Instead of using the table maintenance generator?

Regards,

Rich Heilman

Re: Table Maintenance

Former Member — Thu, 13 Oct 2005 18:05:57 GMT

Hi Rajesh,

In SE11, go to your maintenance view definition and KNA1 as the secondary table for your Z table (if you have defined the foreign key for customer field in your Z table then KNA1 will appear in Relationships section).

Then go to Table Fields, add KNA1-NAME1 and mark it as Read only (enter R in the 4th column titled "P").

Hope this helps..

And please remove NAME1 from your Z table..

Sri

Message was edited by: Srikanth Pinnamaneni

Re: Table Maintenance

Former Member — Thu, 13 Oct 2005 18:34:07 GMT

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