topic Re: table maintainence generator in Application Development and Automation Discussions

table maintainence generator

Former Member — Wed, 10 Oct 2007 08:29:36 GMT

how to maintain table mainteneance Generator for a table

Re: table maintainence generator

Former Member — Wed, 10 Oct 2007 08:31:33 GMT

hI,

Table maintenance is used to maintain entries in the table.

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

download document from

https://wwwn.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc

Thanks.

Re: table maintainence generator

former_member404244 — Wed, 10 Oct 2007 08:32:25 GMT

Hi,

Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

>> Activate

Reward if helpful.

Regards,

Nagaraj

Re: table maintainence generator

Former Member — Wed, 10 Oct 2007 08:35:30 GMT

Maintenance Genarators

A maintenance view permits you to maintain the data of an application object together.

The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

Maintenance Status

The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

The maintenance status can be defined as follows:

Read only: Data can only be read through the view.

Read, change, delete, insert: Data of the tables contained in the view can be

changed, deleted, and inserted through the view.

Read and change: Existing view entries can be changed. However, records

cannot be deleted or inserted.

Read and change (time-dependent views): Only entries whose non-time

dependent part of the key is the same as that of existing entries may be

inserted.

Restrictions for Maintenance

There are some restrictions for selecting the secondary tables of a maintenance view or help view. The secondary tables have to be in an N:1 dependency to the primary table or directly preceding secondary table. This ensures that there is at most one dependent record in each of the secondary tables for a data record in the primary table.

Table maintenance allows you to create entries for that table

Follow these steps to generate table maintenance

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

Reward if usefull

Re: table maintainence generator

Former Member — Wed, 10 Oct 2007 08:35:52 GMT

Table maintenance generator is used to create screen to maintain values in a table. Once you create maintenance generator, you can goto transaction SM30 and add data to table .

Check the following blog on table maintenance:

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

check the following link table maintenance:

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

*******************

from SE11 , enter the table name and then click on change, then in the menu Utilities->Table maintenance Generator.

give authorization group,Function Group, Sngle screen(radio Button),Mainitenance screen no, and Standard Recording Routine Radio Button ..

and save it.

and then Go to SM30 and check it with the same name.

******************

Here is an extension to table maintenance generator.

Generally for inserting new records into custom table thru transaction SM30, we need to enter all the values manually and save the record.

When certain data for the key fields needs to be populated automatically while creating entries, the steps involved are:

Maintaining the subroutine in view V_TVIMF for a particular custom table.

Logic for extracting relevant data for the fields entered, when user press enter button.

Check this blog for more information on extracting data in table maintenance.

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

Re: table maintainence generator

Former Member — Wed, 10 Oct 2007 08:38:59 GMT

Hi,

In the menu bar of ur D/b table, go to

Utilities-------> Table Maintenance generator,

then create the table maintenance generator,

give Authorisation group = &NC& if without authorisation.

create a Function group in SE80 and assign there in Function group field

then put Maintenance type = One step (if u want dispaly and modification in one screen),

then put Overview screen no. as any no.

then click on the Create button on the application tool bar.

In this way you can create Table maintenance generator.

Reward point if helpful.

Gud luck,

Bhawani

Re: table maintainence generator

Former Member — Wed, 10 Oct 2007 08:39:38 GMT

good

Table maintenance allows you to create entries for that table

Follow these steps to generate table maintenance

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table.

reward point if helpful.

thanks

mrutyun^

Re: table maintainence generator

varma_narayana — Wed, 10 Oct 2007 08:40:40 GMT

Hi...

Parameter Transaction can be created for Table Maintenance program of a Custom Table in SAP.

Steps:

1. Create a Z table and Activate - SE11

2. Generate the Table Maintenance using SE54

It will Generate the Function group and Screens.

3. Create a Parameter transaction to Call this Table maintenace program

Goto SE93.

Create a Tcode :

Name : ZTCODE1

Type : Parameter Transaction

In the Attributes of Parameter Transaction

Enter The Transaction SM30

Select the Checkbox : Skip first Screen

Enter the Following Fields below in the Table provide.

FieldName FieldValue

VIEWNAME <YOUR ZTABLE>

UPDATE X

Save the Parameter Transaction and execute it like ant other Tcode..

It will allow you to maintain the Table entries.

reward if Helpful.