Table maintenance

[Former Member]

Hi all,

Can anybody please provide knowledge of Table maintenance and how to do this in detail?

Thanks in Advance...

[abdulazeez12]

Hi,

It is used for updating tables.i.e deleting,updating and inserting data into tables.

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

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

Check these threads:

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

reward if helpful

[Former Member]

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

the maintenance view allows a user to easily enter values into a table, e.g. the administrator enters values into a customising table.

SE54 is the developer tool to generate / change the maintenance view, which is a set of function modules and screens.

SM30 is the user / administrator tool to use the maintenance view. It internally calls the generated function modules and screens, but those details are hidden from the user.

One advantage is that if you use the maintenance view to enter values into a customising table and press SAVE, you will automatically get a popup asking for a customising transport.

http://help.sap.com/saphelp_erp2005vp/helpdata/en/00/19f3055bb111d4a7600000e83dda02/frameset.htm

Thanks,

Reward If Helpful.

[Former Member]

Hi,

Check the following thread. U can easily do it.

Reward points if useful.

Regards

(YUGANDHAR.P)

[Former Member]

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 and sm50 is the transaction for table maintainance generator it is used to add multiple entries in to the data base throw sm54 we can create table maintainace generator and

some times ita is used for transporting also.

<b>and</b>

the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

>> Activate

Regards

Sudheer

[Former Member]

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

Regards,

Padmam.

[Former Member]

Hi Dhwani,

Use the following steps in order to create a maintenance view for your table using Table Maintenance generator.

1. First create the Z table in se11 with the required fields and activate the table.

2. Once the table is activated, you will have to create a Table Maintenence Generator, which will help you to enter values/records in the table easily.

3. You can create the table maintenance generator as follows:

a. In SE11, when your table is displayed, goto Utilities and then goto Table Maintenance generator.

b. Enter Authorization group as &NC&. Create a function group in SE37 (just a blank one...need not write anything) and activate it..use this function group here.

c. For Maintenece Screen, keep it as 2 step and press the 'Find screen numbers' button on top to automatically get the screen numbers. Save and activate. Now the table maintenece generator would be created.

4. Goto transaction SM30, enter the tablename and press Maintain. You can enter your required table values here.

This should solve your problem.

<b>PLZ REWARD POINTS IF HELPFUL.</b>

[Former Member]

hi,

step1: create a table using se11, then create fields in it.

step2: go for technical settings and select data class. APPL1. activate every time.

step3:go to utilities in menu bar , therein table maintenance generator, here specify function group as your program name. maintenance type - one step and overview screen 100.

then click on create button above. and save

table maintenance is used to be able to create entries in table. once maintenance is properly done

goto to utilities - table contents - create entries.

[Former Member]

HI

<b>Maintenance Views </b>

A maintenance view permits you to maintain the data of an application object together.

The maintenance status determines which accesses to the data of the underlying tables are possible with the maintenance view.

<b>Maintenance Status </b>

The maintenance status of a view controls whether data records can also be changed or inserted in the tables contained in the view.

The maintenance status can be defined as follows:

Read only: Data can only be read through the view.

Read, change, delete, insert: Data of the tables contained in the view can be

changed, deleted, and inserted through the view.

Read and change: Existing view entries can be changed. However, records

cannot be deleted or inserted.

Read and change (time-dependent views): Only entries whose non-time

dependent part of the key is the same as that of existing entries may be

inserted.

<b>STEPS TO CREAT MAINTANCE GENARATOR</b>

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.

<b>Reward If usefull</b>