topic Re: delet data from standard table in Application Development and Automation Discussions

delet data from standard table

Former Member — Wed, 12 Sep 2007 05:05:55 GMT

hi , my rquirement is , i want to delect some record from database table MCHB

Re: delet data from standard table

Former Member — Wed, 12 Sep 2007 05:26:58 GMT

use delete statement with proper conditions

DELETE FROM <ZTABLE> -> All hits'll be deleted.

You can also indicate some conditions if you don't need to delete whole table.

DELETE FROM <ZTABLE> WHERE .....

Re: delet data from standard table

Former Member — Wed, 12 Sep 2007 05:30:17 GMT

delte MCHB where <condition>

COMMIT WORK.

Re: delet data from standard table

Former Member — Thu, 13 Sep 2007 13:38:50 GMT

DELETE table WHERE conditions

Regards

Gregory

Re: delet data from standard table

Former Member — Thu, 13 Sep 2007 14:21:56 GMT

Ypou should use a BAPI or batch input for this, not direct table deletes. What transaction normally deletes records from this table?

Rob

Re: delet data from standard table

Former Member — Fri, 14 Sep 2007 06:37:26 GMT

Hello,

After deleting do use the statement COMMIT Work and WAIT.Otherwise the deleted entries will not be reflected in the table..

Thank's

Rakesh

Re: delet data from standard table

Former Member — Sun, 16 Sep 2007 05:33:09 GMT

Hi,

Firstly, you should not delete any record from standard SAP tables using direct database statements. There are proper methods for every activity to be performed on data in standard SAP system.

This is table for Batch Stocks. This is not a direct transaction table in SAP. Data is added or modified in this table through various transactions mainly of MM, PP & SD. Hence BAPI or BDC cannot fulfill the requirement.

If your requirement is to withdraw batch stocks, then cancel the material documents that have posted the stock. If your material period is already closed and you are not able to cancel the material documents, then withdraw your stocks by posting it to scrap with permission from management. If it is uploaded stock, withdraw it using 562 movement.

Never ever try to delete records from standard tables directly. It will lead to inconsistencies and lot of confusions in the system.

Regards,

Hema

Re: delet data from standard table

Former Member — Tue, 18 Sep 2007 14:09:33 GMT

To chime in on the advises of using a BAPI instead of directly deleting standard table entries:

When someone else currently works with a table entry and you try delete that data, you will be in trouble and generate inconsistencies that prolly can't be repaired. That's the advantage of a BAPI, because it will take care of the locking mechanism which avoids 2 users accessing and manipulating the same data. (every standard table has corresponding standard BAPI's to maintain the data)

Say "No!" to direct table manipulations!

kr,

Walter

Re: delet data from standard table

Former Member — Wed, 19 Sep 2007 13:39:22 GMT

If ever a direct table update is necessary, (and yes, there are cases, when no BAPI is available) at least foresee the table locking. In SE11, lookup the lock object for the corresponding table. Each lock object has 2 FM's: one for locking and one for unlocking --> call them in your code. This will avoid the locking issues.

Re: delet data from standard table

Former Member — Wed, 19 Sep 2007 19:54:11 GMT

Lalith,

MCHB is a standard SAP table for Batch Stocks. It is always a bad idea to delete directly from SAP tables. Use an appropriate SAP transaction to delete data from this table.

Re: delet data from standard table

Former Member — Wed, 19 Sep 2007 20:17:03 GMT

Lalith,

Its not advisable to delete the date directly from the data base table.... rather you can over write some data for the important field.

Like if you take LFA1 table if you make LIFNR field data to 'do not use' then in the table all those records are kind of deleted...

so I can suggest you this way..... you can do it with the mass maintanance