Table Maintenance

[Former Member]

Hi Friends,

Please suggest, can I create table maintenance for table USRM0.

[Former Member]

hi

Create a View based on USRM0 by SE11 and then the program for SM30 for the view and not for USRM0

Max

[Former Member]

Hi Max,

USRMO view is already there and thru. sm30 table maintenance for this view is not allowed.

Can we create table maintenance on sap tables. Please suggest.

Pankaj

[Former Member]

Hi

Create a table view ZUSM30 by SE11:

- Run SE11 and choose VIEW option;

- Insert the name of your view (for example USM30);

- Press Create and Choose Maintenance View type

- Insert all fields of USM30 you need to update

- generate the programm for maitenance

In this way you have an object custom to update a standard table.

Max

[Former Member]

Max,

I followed your steps (for a Z-table I created, not for USM30) and when I try to maintain it in SM30 the system tells me I need to create a maintenance dialog. I thought that was what your instructions created. How to proceed?

Thanks,

Geoff

[Former Member]

Hi Geoff,

1) Go to SE54 and enter your ztable name

2) Select "Generated objects" and click on Create/Change

3) Enter Authorization group and select maintenance type

as one screen or two screen

4) Click on "Find Scr. Number(s) and select "Propose

screen number(s) from the pop-up dialog box and

continue

5) Click on create and then a screen will exist for

table maintenance

Maintain it using SM30 ...

Hope this will work for you.

Regards,

Vivek

[Former Member]

Hi Pankaj,

YOu can create the same.

Inside the table Utilities->table main. generator->

mention auth(&NC&)/function groups(Create in SM37/Se80 and assign).

enter the man.screen numbers.

Click on create button.

then check in SM30 transaction code.

Regards

Eswar

[Former Member]

Hi,

There are two views already exists for USRM0 table. This to be done as part of configuration client.

V_USRM0_B User-Specific Industry Sector Setting

V_USRM0_R User-Specific Screen Reference

Its not advisable to create Maintenence screen for Standard SAP Tables.

Regards,

Ramki.