Database Table updated in Production server

[Former Member]

Hi,

I was told to create a transparent table that I could insert data into in Production server without having to create a request every time I want to write something into that table. Is that possible? If yes, what do I need to change about database table to allow for this? Does it have to do something with delivery class that I specify during the creation of the table?

Thank you,

Jake Alexander

[krishna_k19]

Hi Jake,

       If you want to update a table means we are having many procedures like BDC,...

On which basis you want to update the table.

are you updating the table when ever any transaction happen or what?

Can you give little bit explanation on the same.

Regards,

Krishna

[Former Member]

By updating, I mean inserting new entries into the table using SM30.

[krishna_k19]

if you want to made entries through SM30  means ,follow the below steps.

Display/Maintenance allowed in del.maintance tab

and maintain the table maintance generator.

Thanks & Regards,

Krishna

[kiran_k8]

Jake,

If this table is supposed to be maintained by the User manually then you can generate a table maintence generator as below

with delivery class as A

Data Browser/Table View Maint as Display and Maintenance Allowed

UTILITIES>>TABLE MAINTENANCE>>Dialog Data Transport details  as no,or user,recording routine.

This way the User will be able to maintain the entries in Production.

Table and the table maintenance attributes as explained above should be done in Development and then needs to be transported to Production.

You can get tons of info on Table Maintenance Generation in SCN.

K.Kiran.

[Former Member]

Hi Jake,

Yes, it is possible.  The key attibute to consider is in the Table Maintenance Generator settings, specifically 'Recording Routine' set to 'no, or user, recording routine'.

Regards,

Nick