This website is not affiliated with, sponsored by, or approved by SAP AG.

Direct Table Update

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Direct Table Update

Postby Guest » Wed May 28, 2003 2:56 am

Hi

Understand that SAP is not recommending for direct table update. Anyone knows about any white papers, where SAP documented this as a non-permitted activity.

Appreciate an early response.

Thanks

SAPFAN
Guest
 

Postby Rich » Wed May 28, 2003 3:12 am

Nope, but you risk losing database integrity if you update SAP tables directly.

It's not a course that I would take.

Rich
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com
Rich
 
Posts: 7112
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool

Postby Guest » Wed May 28, 2003 4:00 am

Hi,

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. Changes to lines made with the UPDATE command only become final after a database commit. Prior to this, any database update can be canceled by a database rollback

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

I am much sure how the UPDATE work with pooled and cluster tables related to primary key fields


aRs
Chennai-India
Guest
 

Postby Rich » Wed May 28, 2003 6:14 am

And as I said before you cannot guarentee database integrity......

Rich
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com
Rich
 
Posts: 7112
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool

And...

Postby Dr Sidewalk » Wed May 28, 2003 6:50 am

And, you can not guarentee having a job after such a change either.

I know that in my previous company anyone caught doing such a thing would be instantly dismissed.

Dr Sidewalk
"In the middle of difficulty lies opportunity" - Albert Einstein
"Money isn't everything in life, unless you don't have it"
"Fail to plan, plan to fail"
"Success is a journey, not a destination."
Dr Sidewalk
 
Posts: 3531
Joined: Mon Oct 21, 2002 11:06 am
Location: Everywhere...

Postby MattG » Wed May 28, 2003 7:52 am

Just a little thing; But generally if SAP found out that you directly updated SAP tables then they will not support your instalation.
MattG.
Image Search SAPfans
MattG
 
Posts: 809
Joined: Wed Oct 23, 2002 2:06 pm
Location: England

Postby Sharad Agrawal » Wed May 28, 2003 8:10 am

When you update the tables directly, then

1. You may miss some of the edit checks . There are various places where edit checks occur ( e.g. screen logic, update logic etc) when you post data using SAP transaction.

2. You may miss some of the tables which should also be updated along with the main tables ( for example SIS, LIS tables )

3. You may miss the audit trail. Some transactions will trigger creation of change documents ( etc), change pointers, Business transaction event etc

4. You may forget to propagate the data to another module which happens normally when you use SAP transaction for example SD -->FI/GL-->FI/CO

and lots of things.......
Sharad Agrawal
 

Postby Guest » Wed May 28, 2003 10:03 am

if you update tables directly you will loose the following:

- data integrity. SAP tranastions never update just one table - usually 20 -100 tables!

- you will almost certainly loose your support agreement with SAP

- you will loose your job, and you may find it very hard to find another...

- your business will loose its data integrity

simply forget it as an option for updating sap provided tables. Use BAPI's BDC(if you must :( yuk) or other means but really, don't do it

RP
Guest
 

Mass Document update

Postby Trigger Happy » Thu May 29, 2003 6:14 am

I need to update all the documents in a live system with a field value and as posted here I will need to hit all tables that hold the field but of course I do not know them all and do not wan to use UPDATE. Is there a transaction to do this or is BAPI the route?

Thanks.
Trigger Happy
 

Postby Rich » Thu May 29, 2003 6:22 am

Use whatever transaction is used to change the document in a BDC. You could try a Bapi. What's the item you are trying to update ?

Rich
Regards

Rich

Image
Abap KC:http://www.richard-harper.me.uk/Kb
SFMDR:http://www.se37.com
Rich
 
Posts: 7112
Joined: Thu Oct 31, 2002 4:47 pm
Location: Liverpool

Postby Trigger Happy » Thu May 29, 2003 6:43 am

Thanks Rich,

They're all Finance docs which won't actually allow me to update the field in FB02 which makes alot of sense really. I just thought there may have have been a SAP std transaction for a mass document update like this. But obviously this is not a change that can be done without trouble!

Another eg of avoiding UPDATE wherever possible.

TH
Trigger Happy
 

Postby MikeM » Thu May 29, 2003 7:15 am

If you are in a new enough version, there is Mass Maintenance functionality. Transaction code is MASS.
MikeM
 

Postby Guest » Thu May 29, 2003 8:48 am

Unfortuantely you can't use MASS for FI documents
Guest
 


Return to ABAP

Who is online

Users browsing this forum: No registered users and 12 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.