topic Re: Table maintainance generator in Application Development and Automation Discussions

Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:05:25 GMT

Dear ABAP Experts, what is the utility for table mainantence generator??

Plz,,,provide me some example...

Thanks..

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:08:01 GMT

Hi,

Check the link below:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Regards,

Sharath

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:12:14 GMT

Tcode SE54

Entery Table Name

Select Generate Objects

Click Creat/Change

Enter relevant table maint data

Goto SE93

Create tcode with parameters for tcode access to table maintenance of this particular table

In transaction SE11, in the attribute tab of your z table check table maintenance check box.

Go to transaction SE93, give your own transaction code say ztran_tab, for maintaining your ztable.

Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

Scroll down you will find a table control for default values

Name of the screen field | value

VIEWNAME | your ztable name

SHOW | X

Save your work.

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:12:20 GMT

You create a table to maintain The Share price at the end of every month

You want user to maintain it.

Create table/view

Create table maintainace for it

User will be able to maintain it via SM30

Lot of config happens this way

All these links will help you to know more

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

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

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

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

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

Reward points if helpful

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:12:53 GMT

you go through this link.

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

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:14:18 GMT

Hi,

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.

Cheers

Sai

Re: Table maintainance generator

Former Member — Thu, 19 Jun 2008 16:16:55 GMT

hi check this....

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.

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?

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

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

Former Member — Sun, 22 Jun 2008 09:51:52 GMT

Thanks,

Regards,

Asha ..