03-03-2006 9:15 AM
Hi all,
Can u plz give me the broad infomation about tablemaintenance(se11).
Thanks in advance
ravi
03-03-2006 9:40 AM
Hi,
Thanks for u reply, but i need information regarding
maintenance ,Transport and customization in sm30.
can anyone explain me how the work ?
Thanks& Regards
ravi
03-03-2006 9:22 AM
Hi,
Check this SAP Help...
http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm
Regards
vijay
03-03-2006 9:27 AM
03-03-2006 9:30 AM
check the link below regarding table maintenance
http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm
03-03-2006 9:35 AM
Hi
Use SM30 and SE56
Before that u have to creat table.
regards
vinod
03-03-2006 9:40 AM
Hi,
Thanks for u reply, but i need information regarding
maintenance ,Transport and customization in sm30.
can anyone explain me how the work ?
Thanks& Regards
ravi
03-03-2006 9:46 AM
Although your question is rather vague, some details:
- For any Transparent table you can generate a table maintenance module from transaction SE11 (or directly using transaction SE54).
- One of the options is the recording routine. If set to standard any change to the table contents will be recorded in a Customizing request. So entries can be transported accross the system landscape.
Any specific questions?
Regards,
John.
03-03-2006 9:49 AM
check this site..this site has all the details for ur query..
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecdf446011d189700000e8322d00/content.htm
<b>Create Parameter transaction for SM30</b>
Assuming that you want the user to maintain a table or view using SM30 but you do not want them to see the initial screen of SM30. For e.g. V023 - Material Group.
Steps tested in 4.6x :-
SE93 - Type in a transaction name e.g. ZV023
Click create - choose parameter transaction
In the Create Parameter transaction screen, fill in the following fields :-
Transaction SM30
Tick Skip initial screen
Tick Inherit GUI attributes
Name of screen field Value
VIEWNAME V023
UPDATE X
Press F8 or click the Test button for testing.
Save it and with the required authorization, the user will be able to use transaction code ZV023 to maintain the material group.
Message was edited by: Ashok Kumar Prithiviraj
03-03-2006 9:56 AM
Hi,
Go to table maintenacnce-> Environment-> Modification-> Events.
(only if u have further acess...)
u can create a form for several events like:
- before saving an entry
- after saving an entry
- before deleting an entry
- before creating an entry
This will help you to do customization in SM30.
Hope this helps you.
Check out this weblog on table maintenance:
/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance
Best Regards,
Anjali
03-03-2006 9:48 AM
SM30 uses the maintenance view you create, it does not create it. You have to create maintenance view by following the path in SE11>Change>Utilities-->Table Maintenance Generator.
Alternatively, you can also use SE54. Enter your table name and then select 'Generated Objects' radiobutton, press 'create'.
in table maintenance dialog generated for the table in sm30, click on transport and than you'll be able to select the rows you want to transport.
03-03-2006 9:49 AM
Hi Ravi,
You can check with TCode SM30
If the data in the table should only be maintained with programs or with the table view maintenance transaction (Transaction SM30), you should not set the flag.
Enter a name for the table field in the column Fields. The field name may only contain letters, digits and underlining, and it must begin with a letter. A field name may not be longer than 16 characters
03-03-2006 12:49 PM
03-03-2006 10:06 AM
Hi ,
Table maintainence view can be created using se11(give the table name)->utilities->table maintainence genrator->create.Through this you can maintain the data into the table using SM30.
When you specify the Delivery class in the atributes of the table as C (Customizing table) then what ever data you maintain using SM30 it will ask for a Transaport request as it is a customizing request => client dependent.
If you want the data to be moved to the other system then you need to move this TR as well.
When you specify any other delivery class while maintaining the table it does not ask for a TR .
And these entries will not be moved to the other system.
You have to maintain the same in the other system as well.
Regards,
Sriranjani Chimakurthy.
03-03-2006 10:18 AM
hi,
You can create table maintainance in transaction SE11.
Go to Utilities -> Table Maintainance Generator.
Once the table maintainance is generated, you can assign a Z transaction code to it via SE93, or you can use SM30 to use this maintainance view.
The maintainance is nothing but a set of function modules under a specified function group.
You can modify this function module as per your requirement.
Regarding transports, it will transported normally and no special configuration is required.
Hope this helps...
Regards,
Shashank
03-03-2006 10:53 AM
Hi Ravicharan,
Please find the information on your queries regarding table maintenance:
Table Maintenance:
If you create a table maintenance generator for a table, user is allowed to maintain the entries in the table therough transaction SM30. User can go to transaction SM30 and add, change or delete entries from the table.
Transport:
While creating a table maintenance generator, for "Recording routine" if you choose "no, or, recording routine" then user can't transport the table data through SM30.
If you choose "Recording routine" as "Standard recording routine" then user can transport the table data through SM30.
Customizing:
For standard customizing tables, if no data exists after initial set up then Functional Consultant or user can add the data in the standard table through SM30 by clicking on Customizing button. It will take you to transaction SPRO where the data for that table can be maintain.
Hope it helps.
Regards,
Neeraj Gupta
03-03-2006 10:55 AM
se11, u can create a table, and also can create any dictionary object like views, search helps etc.
se14: data base utility( u can update and adjust tables),maintain tables,views etc
se16: u can create and see only tables
sm30: u can maintain tables , update multiple tables thru maintainace view here.
se52: table maintenance generator. here we can create an interface to maintain tables
03-03-2006 1:30 PM
Hi Hyma,
Thanks for u r reply.
Using se16 we can create table entries but we can't create table .
Here my question is what is table maintenance ? why and where we come across this type of situation ?
please clarify my doubt.
Thanks & Regards
ravi