topic Re: hi in Application Development and Automation Discussions

hi

Former Member — Wed, 21 May 2008 10:34:33 GMT

Hi all,

I need information on table maintainance generator.can any provide me.pls....

thanks

jagan

Re: hi

prasanth_kasturi — Wed, 21 May 2008 10:41:27 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.

You can maintain authorization groups for tables and views with the Generate table maintenance dialog maintenance transaction.

Tables or views are assigned to an authorization group during generation. Using the maintenance transaction you can maintain multiple assignments or delete assignments, if, for example, you want to combine several views or tables into a new group.

SM30 is the transaction code to create table maintenance generator.

To create 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 maintaience 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

check this link

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=tablemaintainancegenerator&adv=false&sortby=cm_rnd_rankvalue

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

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

/message/2831202#2831202 [original link is broken]

One step, two step in Table Maintenance Generator

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.

EVENTS:

http://help.sap.com/saphelp_nw70/helpdata/EN/91/ca9f0ea9d111d1a5690000e82deaaa/frameset.htm

how to implement events in TMG

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

regards

prasanth

Re: hi

Former Member — Wed, 21 May 2008 10:44:22 GMT

Hi Jagan,

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,

thanks

abdul

Re: hi

Former Member — Wed, 21 May 2008 10:53:19 GMT

Hi Jagan,

As all of you 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.

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 bcoz

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.

see this link u get lots of threads regarding table maintainance generator

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=tablemaintainancegenerator&adv=false&sortby=cm_rnd_rankvalue

thanks

karthik

Edited by: KARTHIK on May 21, 2008 12:53 PM

Re: hi

Former Member — Wed, 21 May 2008 11:16:23 GMT

HI Jagan...

Wel Come To SDN !!!

Hey one suggestion to you before posting any thread, just try to serach for your query.

I am sure, most of the time, you ll get what u want quite fast.

Just try for this query.

Hope u didnt mind it.

Thanks & Regards

vinsee

Re: hi

Former Member — Wed, 20 Aug 2008 22:32:24 GMT

The famous TMG question... what a give-away....