Table maintanence generator

Former Member — Fri, 08 Feb 2008 14:02:57 GMT

Hi,

What is Table maintenance generator and what is the use of it

Re: Table maintanence generator

Former Member — Fri, 08 Feb 2008 14:04:17 GMT

Create a maintenance view for the table in order to maintain the

table.

Re: Table maintanence generator

Former Member — Fri, 08 Feb 2008 14:04:22 GMT

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 maintanence generator

RaymondGiuseppi — Fri, 08 Feb 2008 14:07:32 GMT

This tool generate a program (in fact function module) to maintain a table through dialog.

This is most useful for small table, e.g.. Customizing table, as it can generate transport requests.

It is not suitable for biggest table, as it locks by default the whole table (one user at a time...) and load the whole table into memory. (Except if you encapsulate the generated function module in a program that manage selections)

Look at [Creating Maintenance Views|http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21ed2d446011d189700000e8322d00/frameset.htm]

Regards

Re: Table maintanence generator

JozsefSzikszai — Fri, 08 Feb 2008 14:16:50 GMT

10 points to Sunil Kumar...

(ann bolton is a userid created by Sunil Kumar, to assign points for himself. just check the other question of ann bolton , also answered by Sunil Kumar. there are some more userids also managed by Sunil Kumir to do the point hunting)

all these userids assign points only to Sunil Kumar:

Santosh behara https://www.sdn.sap.com/irj/sdn/profile?userid=3747543

chakri sappa https://www.sdn.sap.com/irj/sdn/profile?userid=3740084

Amren K https://www.sdn.sap.com/irj/sdn/profile?userid=3747443

Re: Table maintanence generator

Former Member — Mon, 30 Jun 2008 14:58:44 GMT

diff b/w sm30 and sm31?

wat is the purpose of table maintenance generator?

why we give authorization group as &NC& and function group name as table name and wat is the use of both AG & FG name

topic Table maintanence generator in Application Development and Automation Discussions

Table maintanence generator

Re: Table maintanence generator

Re: Table maintanence generator

Re: Table maintanence generator

Re: Table maintanence generator

Re: Table maintanence generator