topic Re: Regarding Table Maintenance in Application Development and Automation Discussions

Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 12:32:20 GMT

Hi All,

I have created a table maintenance 'ZBCER' for a ztable . But when I am maintaining the table using the transaction sm30 it is showing the message that

'The maintenance dialog for ZBCER is incomplete or not defined.

Please suggest what can be the problem.

Re: Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 12:39:08 GMT

Hi Rahul,

just create a view for ZBCER table.

while creation , u can specify the required fields.

after activation , u can insert values into ZBCER.

<b>steps </b>

1) run the se11 transaction

2) put ur own name for ur view(starting with Z or Y) and press create.

3)select Database View as view type

4)fill the mandatory fields like description

5)In the Table/Join condition tab fill the row with ZBCER table name

6)U can specify the required fields in the View Fields tab

7)Then in the Maint.Status tab .. , select "read and change" as access permission

8)Data Browser/Table View Main. select "X Display/Maintenance Allowed" from the dropdown

9)then just activate the view

Then u can insert new values in that table using this view.

Re: Regarding Table Maintenance

eddy_declercq — Mon, 22 Jan 2007 12:41:33 GMT

Hi,

All is well explained in

http://help.sap.com/saphelp_nw2004s/helpdata/en/a1/e45217a2f511d1a5630000e82deaaa/frameset.htm

and

http://help.sap.com/saphelp_nw2004s/helpdata/en/69/c2513a4ba111d189750000e8322d00/frameset.htm

Eddy

Pimp up the S(D)N site and earn points. Check this <a href="/people/eddy.declercq/blog/2007/02/01/pimp-up-the-jam log</a> for details

Re: Regarding Table Maintenance

RaymondGiuseppi — Mon, 22 Jan 2007 12:43:04 GMT

Use SE54 to create the maintenance dialog.

You may create a view to be used bny SM30/SE54 if you have some additional texts ot other informations linked to your table via external keys.

Regards

Re: Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 12:45:04 GMT

have u done this way...after u have created the table from SE11 and activated it...from menu goto table maintenance...and here u need to specify screen no as 0 & a function group which u need to create a relevant one and then generate the same and save...now from SM30 u can do the maintainence of the table.

Re: Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 12:52:48 GMT

Hi Ramesh,

I have done exactly as u r saying,

from menu , i gone to table maintenance and there i specified the screen as 1 and fiven the name of an existing function group,then saved the view but while saving it showed me message that no transportable packege is associated with ZBCER,

and when i tried to maintain the table through sm30 , it was giving message 'The maintenance dialog for ZBCER is incomplete or not defined

What can be the prob.?

Re: Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 12:57:56 GMT

mostly, in ur table maintenance u have not specified the developemnt class name...this needs to be given as such. also check in the table attributes which one u have selected...u need to select allow table maintenance as one of the option.

Re: Regarding Table Maintenance

RaymondGiuseppi — Mon, 22 Jan 2007 13:06:09 GMT

Your table is defined as local (non-transportable, dev class $TMP) and your function group seems to be transportable.

Change the entrie attached to your table in object directiry. (the same devt class that the FG group)

Regards.

Re: Regarding Table Maintenance

Former Member — Mon, 22 Jan 2007 13:16:05 GMT

My table is transportable and is in the same package as the function group is in ,

still it is giving the same message, and when i m trying to create the view it is giving the message 'The maintenance object description has no transportable packege'.

please suggest the prob.?

Thanks

Re: Regarding Table Maintenance

RaymondGiuseppi — Mon, 22 Jan 2007 13:22:02 GMT

Go to SE54, Generated Object, Crearte/Change

Below the line of the group function you should see its developpement class, It is the same class as that of the table or $TMP

Re: Regarding Table Maintenance

RaymondGiuseppi — Mon, 22 Jan 2007 13:29:31 GMT

Else in SE54 in "Display table maint.dialog generat.: Generation environment" screen (display of generated object) go to the menu : Environment, Maintenance object, display.

there click on Obj directory entry and change the development class ( R3TR TOBJ)