topic Re: table maintainence in Application Development and Automation Discussions

table maintainence

Former Member — Wed, 09 May 2007 11:04:03 GMT

hi guys,

i am very much new to this table maintainence ....so i need a material which explains me step by step generator to create a table maintainence genarator..its pretty urgent........

thanks in advance

Re: table maintainence

Former Member — Wed, 09 May 2007 11:06:16 GMT

Hi Rajeev,

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.

Regards,

Priyanka.

Re: table maintainence

Former Member — Wed, 09 May 2007 11:21:44 GMT

Hi,

Send me ur email id. i will send docs to u.

Jogdand M B

Re: table maintainence

Former Member — Wed, 09 May 2007 11:36:42 GMT

hi jogdand,

here is my gmail id

raj.madhva1@gmail.com

and priyanka thanks alot for the answers-

Re: table maintainence

Former Member — Wed, 09 May 2007 14:09:33 GMT

Hi Rajeev,

Table Maintenance is meant for maintaining the consist data in database table of SAP. One can create a restrictive atmosphere using table maintenance generator and its tools so that only valid data can be inputted in the tables.

It gives a simple to use, table control for filling the values. The fixed values of domain appears as dropdown in the table maintenance.

The transaction for table maintenance is SM30.

One can directly create table maintenance from SE11, for a given table provided the table settings allowed to do so.

Prerequisite: In SE11, in Delivery & Maintenance tab of given table, it should be selected as maintenance allowed.

If this setting is available, following steps will help for creating table maintenance -

1. SE11 -> Give table name

2. Utilities menu -> Table maintenance Generator

3. Select the Authorization group as &NC&

4. Give a custom function group

5. Select one step radio button

6. Click on Find Scrn. Number button

7. Click on New

8. Save

=> Now got SM30, give the name of table. And click on Maintain.

=> For restricting the values to be entered in SM30, use transaction SE54. Here from menu Environment->Events, you can write your own code for validation of data.

Hope this sort out your issue.

PS If the answer solves your query, plz close the thread by rewarding each reply.

Regards

Re: table maintainence

former_member196280 — Thu, 10 May 2007 02:35:19 GMT

1. go to se11.

2. provide table name & press 'Change'.

3. ensure 'Table maintenance allowed' is checked

in the Attributes.

4. activate the table & go to Utilities->Table

Maint. Generator.

5. if u don't have any specific auth. groups,

provide &NC& for Authorizn Group.

6. Provide a Z-Function group name(preferably and

safely your own); if one does not exist & you want

to create a new z-func grp, provide that here in

table maint genr & it'll cerate & activate it for u.

7. come out, go to sm30 & type in your table name.

you can create new entries and display them.

Re: table maintainence

former_member196299 — Thu, 10 May 2007 03:47:33 GMT

hi ,

Below are the steps for table maintenance generator :

se11 -> utilities -> table maintenance generator (TMG). or SE55.

you need a function group to have TMG for a DB table. so u have a program always associated with TMG. once created u can maintain the table in tcode SM30.

procedure

1. go to se11

2. se11 -> utilities -> table maintenance generator (TMG). or SE55.

3. select authorization group. function group(must) and then click on PROPOSE SCREEN NUMBERS on application tool bar.

4. click on create button on application tool bar. dont worry about other things like recording routine etc.

reward if helpful !

Regards,

Ranjita

Re: table maintainence

Former Member — Fri, 11 May 2007 06:59:48 GMT

Hi Rajeev,

Sent file to ur email ID.

Regards,

Jogdand M B

Re: table maintainence

Former Member — Sun, 13 May 2007 06:46:02 GMT

hi rajeev,

first of all i would like to tell u wat is table maintainance?

whenwever we say table maintainance allowed in a table means we can add, delte, change data of that table.

Procedure:

1) goto transaction SE11 and create table.

2) while creating table select the option in attributes table maintainance allowed.

3) goto to utilities...click on table mainataince generator...

4) before that u will have to create function group..in SE37

5) once the function group is being created...now click on table mainataince generator...and enter the function group name which u have created..

6) once the table is created....goto transaction SM30 (Table maintainace)

7) now put the table name which u had created....and now u can insert new data...

change existing data....or delete also...

please reward pts in case usefull....

Regards,

Prashant