topic Re: Delete Serial number in Application Development and Automation Discussions

Delete Serial number

Former Member — Fri, 13 Feb 2009 11:22:35 GMT

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.

Re: Delete Serial number

Former Member — Fri, 13 Feb 2009 11:32:20 GMT

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>.


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

Re: Delete Serial number

Former Member — Tue, 31 Mar 2009 08:56:34 GMT

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

Re: Delete Serial number

former_member203501 — Tue, 31 Mar 2009 09:06:57 GMT

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