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

Table maintenence generator

Former Member — Fri, 29 Feb 2008 12:43:57 GMT

Hi all,

Can u please tell me how to maintain a Table maintenance generator for Ztable.

Please tell me thesteps in detail.

Thanks in advance,

Sathyapriya.

Re: Table maintenence generator

Former Member — Fri, 29 Feb 2008 12:44:54 GMT

Hi,

Please search the forum before posting this type of question, this has been asked many times before.

Regards,

Nick

Re: Table maintenence generator

Former Member — Fri, 29 Feb 2008 12:52:42 GMT

hi,

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

Follow these steps :

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

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

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

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

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'

Hope this helps,

Regards,

Arunsri

Re: Table maintenence generator

Former Member — Fri, 29 Feb 2008 13:00:53 GMT

hi,

goto se14 and give table name and edit then press adjust

database.

then press yes.

regards,

sreelakshmi.

Re: Table maintenence generator

Former Member — Mon, 03 Mar 2008 06:27:40 GMT

Re: TABLE MAINTENANCE GENERATOR

Posted: Feb 11, 2008 10:42 AM in response to: siva kumar E-mail this message Reply

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.

Table Maintenance Generator is used to maintain the values of a table.Means we can add new records/entries and can even change the existing records.This is actually meant and easy for users.

We can also do this kind of activity through transaction SE16.But in realtime in Production environments, Users will not have access to SE16. So, through this table maintenance (transaction code:SM30) users can add or change the records in a table if there is a requirement to do so by getting proper approvals from their managers/management.

For example: A custom transaction is posting the invoice amounts to a GL account say 12345. For some reason the business want the amounts to be posted to a different account 12346.In this case, if we just change the GL account and save.From next time the invoice amounts will be posted to this GL account.So, there is no necessity to change any config or the code.

If you want to create table maintenance generator, please try like the following:

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

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

Re: Table maintenence generator

Former Member — Mon, 03 Mar 2008 06:28:59 GMT

Hi,

table maintanance Generator is used to manually

input values using transaction 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 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

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.

with regards,

sowjanyagosala.

Re: Table maintenence generator

Former Member — Mon, 03 Mar 2008 12:15:18 GMT

Thanks Madhavi