Table maintenance

[Former Member]

hi friends,

could u plz tell me how to create table maintenance has been generated for a specific database table ????

with regards,

Priya.S

[Former Member]

go to se55 Tcode..

give the name of the table..

in that give the authorization group &NC& ..

create a Z function Group ..

press on find screen numbers..

click on the pop-up 'Propose screen numbers'.

click on save..

this creates the maintenance screens in SM30

then

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

-

---

Name of the screen field | value

-

---

VIEWNAME | your ztable name

SHOW || X

Save your work.

Award points for helpful answers

[Former Member]

Hi

GOto t-code SE11

there one option called Utlities---->

tables mataince generator select this option

than it wiil take u another screen in that you shoild give the Authorazation group like &NC&

and give function group name like ZGROUP

Matainace type one step

last gove screen no 100

than activate it will wirk out.

<b>reward is usefull</b>

[Former Member]

Hi Priya,

Below are the steps and link clearing specifying steps for creating table maintenance for specific table.

Link---->http://fuller.mit.edu/SAPDocs/extended_table_maint2.htm

Please do reward if useful.

Thankx.

More on Extended Table Maintenance (SM30)

Creating... (SE54 - Generate table view)

If the table and the table maintenance dialog has been generated previously, there still might be necessary additional steps before a table is ready for end user maintenace.

Authorization Group

The authorization group can be set via transacation SE54. Select "Generated objects" and click on the "Create/change" soft button:

You will be able to set the authorization group at this point.

Add Client

We can't modify a cross-client table. In order to make the table client specific, MANDT must be added as part of the the unique key and it must be marked a NOT NULL field. After you add the field, the data must be converted:

Convert Data

SE11 -> Utilities -> Database utility (then click the edit soft button)

Activate and adjust database:

This should happen automatically when you transport the table.

Development class

You don't have to change the development class in order to prepare the table for end user maintenance, but it helpful if the development class reflects the actual system to which it belongs.

To change the development class of the table, from SE54:

Environment -> Maintenance objects -> change

You might get a warning that it is for display only. From here click on the soft button "Obj.directory entry":

From here you can click on the pencil/eye glasses soft button and change the Development class.

To change the development class of the table maintenance:

The authorization group can be set via transacation SE54. Select "Generated objects" and click on the "Create/change" soft button (see pic under Authorization group change above)

Environment -> Modifications -> Maintenance screens

From here Goto -> Attributes:

Which lands you:

From here Goto->Object directory entry

From here click on the pencil/eye glasses and you will be able to change the development class.

Create a transaction for your table:

Transporting finished work:

When transporting your work you might come across the following extended program check error. It is a harmless SAP error, nothing you caused in your changes:

[Former Member]

Hi,

Go to SE11 and click on GOTO and click on Table Maintenance Generator and click on create button and give the authorization group if you want else give it as &NC& and Function group. If you want the maintenance in one screen, check one screen and give the screen number else if you want the maintenance in two screens, then give the second screen number also.

Note: If you change the database table after creation of TMG, then once again you need to create the TMG, otherwise changes wont be implemented.

Goto SM30 and give the Table name and maintain entries.

Regards

Kannaiah