Table maintenance generator

[Former Member]

Hi,

What is table maintenance and table maintenance generator.

How can we create this.

Can i get step by step procedure to create a Table main. generator.

Tnx

SAI

[Former Member]

We can use table maintenance for making the creation,deletion,changing the entries easily.

We can even make use of the validations required for some fields thro' table maintenance,while creating the entry.

If some fields need to be populated automatically while creating an record in a database,we can make use of table maintenance for this purpose.

When the extended table maintenance is called, a work area is fetched from the database into an internal buffer for processing on the screen. Either all entries in the database are fetched into the work area, or the selection can be restricted in a view definition or in the calling program.

Field contents are maintained in an internal buffer, so the database is not automatically accessed after each individual record has been maintaIned. Changes made are only copied from the internal buffer to the database when save is chosen. This buffering gives the maintenance procedure a transaction orientation. This gives you the possibility of discarding changes before the database access (user-controlled "rollback") and allows consistency checks for all changed data, before it is written to the database.

FOR MORE DETAILS ON TABLE MAINTENENCE VISIT:

-

---

http://help.sap.com/saphelp_erp2005/helpdata/en/69/c251474ba111d189750000e8322d00/frameset.htm

[Former Member]

hi,

by way of having table maintenance / maintenance view, u find it comfortable to make entries in a table, change or delete them.

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

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

[Former Member]

Hi,

Table maintainance generator is the screen where u can insert values to ur table.

Goto SE11-> create Z table activate it->GOTO utilities->table maintainace generator-> there u give function group name(Some new name startng with Z(also ur tablename)), Autho object as

&NC&(means no autho)->select single step->overscreen set 0->single screen give some num num(say123) save->goto sm30->give ur table name->click maintain->insert recrods and save.

Plz mark useful answers.

Regards

Divakar

[Former Member]

http://help.sap.com/saphelp_47x200/helpdata/en/a1/e45217a2f511d1a5630000e82deaaa/frameset.htm

[Former Member]

hi again,

when u press 'PROPOSE SCREEN NUMBERS' one pop-up comes and u choose automatic prposal of screen number by system.

[Former Member]

hi,

Check this out

Regards,

Santosh

[Former Member]

Hi,

table maintaince is used to enter create

entries in databse table manually through SM30.

se11-environment-table main generator.

check table maintainence.

create a function group using se80 and

assign while creating Table maintainence.

select standrad recording routine radio in table

table mainitainence generator to move table

contents to quality and production by assigning

to request.

Regards

Amole

[anversha_s]

hi sai,

chk this.

Hi,

Table Maintenance generator is required to do Manual entries in the Table. If the requirement is to update the table only programmatically and not manually then table maint. generator is not required.

Manual entries in table can be maintained ( New record can be inserted / existing can be modified ) using transaction SM 30, if the table maintenance for the table is generated.

How to activate Table maint.

Goto SE11 and open the table.

Click UTILITIES -> Table Maint. Generator, Enter the details and click on Save. Then activate the table.

chk a sample 1.

refer.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

rgds

anver

if helped mark points