Delete Serial number

[Former Member]

Dear Gurus,

Serial number for a particular material is updated twice in the system.

I want to delete one number, both have different eqiupment number.

sugest me the way to solve this problem.

Thanks in advance.

[Former Member]

Dear Gurus,

Serial number for a particular material is updated twice in the system.

I want to delete one number, both have different eqiupment number.

sugest me the way to solve this problem.

Thanks in advance.

[Former Member]

hi,

If your post is with respect deleting a entry in a database table..?? then use delete statement on the DBTABLE

Delete from dbtab where <expression>.

or

Delete dbtab from wa. " where wa contains complete specification of records with respect to primary key, the wa is similar structure of database table

*give the appropriate equipment number

This would solve your purpose with respect to data base tables

Thanks

Sharath

[Former Member]

Yes you can have the deletion indicator for the seerial number ..

In IQ02, enter material and the serial number.. in the resulting screen.. Mat.ser.no....functions.....deletion flag...set and save..

karthick

[former_member203501]

hi do one thing...

if you want to delete the serial number which is recent ..

then use sort table itab in descending

and read with index 1

and then delete .

or else if you want to delete the old one

then use sort table itab in ascending

and read with index 1

and then delete .

or delete the record using the where condition