table data entry confusion

[Former Member]

hi gurus i have a ztable with multiple entries. i have to delete some entries and add many new entries. what will be the best possible way of doing it? will i edit it in the dev server thru tmg and transport it to the prod / or will i edit it in the prod server at one go thru tmg . pls help

[former_member206439]

Hi

Data modifications/ Maintenance can be done in sm30. Please get in touch with the technical resource to develope a table maintenece generator for z table and you can change data in sm30

If it is already there then you can chnage the data directly in production with table maintance genarator.

Thnaks

Naresh

Edited by: Naresh Nelapatla on Apr 29, 2010 6:26 PM

[Former Member]

thnx a ton for ur quick reply. i havent done anything with tables till date. so pls clarify my doubt

if we can directly edit the table entries thru sm30 (in prod server) then in which cases will we have to transport the table along with the data from dev server to prod server ? my pt is dat i have all the necessary data in the tables in production serverand i can edit it directly. so in which cases will we have to transport the ( table + data) from dev to prod?

[Former Member]

Hi,

As a basic rule;

If the table entries should be the same across all systems and they change infrequently - Transport

If the table entries need to be different between systems or they change frequenty - Enter direct in each system

The type if fields in the table should give you an idea which case you're in.

Regards,

Nick

[Former Member]

i got ur point stil it will kind of u if u elaborate a little bit. also tell me how will i do data entries in case if it is a text table

[former_member206439]

Hi.

If the table is related to maintaining some global constants then its always better to transport through development system.

If the table is created for customer data maintanance you can chnage the table in production directly useing SM30.

In our project also we have some custom tables where in one table we are maintaining global constant values which we are adding that values in development systenm and transporting it to production.

And there is one more table where we are mantaining all customer data which we are changing based on the customer request directly in production from SM30.

I think it may help you.

Thansk

Naresh

[Former Member]

thnx naresh for ur reply, can u pls tell me which table ur taking about (table containing global constants). and how to do data entry in text tables.any ideaz, plz share

[Former Member]

HI,

I go with the view of Nick.....

Also please refer to this link [Editing Table in SE16N|http://www.kowboyz.nl/blog/edit-sap-tables/].

Hope this helps.

Regards,

Abhijit G. Borkar