Solved: Wrong item code

former_member522789 · ‎07-31-2008

Hello

I want to delete a set of Items and I do not know how to do it

All these items are blocked

I see the fields Canceled and Deleted in OITM

SELECT T0.[ItemCode], T0.[ItemName], T0.[Canceled], T0.[Deleted] FROM OITM T0

Can somebody explain the use of this 2 fields and how to actually make an item unvisible in all reports.....

I ma thinking of using SQL..... data base for that

former_member187989 · ‎07-31-2008

Deletion:-

You can remove(delete) an item if there are no transactions

associated with it.

You can hold an item if there are transactions associated with it.

Cancel:-

If you cancel an item then it won't appear in choose from list.

But all the things can be done in front end.

You should n't do mass deletion using sql in back end,

SAP can't support.

Jeyakanthan

former_member522789 · ‎07-31-2008

I've found part of the answer

Wrong item code