topic Re: table maintenance in Application Development and Automation Discussions

table maintenance

Former Member — Fri, 03 Mar 2006 09:15:34 GMT

Hi all,

Can u plz give me the broad infomation about tablemaintenance(se11).

Thanks in advance

ravi

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:22:13 GMT

Hi,

Check this SAP Help...

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

Regards

vijay

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:27:58 GMT

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:30:09 GMT

check the link below regarding table maintenance

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

Re: table maintenance

vinod_gunaware2 — Fri, 03 Mar 2006 09:35:52 GMT

Use SM30 and SE56

Before that u have to creat table.

regards

vinod

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:40:24 GMT

Hi,

Thanks for u reply, but i need information regarding

maintenance ,Transport and customization in sm30.

can anyone explain me how the work ?

Thanks& Regards

ravi

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:46:50 GMT

Although your question is rather vague, some details:

- For any Transparent table you can generate a table maintenance module from transaction SE11 (or directly using transaction SE54).

- One of the options is the recording routine. If set to standard any change to the table contents will be recorded in a Customizing request. So entries can be transported accross the system landscape.

Any specific questions?

Regards,

John.

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:48:02 GMT

SM30 uses the maintenance view you create, it does not create it. You have to create maintenance view by following the path in SE11~~>Change~~>Utilities-->Table Maintenance Generator.

Alternatively, you can also use SE54. Enter your table name and then select 'Generated Objects' radiobutton, press 'create'.

in table maintenance dialog generated for the table in sm30, click on transport and than you'll be able to select the rows you want to transport.

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:49:34 GMT

Hi Ravi,

You can check with TCode SM30

If the data in the table should only be maintained with programs or with the table view maintenance transaction (Transaction SM30), you should not set the flag.

Enter a name for the table field in the column Fields. The field name may only contain letters, digits and underlining, and it must begin with a letter. A field name may not be longer than 16 characters

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:49:49 GMT

check this site..this site has all the details for ur query..

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecdf446011d189700000e8322d00/content.htm

<b>Create Parameter transaction for SM30</b>

Assuming that you want the user to maintain a table or view using SM30 but you do not want them to see the initial screen of SM30. For e.g. V023 - Material Group.

Steps tested in 4.6x :-

SE93 - Type in a transaction name e.g. ZV023

Click create - choose parameter transaction

In the Create Parameter transaction screen, fill in the following fields :-

Transaction SM30

Tick Skip initial screen

Tick Inherit GUI attributes

Name of screen field Value

VIEWNAME V023

UPDATE X

Press F8 or click the Test button for testing.

Save it and with the required authorization, the user will be able to use transaction code ZV023 to maintain the material group.

Message was edited by: Ashok Kumar Prithiviraj

Re: table maintenance

Former Member — Fri, 03 Mar 2006 09:56:27 GMT

Hi,

Go to table maintenacnce-> Environment-> Modification-> Events.

(only if u have further acess...)

u can create a form for several events like:

- before saving an entry

- after saving an entry

- before deleting an entry

- before creating an entry

This will help you to do customization in SM30.

Hope this helps you.

Check out this weblog on table maintenance:

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Best Regards,

Anjali

Re: table maintenance

Former Member — Fri, 03 Mar 2006 10:06:37 GMT

Hi ,

Table maintainence view can be created using se11(give the table name)->utilities->table maintainence genrator->create.Through this you can maintain the data into the table using SM30.

When you specify the Delivery class in the atributes of the table as C (Customizing table) then what ever data you maintain using SM30 it will ask for a Transaport request as it is a customizing request => client dependent.

If you want the data to be moved to the other system then you need to move this TR as well.

When you specify any other delivery class while maintaining the table it does not ask for a TR .

And these entries will not be moved to the other system.

You have to maintain the same in the other system as well.

Regards,

Sriranjani Chimakurthy.

Re: table maintenance

Former Member — Fri, 03 Mar 2006 10:18:28 GMT

hi,

You can create table maintainance in transaction SE11.

Go to Utilities -> Table Maintainance Generator.

Once the table maintainance is generated, you can assign a Z transaction code to it via SE93, or you can use SM30 to use this maintainance view.

The maintainance is nothing but a set of function modules under a specified function group.

You can modify this function module as per your requirement.

Regarding transports, it will transported normally and no special configuration is required.

Hope this helps...

Regards,

Shashank

Re: table maintenance

Former Member — Fri, 03 Mar 2006 10:53:59 GMT

Hi Ravicharan,

Please find the information on your queries regarding table maintenance:

Table Maintenance:

If you create a table maintenance generator for a table, user is allowed to maintain the entries in the table therough transaction SM30. User can go to transaction SM30 and add, change or delete entries from the table.

Transport:

While creating a table maintenance generator, for "Recording routine" if you choose "no, or, recording routine" then user can't transport the table data through SM30.

If you choose "Recording routine" as "Standard recording routine" then user can transport the table data through SM30.

Customizing:

For standard customizing tables, if no data exists after initial set up then Functional Consultant or user can add the data in the standard table through SM30 by clicking on Customizing button. It will take you to transaction SPRO where the data for that table can be maintain.

Hope it helps.

Regards,

Neeraj Gupta

Re: table maintenance

hymavathi_oruganti — Fri, 03 Mar 2006 10:55:08 GMT

se11, u can create a table, and also can create any dictionary object like views, search helps etc.

se14: data base utility( u can update and adjust tables),maintain tables,views etc

se16: u can create and see only tables

sm30: u can maintain tables , update multiple tables thru maintainace view here.

se52: table maintenance generator. here we can create an interface to maintain tables

Re: table maintenance

Former Member — Fri, 03 Mar 2006 12:49:06 GMT

Hi buchaiah garu,

Thanks for reply

regards

charan

Re: table maintenance

Former Member — Fri, 03 Mar 2006 13:30:49 GMT

Hi Hyma,

Thanks for u r reply.

Using se16 we can create table entries but we can't create table .

Here my question is what is table maintenance ? why and where we come across this type of situation ?

please clarify my doubt.

Thanks & Regards

ravi