RE: [sap-abap] Deleting records directly from a transparent table using custom ABAP program
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by jazz627 on Aug 5 at 2:53 AM |  Mark as helpful |
Thank you for your inputs John. Now, I really feel I shouldn't do this.
Anyway, to give a background on this there's a garbage record in KNVK w/c
is causing an error when a contact person is updated using XD02 (the error
is "Contact person not found"). But when you look inside KNVK, the record
is there but with garbage data in field PRSNR. They analysed that this is
what's causing the error. I guess the only way they see to resolve this is
to directly delete this record.
Regards,
Jas
"john.louk via sap-abap" <sap-abap@Groups.ITtoolbox.com>
08/05/2009 01:59 AM
Please respond to
sap-abap@Groups.ITtoolbox.com
To
jazz627 <jasper.borra@coats.com>
cc
Subject
RE: [sap-abap] Deleting records directly from a transparent table using
custom ABAP program
Posted by john.louk (Workflow Designer)
on Aug 4 at 1:47 PM
Mark as helpful
Sorry to re-iterate what you have already heard. But, someone at you
company needs to try to express the large impact that deleting SAP master
data is. Even if you think that you have all of the related tables for a
material figured out, it is likely that you have missed some there are
many tables beyond the apparent ones (i.e. MARA, MARC, MARD, MAKT, etc.).
The other thing is that most forget to include all of the
other/transactional tables that have the material number stored on them
(i.e. VBAP, EKPO, EBAN, etc.). To physically, delete a material master
pretty much destroys all of the integrity in the database.
What is the reason that they want to physically delete the record? Why are
they not open to marking it for deletion? Have you looked for something in
standard SAP. There used to be a program (standard SAP) that would
physically delete a customer master record. If I remember correctly, this
could be run for customers that were marked for deletion. It would also go
through a validation process to see if all transaction documents were
closed.
Cheers
John
_____
From: jazz627 via sap-abap [mailto:sap-abap@groups.ittoolbox.com]
Sent: Tuesday, August 04, 2009 11:26 AM
To: Louk, John
Subject: [sap-abap] Deleting records directly from a transparent table
using custom ABAP program
Posted by jazz627
on Aug 4 at 11:29 AM
Hi All,
I need to delete a record directly from a Transparent table (ex. MARA)
because it doesn't have a Maintenance view (using SM30 is out of the
question). My question is if I use "DELETE FROM dbtab" do I need to use
the COMMIT command at the end?
Thanks in advance.
(Note: I tried telling the people who wanted this does it is not a good
idea to delete records directly from the database but this is how they
want it done)
Regards,
Jasper
__.____._ Anyway, to give a background on this there's a garbage record in KNVK w/c
is causing an error when a contact person is updated using XD02 (the error
is "Contact person not found"). But when you look inside KNVK, the record
is there but with garbage data in field PRSNR. They analysed that this is
what's causing the error. I guess the only way they see to resolve this is
to directly delete this record.
Regards,
Jas
"john.louk via sap-abap" <sap-abap@Groups.ITtoolbox.com>
08/05/2009 01:59 AM
Please respond to
sap-abap@Groups.ITtoolbox.com
To
jazz627 <jasper.borra@coats.com>
cc
Subject
RE: [sap-abap] Deleting records directly from a transparent table using
custom ABAP program
Posted by john.louk (Workflow Designer)
on Aug 4 at 1:47 PM
Mark as helpful
Sorry to re-iterate what you have already heard. But, someone at you
company needs to try to express the large impact that deleting SAP master
data is. Even if you think that you have all of the related tables for a
material figured out, it is likely that you have missed some there are
many tables beyond the apparent ones (i.e. MARA, MARC, MARD, MAKT, etc.).
The other thing is that most forget to include all of the
other/transactional tables that have the material number stored on them
(i.e. VBAP, EKPO, EBAN, etc.). To physically, delete a material master
pretty much destroys all of the integrity in the database.
What is the reason that they want to physically delete the record? Why are
they not open to marking it for deletion? Have you looked for something in
standard SAP. There used to be a program (standard SAP) that would
physically delete a customer master record. If I remember correctly, this
could be run for customers that were marked for deletion. It would also go
through a validation process to see if all transaction documents were
closed.
Cheers
John
_____
From: jazz627 via sap-abap [mailto:sap-abap@groups.ittoolbox.com]
Sent: Tuesday, August 04, 2009 11:26 AM
To: Louk, John
Subject: [sap-abap] Deleting records directly from a transparent table
using custom ABAP program
Posted by jazz627
on Aug 4 at 11:29 AM
Hi All,
I need to delete a record directly from a Transparent table (ex. MARA)
because it doesn't have a Maintenance view (using SM30 is out of the
question). My question is if I use "DELETE FROM dbtab" do I need to use
the COMMIT command at the end?
Thanks in advance.
(Note: I tried telling the people who wanted this does it is not a good
idea to delete records directly from the database but this is how they
want it done)
Regards,
Jasper
Copyright © 2009 CEB Toolbox, Inc. and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
