topic Re: update sap standard table in Application Development and Automation Discussions

update sap standard table

former_member841898 — Wed, 19 Mar 2008 08:01:42 GMT

hi experts,

is it a good practice to update a sap delivered

table directly using abap keyword update , i.e

without using bdc or bapi?

IF yes then why & if not then why?

regards

pankaj

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:03:07 GMT

Hi,

Use UPDATE keyword to update customized Ztables.

For standard tables, use bdc/bapi.

reward if helpful.

Regards,

Ramya

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:05:06 GMT

generally not...

the reason being that most of sap transactions do not just update a single table. There is a whole set of a tables that might get updated when you run a transaction or a bapi in SAP. If your program logic can take this into account and provide the same consistency of data then sure...you can update the tables the way u want.

However, having said that, it really depends on what your requirement is and how critical is your update. For example, you could go with updates on master data through your programs. So it depends on the kind of update your program is doing and also the table which is being updated.

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:05:42 GMT

If you custom/ Z table table it would be better to use insert modify or update

if you updating master / SAP standard table then it is recommended to use BDC BAPI or FM so that all the related tables should updated

regards

Shiva

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:08:22 GMT

Its definitely not advisable to update SAP standard tables using UPDATE statement directly in your Z-program.

SAP is not recommending the direct update because:

1. Authorization checks are not supported by the UPDATE statement. You must include these in the program yourself.

In the UPDATE <tablename> will not support the authority check.

2. You have to use SAP Locking mechanism before the UPDATE.

3. A SAP transaction updates not just 1 or 2 DB tables. So direct update might

result in DB inconsistencies. So its not highly recommended.

Hope this helps.

Thanks,

Balaji

Re: update sap standard table

former_member841898 — Wed, 19 Mar 2008 08:12:23 GMT

hi priyank,

thanks for your advice , but is it possible to mention in programs all the sap delivered tables to be updated............

a single update can reflect in 100 tables(guess)......

regards

pankaj

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:12:48 GMT

Hi Punkaj,

It is not good practice to update standard tables. In SAP all tables will be linked with many tables. We ll have related data stored in multiple tables. If we change one record in one table, remaining related will not be changed. If we use BDC (screen flow like va01) or BAPI, all the related tables will be updated.

Regards,

Subbu

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:16:53 GMT

I don't understand what you mean by :

"a single update can reflect in 100 tables"

If you are asking a way to know which tables does a program updates then yes there is definitely a way to know this.

SQL trace comes to your help here. you can activate the SQL trace through transaction ST05, thereafter run your program. Once the execution is finished, deactivate the sql trace and analyze it. You will get to see a hell lot of things that the program has done on the database level. Here you can make out which are the tables updated by the program.

Does that help? Is that what you were looking for???

Re: update sap standard table

former_member841898 — Wed, 19 Mar 2008 08:26:18 GMT

hi priyank,

yes thru sql trace i will get all the table names,......

but i think bdc or bapi will be better as data integrity will be maintained..............thanks

regards

pankaj

Re: update sap standard table

Former Member — Wed, 19 Mar 2008 08:30:37 GMT

Indeed!!

If you are convinced with the answers, then please close the post.