table maintenance generator.

[Former Member]

what is table maintenance generator?

how can u create it?what is purpose of it?

plzzzz send.

[Former Member]

Hi,

1)

table maintenance generator is used to automatically generate screens for maintaining the records for a table..

2)

Go to SE11

Give the table name..press change.

In the menu..UTILITIES -> TABLE MAINTENANCE GENERATOR.

Give the function group..->give the table name itself..

Press create button..

Now the TM is created..use the transaction SM30 to maintain data.

Thanks

Naren

[Former Member]

Check this link:

Regards,

Ravi

[Former Member]

table maintainence generator

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

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

[Former Member]

actually the TABLE MAINTANACE GENERATER.. IS used to select the 3 different criterias... as in u can select

1. DISPLAY/MAINTANANCE allowed with out ristrictions..

-

---

means once u try to execute the database table u can directly go to utilities --> from there u can select the option create entries or display entries.. in the sense u can create the entries for those table fields or can also view the records stored in the data base table u r currently into.

2. DISPLAY/MAINTANANCE allowed with ristrictions ....

-

---

this means u can just have the authorization to have a view of those records which r saved under that current table.. but u cannot create any new entries for that particular table..

3. DISPLAY/MAINTANANCE not allowed...

-

---

this means that u dont have authorization to either view the table contents( records saved in that current table) nor can create aby bew entries for that particular table

[Former Member]

To make entries in the table we use table maintenance view.. to create it we use table maintenance generator...

U can goto table maintenance generator by going to the table using

<b>SE11 -> Utilities -> Table Maintenance Generator</b>

Regards

Prax

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

With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

It can be set in transaction SE11 - Tools - Table maintenance generator.

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

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.

SM30 is used for table maintenance(addition or deletion of records),

For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

Sm30 is used to maintain the table ,i.e to delete ,insert or modify the field values and all..

It creates the maintenance screen for u for the aprticular table as the maintenance is not allowed for the table..

In the SE11 delivery and maintenance tab, keep the maintenance allowed..

Then come to the SM30 and then enter the table name and press maintain..,

Give the authorization group if necessary and give the function group and then select maintenance type as one step and give the screen numbers as system specified..

Then create,,,

Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

We use SM30 transaction for entering values into any DB table.

First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

Then it will create a View.

After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

For further help look into these links

<a href="http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm">http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm</a>

<a href="http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm">http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm</a>

<b>Pls do reward points.</b>

Regards,

Ameet

[jayanthi_jayaraman]

Hi,

You can use table maintenance to add new entries, change the exisitng entries,etc.,

In that, you can do some validations for a entry.

In SE11->change mode->

Utilities->Table Maintenance Generator.Create it by giving authorization,function group and screen.

Then click the create icon. Then the table maintenance will be generated.

Click Fn.gr.text button.Choose Main Program button.Uncomment the last two PBO and PAI includes. Write the validations there.