topic Re: table data entry confusion in Application Development and Automation Discussions

table data entry confusion

Former Member — Thu, 29 Apr 2010 16:19:00 GMT

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

Re: table data entry confusion

former_member206439 — Thu, 29 Apr 2010 16:26:09 GMT

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

Re: table data entry confusion

Former Member — Thu, 29 Apr 2010 16:36:51 GMT

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?

Re: table data entry confusion

Former Member — Thu, 29 Apr 2010 16:43:23 GMT

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

Re: table data entry confusion

Former Member — Thu, 29 Apr 2010 16:57:49 GMT

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

Re: table data entry confusion

former_member206439 — Thu, 29 Apr 2010 18:10:18 GMT

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

Re: table data entry confusion

Former Member — Fri, 30 Apr 2010 18:55:54 GMT

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

Re: table data entry confusion

Former Member — Sat, 01 May 2010 04:58:13 GMT

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