topic Table Maintenance in Application Development and Automation Discussions

Table Maintenance

Former Member — Thu, 14 Aug 2008 13:54:28 GMT

Hi Experts,

How to maintain a table in SM30 .

Delivery class = C.

Data class = APPL2.

Display/maintenace allowed with restriction.

I have to make entries from SM30.

Thanks,

Ramotar.

HAPPY INDEPENDENCE DAY.

Re: Table Maintenance

matt — Thu, 14 Aug 2008 14:01:23 GMT

You need the Table Maintenance Generator - search these forums for more detail.

Re: Table Maintenance

former_member70391 — Thu, 14 Aug 2008 15:00:04 GMT

Hi Ramotar,

With allowed matenance with restriction I do not think it will allow you to maintain data via SM30. See the details below.

If the indicator is set to ' ', the respective view can be displayed, but not maintained with transaction SE16.

A maintenance dialog for this view can be generated using transaction SE54.

Transaction SM30 does not allow the maintenance and display of this view.

Note: The dialog generated can be included in view clusters (data maintenance with transaction SM34) or in a program using the function module View_Maintenance_Call.

Thanks & Regards,

Nagaraj Kalbavi

Re: Table Maintenance

Former Member — Thu, 14 Aug 2008 15:02:27 GMT

If you want to make an entry in the table, you can do it in SE11 also. Follow the below mantioned path

Utilities---> Table Contents -

> Create Entries

if you want to create entries using SM30.

goto SM30 and give your table name and then click maintain. Enter your entries and save it.

Re: Table Maintenance

Former Member — Mon, 18 Aug 2008 12:05:14 GMT

1.Change the Data Browser/Table View Maint. in delivery/maintainence tab to 'Display/maintainence Allowed'.

2.Activate table.

3.Goto Utilities-> Table maintainence generator

4.Enter Authorization group - &NC&

5.Give any function grp name eg: ZTAB

6.Select radio button 'one step' and give screen no as 9001

7. Create/F6

After creating you will be able to maintain this table in SM30

Regards

Sathar

Re: Table Maintenance

former_member585060 — Mon, 18 Aug 2008 12:56:44 GMT

Goto SM30, give the Table name and click on the button "Find Maintenance Dialog", if it has any maintanence entries it will give.

Re: Table Maintenance

Former Member — Mon, 18 Aug 2008 13:02:13 GMT

Hi Ramotar,

If u are giving Display/maintenace allowed with restriction in table view maintenance at the time of creation of table , in that case u won't be able to make entries through sm30. when u go to sm30 it gives error because u tried to call a maintenance dialog for the view/table , for which the table maintenance is only allowed with restrictions. You can only edit the data in the environment of another program or a view cluster.

If u want to make entries through sm30 then intially u should give Display/maintenace allowed . once u enter data through sm30 then u can change it to Display/maintenace allowed with restriction.

For creation of data in sm30 go to se11~~>utilites~~>table maintenance generator--> there u give table name

and function group name same as table name. Authorization group as u need, if u want w/o auth. then place & NC & . then choose either two step or one step according to ur choice. In two step two screens will be created for table maintenance. For single step only one screen will be created.

When we choose two step, table maintenance will work as follows Go to SM30, give the table name for which you have created table maintenance- Overview screen will be displayed. To create entries, when you click on u2018new entriesu2019. Another screen will be displayed, where you give input and save. You can

enter one record at a time.

When we choose single step, table maintenance will work as follows :

Go to SM30; give table name for which you have created table maintenance-

Overview screen will be displayed; To create entries click on u2018new entriesu2019, you can

enter the records on the same screen. You can enter multiple records at a time.

assign some no. to overview screen and single screen. Now press F6 for create. After successful generation save it. now go to sm30 and enter the data. and save it. now u can change table view maint.

to Display/maintenace allowed with restriction for further entries.

i hope this information will help u.

Regards

saurabh