Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table Maintanence Generator

Former Member
0 Kudos
138

Can some body give me the procedure step-by-step of how to create Table Maintanence Generator.

9 REPLIES 9

Former Member
0 Kudos
82

In se11 goto

1) Utilities

2) Table maintenance generator

3) Give the function group

4) Authorization group .

5) Maintenance type that is 1 . step or 2 . step .

6) Click on generate screen in the application tool bar .

7) Your screens will be generated .

😎 Click on create Select the required option , save and come back .

Regards,

Maha

former_member195698
Active Contributor
0 Kudos
82

Check the link

Former Member
0 Kudos
82

Hi Chidambar,

Below are the steps for table Maintenance

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

3) select standard recording routine radio in 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

Regards,

Satish

Former Member
0 Kudos
82

Hi,

1. Steps to create table maintainance generator.

1. Display the table then go to Utilities then select table maintanace generator give below parameters.

Table/View ZXXXXX

Authorization groups ZXXX

Authorization object S_TABU_DIS

Function group ZXXXXX

Development class ZXXXXXX

Maintenance type One-step

Main. screen no. Overview screen 3

Single screen 0

Recording routine no or user recording routine

Compare flag automatically adjustable

2. After passing the parameters click on create button on top left it will show the CTS press enter.

3. One Step:-

Only one maintenance screen is processed during extended table maintenance. The entries are displayed in list form on this screen.

Two Step:-

Two maintenance screens are processed during the extended table maintenance.

After copletion of table maintanence generator go to sm 30 t_code then pass the table name,Click on maintain button then click on new entries then insert the records then create transport request and save it and transport to quality.

Former Member
0 Kudos
82

Hi,

Table maintanance Generator is used to manually

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

Follow below steps

go to se11 check table maintanance check box under

attributes tab

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.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

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

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.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=...

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Former Member
0 Kudos
82

Dear Chidambar,

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.

Best Regards,

Raj

<b>Please reward points if helpful.</b>

Former Member
0 Kudos
82

Hi,

1) Go to SE11

2) In Delivery and Maintenance TAB

i) Delivery Class as A ( most of the times)

ii) Data Browser/Table View Maint. as "Display/Maintenance Allowed"

3) Enter the required fields.

4) Goto Technical Settings.Enter the appropriate data

5) Then go to Utilities-->Table Maintenance Generator

i) Enter the Authorization Group (Varies from project to project...when no authorization required give &NC& )

ii)Function Group as "Table Name"

iii)Package varies from project to project

iv)Maintenance Type as "One Step"

a)Give overview Screen Number (Your own number..but remember)

b)Single Screen "Any number"(it can be 0 also)

6) Then click on the white color create button on menu bar(Create)

7) To view the maintenance Screen Transaction is SM30(There you need to give the table name)

😎 If you want to change the description of the fields,alignment,mandatory,greying the fields,Validations and many more

goto SE51 enter program name as "SAPL(TABLE NAME) EX:SAPLZH116 and enter the screen number what you gave in the step 5,iv,a.

9)If u want to have a transaction to table maintenance

a)Go to SE93

b)Choose "Transaction with Parameters" Radio button

c)Give the Package Name which is given in 5,iii

d)Give transaction as SM30

e)Choose Skip Initial Screen

f)In GUI Support Choose all the three options

g) In the default values Tab

Name of the Screen Field Value

UPDATE X

VIEWNAME (Enter Table Name)

Regards,

Ari

Former Member
0 Kudos
82

Hi,

1. Steps to create table maintainance generator.

1. Display the table then go to Utilities then select table maintanace generator give below parameters.

Table/View ZXXXXX

Authorization groups ZXXX

Authorization object S_TABU_DIS

Function group ZXXXXX

Development class ZXXXXXX

Maintenance type One-step

Main. screen no. Overview screen 3

Single screen 0

Recording routine no or user recording routine

Compare flag automatically adjustable

2. After passing the parameters click on create button on top left it will show the CTS press enter.

3. One Step:-

Only one maintenance screen is processed during extended table maintenance. The entries are displayed in list form on this screen.

Two Step:-

Two maintenance screens are processed during the extended table maintenance.

After copletion of table maintanence generator go to sm 30 t_code then pass the table name,Click on maintain button then click on new entries then insert the records then create transport request and save it and transport to quality.

Reward points if it is useful....

Thanks & Regards,

Vasudeva Rao.

Former Member
0 Kudos
82

Hi

http://fuller.mit.edu/misc/creating_sm30_transaction.htm

check out this screenshots are provided how to do step by step

Hope this help u

Reward points if useful

Regards

Sreenivas