02-21-2006 7:19 AM
Hi all,
What is the significance or importance od Table maintenance
how it is useful .
thanks in advance
02-21-2006 7:26 AM
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.
02-21-2006 7:26 AM
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.
02-21-2006 7:32 AM
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.
02-21-2006 7:33 AM
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
02-21-2006 8:35 AM
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
02-21-2006 8:42 AM
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.
02-21-2006 8:39 AM
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
02-21-2006 9:13 AM
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.