Skip to Content

Database Table updated in Production server

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jun 03, 2014 at 10:47 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2014 at 10:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2014 at 09:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.