Is it possible to remove items from sap b1 using delete statement query

[makhamadzoidov]

Is it possible to remove all items from sap business one using query?

for example:

DELETE FROM OITM T0

or

TRUNCATE TABLE OITM T0

why don't recommend these ways to remove items or etc data?

[dannydgj · Accepted solution]

It is not recommended to do any Delete or Truncate in a table because you´re afecting the integrity of the structutre of the database.

You can remove an item from SAP Business One if the item does not have any transaction. I think that´s the best practice.

Regards.

[makhamadzoidov · Accepted solution]

Thanks for your answers Can u help me again how to delete all items from sap b1 using dtw I searched from google but I can't find it.

[dannydgj · Accepted solution]

I'm sorry, DTW is only to import and update. Try following the image below:

Select Item Master Data and follow the steps.

Regards.

[patrice_vigier · Accepted solution]

Master data cleanup only deactivate