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

table maintenance generator

Former Member — Thu, 10 Jul 2008 05:53:24 GMT

HI Experts!

plz tell me while creating table maintenance generator , is it necessary to crate maintenance view . what I should write in table/view tabwhile creating table maintenance generator .

thanks.

Re: table maintenance generator

naveen_inuganti2 — Thu, 10 Jul 2008 05:57:43 GMT

Hi.....

Just write the Table name to which u r cretaing the table maintanace Genetaor!

And better to follow this procedure....

> 1. After activation of table... Click Utilities in menu bar and click on Table maintanance genartor

> 2. There it will auto matically proposes table name for Table/View field

> 3. Give authorization group some thing like &NC&

> 4. And give the existing Function group name from the Same Package

> 5. Click Onestep maintance type ( for single screen its mandatory)

> 6. Now click on propose screen numbers in Application tool bar and select first raido button in that.

> It wiil automatically fills the overview screen.

> 7. Finally Push the Create icon in the Appl' tool bar.

Thanks,

Naveen.I

Edited by: Naveen Inuganti on Jul 10, 2008 11:27 AM

Re: table maintenance generator

Former Member — Thu, 10 Jul 2008 08:08:22 GMT

Hi ranjna,

while creating table maintenance generator creation of maintenance view is necessary. In table/view

you just put the name of ur table and same name in the function group.

Then in maintenance screen you can put onestep(if u want to put all data in one time) or two step(if u want to put data one by one). and then generate it and save.

one more thing if u make any change in table after creation of ur TMG , in that case u have to delete that

TMG and again create that so that those changes u made , can reflect. othervise changes will not reflect.

I hope this information will help you.

reward if find this useful.

Regards

Saurabh asthana

Re: table maintenance generator

Former Member — Thu, 10 Jul 2008 08:14:17 GMT

Hi,

Table Maintenance generator is required to do Manual entries in the Table.

If the requirement is to update the table only programmatically

and not manually then table maint generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified )

using transaction SM 30, if the table maintenance for the table is generated.

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

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

Thanks,

Khushbu.

Re: table maintenance generator

Former Member — Tue, 29 Jul 2008 10:02:43 GMT

Hi,

Table Maintanance Generator is used to create/change/delete table entries in a particular table.

As all of us know, 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.

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.

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. Donu2019t 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 u2018new

entriesu2019. 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 u2018new entriesu2019, 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).

Reward Points if useful

Raghunath.S

9986076729

Re: table maintenance generator

Former Member — Tue, 29 Jul 2008 10:25:46 GMT

Hi ,

table maintenance generator is one of the important thing which we need to take care while creating the database table by using the 'TABLE MAINTENANCE ALLOWED ' check box

by doinG so we can edit or change the table entries in SE16.

While creating table maintenance we have two options

ONE STEP

TWO STEP

generally we use ONE STEP while cresting the table maintenance by using so we can edit multiple records at a time

For more details visit the below link

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

NOTE: REWARD IF YOU FIND USEFUL

Fareed

Re: table maintenance generator

Former Member — Tue, 29 Jul 2008 12:30:17 GMT

Hi Ranjna sharma,

When we create a table maintainance generator for updating the table automatically table maintianance view is created with the same name as table name.

Follwing is the link which explains you how to create a table maintainance generator.

http://saptechnical.com/Tutorials/ABAP/TableMaintenance/demo.htm

Thanks,

Naveen Kumar.

Re: table maintenance generator

Former Member — Fri, 08 Aug 2008 13:13:22 GMT

You would find the following links useful:

http://sapstore.blogspot.com/2006/11/table-maintenance-generator.html

http://www.allinterview.com/showanswers/28326.html

Regards,

Prashant.