topic Re: if a table is modifiable in Application Development and Automation Discussions

if a table is modifiable

Former Member — Thu, 09 Dec 2010 15:59:31 GMT

Hi,

How can I find if a table is modifiable or not. We ahev a scenario where we need to run a program in our production that will update a standard table but out production is a non modifiable client, so I was just wondering how can I find if I will be able to update that table in production or not.

Thank you

Raj

Re: if a table is modifiable

Former Member — Thu, 09 Dec 2010 16:03:32 GMT

By what means you want to modify the DB table??

By codes it is any day possible to change the standard database table..

Mishra

Re: if a table is modifiable

Former Member — Thu, 09 Dec 2010 16:11:04 GMT

Hi Abhinab,

SAP has send us a program and that program is inserting some missing data in the standard table, and when you said that the code will do that ... so you meant that even if the system is set to be as non modifiable.

Re: if a table is modifiable

Former Member — Thu, 09 Dec 2010 16:15:37 GMT

production systems are always non modifiable( For developers ), be it for any org...

I am quite sure that with code we can update databases.

for eg using


Insert
Modify
etc

By the way if SAP is giving support with a correction then why you manually want to update tables??

Mishra

Re: if a table is modifiable

ThomasZloch — Thu, 09 Dec 2010 16:17:07 GMT

Direct table updates via ABAP programs do not check any system settings. That's why you need to be extra careful and never do this via your own programs.

Since SAP provided you the program, it sounds OK.

Thomas

Re: if a table is modifiable

Former Member — Thu, 09 Dec 2010 18:43:11 GMT

As far as I know, a system set to "non-modifiable" means that you can not make any changes to the system (so programs, dictionary objects etc.). Changes to database table content is not affected by this -> With such changes, you are not changing the system, you are changing database content - so that should be possibe, as long this is allowed for the table (delivery class of the table I guess).

Re: if a table is modifiable

Former Member — Tue, 28 Feb 2012 09:50:27 GMT

check this

http://wiki.sdn.sap.com/wiki/display/Community/ChangingTablevaluesonNon-modifiable+client.