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: 

Importance of table maintenance

Former Member
0 Kudos

Hi all,

What is the significance or importance od Table maintenance

how it is useful .

thanks in advance

1 ACCEPTED SOLUTION

Former Member
0 Kudos

like once u create a Z_ Table and want to create entries not by the user (manually)

then we go for table maintenance generator sm30 .

this allows to create the entires to the z-table directly.

this is nothing but a module pool interface which is generated for the z-table .

vijay.

7 REPLIES 7

Former Member
0 Kudos

like once u create a Z_ Table and want to create entries not by the user (manually)

then we go for table maintenance generator sm30 .

this allows to create the entires to the z-table directly.

this is nothing but a module pool interface which is generated for the z-table .

vijay.

Former Member
0 Kudos

Hi sai,

1. WHY Table Maintance ?

The MAIN purpose is to

allow ADD/EDIT/DELETE

of records in a TABLE.

2. Further to it,

thru table maintance generatro

and some extra work,

it is also possible to

use the events of it

and PUT SOME VALIDATIONS

while inserting / editing / deleting

the records.

3. The table maintance generator

uses the concept of function group

and AUTOMATICALLY GENERATES

THE SCREENS

BASED UPON THE FIELDS OF THAT TABLE.

regards,

amit m.

Former Member
0 Kudos

HI Sai ram

The extended table maintenance offers a convenient standard maintenance dialog for processing table contents,

which can be modified for use in applications.

The maintenance dialog can be used for table views as well as for pure tables in the Dictionary of type "C" (maintenance) or "H" (help).

The maintenance dialog has comprehensive user interface functionality,

which guarantees that maintenance procedures are comprehensible and transparent.

FOR MORE DETAILS ON TABLE MAINTENENCE VISIT:

-


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

CHEERS,

VIJAY RAHEJA

Former Member
0 Kudos

HI

THE TRANSACTION CODES SM30( or SM31) CAN BE USE TO DISPLAY OR UPDATE TABLE DATA. BEFORE YOU CAN USE THIS TRANSACTION A SPECIAL PROGRAM CALLED A <i>STANDARD MAINTENANCE DIALOG</i> MUST BE GENERATED FOR THAT TABLE.

THIS EXPLAINS THE IMPORTANCE OF TABLE MAINTENANCE GENERATOR.

HOW TO CREATE THE TABLE MAINTENANCE GENERATOR

Open SAP tables for direct maintenance

1 GO TO SE 11. ENTER THE TABLE NAME

2 GO TO UTILITIES - TABLE MAINTENANCE GENERATOR

3 GIVE AUTHERIZATION GROUP(&NC&)

4 GIVE FUNCTION GROUP and PACKAGE NAME

5 SELECT SCREEN NUMBER

6 SAVE

if it finds useful please reward points

REGARDS

ANOOP

0 Kudos

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.

abdul_hakim
Active Contributor
0 Kudos

Hi Ram,

As the name says that it is for maintaining the table but in a simple way ie,No need to go to se11 for maintaining the table entries.You can maintain thru SM30 or by creating your own transaction code..

Regards,

Abdul

jayanthi_jayaraman
Active Contributor
0 Kudos

Hi,

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.

Kindly reward points by clicking the star on the left of reply,if it helps.