topic Re: Deleting records from database table in Application Development and Automation Discussions

Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:32:48 GMT

I got a requirement that in one case I have to delete a records from db

So I suppose to do like

Loop at itab.

Delete stko where IDNRK = it_itab1-matnr.

Endloop.

Is it suggestible for my requirement?

Please help me out

Thanks in Advance.

Regards

Rao

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:41:18 GMT

Its Not advisable to delete standard table records other than from standard transactions.

Regards

Karthik D

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:42:39 GMT

If you can tell us that why you want to delete the data from BOM Header table that will be more helpful. Because deleteing data in this way is not supported by SAP. A BDC can be a better option.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:43:32 GMT

The standard tables are always inter related. So, you should check the consequences you would have to face.

Check where all this table is used, what is the effect it is going to take?

Also, check if the table is client independant or dependant.

Do some research about the table first and then delete.

Regards,

Vishwa.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:47:24 GMT

i want to change the item category of BOM. its not possible to change the item category of BOM, so first i am deleting the item category aft tht i ll re-insert the item category again.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:52:41 GMT

Your approach is not going to work in the way you are trying, i suppose you will end up crashing the system.

My suggestion is to do a BDC recording or BAPI to delete BOMs and then re-upload again with the correct Item category...

Regards

Karthik D

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 11:54:26 GMT

Hi Karthik

Can u tell me BAPI name or in BDC how we do for deleting

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 13:22:21 GMT

any ideas?

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 13:28:53 GMT

Hi,

You can create BDC or LSMW for CS02 transaction and delete the BOM.

In the second screeen MATERIAL BOM menu you have an option to delete the BOM.

You also require Change number for do this activity or you can request authoriztion to basis team

to delete BOM without change number.

Regards,

Shan

Re: Deleting records from database table

former_member404244 — Tue, 11 Nov 2008 13:34:41 GMT

Hi,

see if u can use the BAPI 'CAVC_I_CHANGE_BOM_ITEM_DATA'.

Regards,

Nagaraj

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 14:16:08 GMT

Hi Shan

i want to delete the item category of BOM only not whole BOM, for deleting this we will use IB02 Tcode.

So can u give some idea for writing this program

Thanks in Advance.

Re: Deleting records from database table

matt — Tue, 11 Nov 2008 14:29:29 GMT

Before writing a programmatically deleting records from a SAP standard Database table, consider this thread: This poor chap has at least not caused an business problems.

Now think about what you will do if your program doesn't quite work as expected, and you end up with a corrupted production system that means the business can no longer do their work.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 14:33:22 GMT

i will delete in BOM Item Category only aft tht i ll update with new values in single program only i will do this.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 14:36:17 GMT

Go ahead by all means and write your code.

And dont forget to put your experience afterwards when the executives and Audit come after you and your team for doing that

Re: Deleting records from database table

matt — Tue, 11 Nov 2008 14:38:14 GMT

There could be all sorts of processing that has already taken place that depends on the bom item category. There's a reason it isn't changeable by SAP supplied transactions. When you do more processing using that bom, you could end up with inconsistencies. Are you sure you won't. 100%, bet your life sure?

Are you planning on running this in production?

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 14:43:07 GMT

Hi,

In the worst case, if you have to do this...make sure you document everything properly and take the nec essary approvals so as to save yourself in case a issue raised on the approach being followed.

Don't forgot to include the risk of this solution apporach in your formal documents, and approvals.

Re: Deleting records from database table

Former Member — Tue, 11 Nov 2008 14:43:26 GMT

Hi Matt

i am 100% sure that its my requirement only

its not possible to change item cateegory of BOM for tht we have to do delect that one aft tht i ll reinsert again in single program only

Re: Deleting records from database table

matt — Tue, 11 Nov 2008 14:44:00 GMT

See OSS note 901730

Re: Deleting records from database table

matt — Tue, 11 Nov 2008 14:45:51 GMT


> Hi Matt
> 
> i am 100% sure that its my requirement only
> its not possible to change item cateegory of BOM for tht we have to do delect that one aft tht i ll reinsert again in single program only

Then make 100% sure that you cover yourself as Ajay Tiwari says. When it goes wrong, if you've not pointed out the risks, you could be the scapegoat.

Re: Deleting records from database table

Former Member — Wed, 12 Nov 2008 04:45:18 GMT


> Hi Matt
> 
> i am 100% sure that its my requirement only
> its not possible to change item cateegory of BOM for tht we have to do delect that one aft tht i ll reinsert again in single program only

If you are 100% sure then instead of Delete & insert do Update.

Regards

Karthik D