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

table maintanance generator

Former Member — Thu, 13 Mar 2008 07:09:10 GMT

can u pls tell me what exactly the use of table maintanance generator ???

Help me on this

Points will be rewarded

Regsrds,

Rajan Mehta

Re: table maintanance generator

Former Member — Thu, 13 Mar 2008 07:11:43 GMT

Hi,

we can create database tables in SAP using transaction code

SE11. A table can be manipulated by a program or manually.

When creating table, you will find a check box 'Table maintenance allowed'. If we

check that option, we can manually enter entries using SE16 or table

maintenance generator screen.

SE16 is for data browser.

How to create table maintenance generator?

Go to SE11, give the table name and click on change. Then Go to utilities--> Table

maintenance generator.

In the table maintenance generator screen, we should give Authorization Group,

Function Group name (Function Group name can be same as table name),

Maintenance type can be one step or two step, usually we will create with one

step. we should give maintenance screen number. After clicking on create button,

a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.

We can view the table contents by choosing Display and we can create table

entries by choosing Maintain.

Why we have to go for Table maintenance generator, when we can edit the table

by SE16 or SE11, utilities->create entries?

Answer.

In the production system, end-users will not be having access to transaction

codes like SE11 and SE16. Developers will not be having access to many

transaction codes including the above two.

To view the contents of the database table, we will use SE16n in Production

system. Please find out the difference between SE16 and SE16n.

All these authorizations will be maintained by BASIS team, by creating access

profiles.

So in order to edit or create the contents of a database table, we should go for

table maintenance generator. In real time, authorizations will be maintained in

production system. (even in development and Test systems to some extent).

There is an audit like Sarbanes-Oxley Act for American clients, where every thing

will be audited by government agency. To know more about SOX, use the links on

the right hand side of this page.

The second reason is, we can edit or create multiple entries at a time, using table

maintenance generator.

Apart from that we have options like 'Enter conditions' in table maintenance

screen SM30. Please try to find out the use of those, by creating an example.

Table Maintenance generator: Difference between one step and two steps.

While creating table maintenance generator, we find below options:

1. When we choose one step, we have to give the screen number in Overview Screen field.

2. When we choose two step, we have to give both overview screen number and single screen number.

You can give any number for screen. Don’t give 1000 screen number. As this

number is reserved for selection screen.

When we choose 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 ‘new

entries’. 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 ‘new entries’, you can

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

We use single step generally, as it is user friendly.

To completely understand the difference and above points please do exercise by

creating table maintenance generator in both ways (using single step and two

step).

Re: table maintanance generator

Former Member — Thu, 13 Mar 2008 07:13:00 GMT

Hi,

Table Maintenance Generator (TMG) is a tool which is used to create a equipment by which customized tables created by end users can be changed as required,such as making an entry to that table,deleating an entry etc.

SM30 is the transaction code to create table maintenance generator.

Useful Link :

Please reward points if useful.

Regards

rose

Re: table maintanance generator

Former Member — Thu, 13 Mar 2008 07:13:40 GMT

Table Maintenance Generator is a tool which is into the ABAP Dic which allows you to generate a program which can be used to maintain entries in a table.

1)Can display the sy-uname when there is entry

2)Can create your own module for checking validation

Using table maintenance, U can operate Ur table like INSERT/DELETE...

In the conventional way, U have 2 go 2 SE11 --> Utilities --> Table Contents --> Create entries/Display.

Where as in production/Qty systems, no user can have authorization 2 access T-code SE11.

U have 2 create a table maintenance 2 Ur table, and assign a custom T-code 2 the table. then the authorized people only can access Ur T-code/Table entries.

Steps: 1) SE11, Utilities--> Table maintenance --> give a Authorization Group,

Function group, Package and one step/two step.

save and activate Ur table.

go 2 SE93, give a new T-code, create--> select Transaction with parameters(last radio button).

give Transaction as SM30. in the bottom default values , give the name of the screen field VIEWNAME and Value as Ur custom table.

Now Ur table is ready to access using the custom T-code

Refer thread

Hope this helps.

Regards

Vinayak

Re: table maintanance generator

Former Member — Thu, 13 Mar 2008 07:14:57 GMT

Table Maintenance Generator

The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator.

One step, two step in Table Maintenance Generator

This specifies the screens to be created in the Table Maintenance Program.

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

Re: table maintanance generator

Former Member — Thu, 13 Mar 2008 07:15:10 GMT

Hi,

Table Maintenance Generator (TMG) is a tool which is used to create a equipment by which customized tables created by end users can be changed as required,such as making an entry to that table,deleating an entry etc.

SM30 is the transaction code to create table maintenance generator.

Here you can update the table by running the t code

Most of system configuration tables are views

Regards

Shiva

Re: table maintanance generator

dhruv_shah3 — Thu, 13 Mar 2008 07:20:54 GMT

Hi,

Table maintanence generator is nothing but making a table available for adding records and deleting records.

The transaction code used is SM30.

follow below steps

1) go to se11 check table maintanance check box under

attributes tab

2) utilities-table maintanance Generator->

create function group and assign it under

function group input box.

also assign authorization group default &NC& .

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

using sm30 you can create entries manually.

check these links

[;

1. Maintenance type

It specifies when you insert the new record, dat to be filled for the new entry should come in same screen one step) or new screen should come for data entry(two step)

2. Maintenance Screen

this is screen which is displayed to user. you can edit the screen and set the attributes of screen as per your need.

e.g.-if you want one of fields as output only and in the pAI of screen you can populate the value>

3. Recording routine

recording routine is same as your delivery class of table.>

if recording routine is no or use it means 'A'-no transport request number is asked while saving the entries.>

if it is standard -'C'it means it will ask for transport request number

HTH

Regards,

Dhruv Shah