topic Re: internal table duplicates in Application Development and Automation Discussions

internal table duplicates

Former Member — Tue, 27 Jan 2009 05:56:22 GMT

hi all,

I have problem with internal table.there is field profit center in internal table.

iam also getting blanks for profit center. i want to keep interies in internal table,

if there is a value in profit center and if it is blank it should be deleted from internal table.

plz suggest any solution .

thank you.

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 05:58:11 GMT

cldnt understand exactly wht u r asking ?

how do u want to maintain the entires in the internal table ?

if u dont want blan entries at all..

delete <internal_table> where profitcenter = space

n if u dont want duplicate values for profit center also not even blank den

sort internal table by profit center

delete adjacent dupliactes from internaltable comparing profitcenter

delete <internal_table> where profitcenter = space

Edited by: Ashwinee Mali on Jan 27, 2009 11:29 AM

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 05:58:59 GMT

After selecting data into internal table write

Delete itab where profitcenter is initial.

Hope this helps...

Edited by: Karan Sethi on Jan 27, 2009 11:38 AM

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:02:25 GMT

hi,

Internal table has a field called profitcenter.

some records in internal table have values for profitcenter.

and some records doesnot have values.

now i want to delete all the records from internal table where profit center is blank.

thank you

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:02:38 GMT

hi,

set flag if there is no entries in that column.

then delete internal table transporting flag.

Try,

DELETE itab WHERE fname IS INITIAL.

DELETE itab WHERE col IS INITIAL.

or try this.

sort it_tab field1 . ..

Delete itab where itab-field = space.

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:07:01 GMT

Hi,

use this statement...

DELETE itab WHERE profitcenter EQ spcae.

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:08:59 GMT

Check out the syntax for different types of Delete at: [Delete from itab|http://help.sap.com/saphelp_nw70/helpdata/en/06/aafd54fc4011d195280000e8353423/content.htm]

Delete itab where profit_center IS INITIAL. will work

Hope this helps

Regards,

Jayanthi.K

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:16:36 GMT

Hi,

Try this solution:

DELETE <internal table name> WHERE <field name (Profit Center)> IS INITIAL.

I hope it will help you.

Thanks and regards,

Suresh

Re: internal table duplicates

Former Member — Tue, 27 Jan 2009 06:16:59 GMT

Hi,

You can delete from itab as below.

Delete I_Tab where FieldName Is Initial.

Delete I_Tab where FieldName Eq ' '.

Other wise you can move all values of the field to one more internal table and you can clear first Itab clear.

Regards

Md.MahaboobKhan