topic Re: Database Table updated in Production server in Application Development and Automation Discussions

Database Table updated in Production server

Former Member — Tue, 03 Jun 2014 09:41:51 GMT

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

Re: Database Table updated in Production server

krishna_k19 — Tue, 03 Jun 2014 09:53:37 GMT

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

Re: Database Table updated in Production server

Former Member — Tue, 03 Jun 2014 10:44:15 GMT

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

Re: Database Table updated in Production server

kiran_k8 — Tue, 03 Jun 2014 10:47:19 GMT

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.

Re: Database Table updated in Production server

Former Member — Tue, 03 Jun 2014 10:50:20 GMT

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

Re: Database Table updated in Production server

krishna_k19 — Tue, 03 Jun 2014 10:51:24 GMT

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