topic Re: delete entries from internal table. in Application Development and Automation Discussions

delete entries from internal table.

Rushikesh_Yeole — Fri, 29 Jan 2010 05:29:02 GMT

i have 2 internal tables ITAB1 and ITAB2 with different entries.

data: ITAB2 type table of TAB2.

TAB2 is standard database table.

i have to delete entries from ITAB1 where TAB2-FIELD is not blank.

Please suggest the code.

Re: delete entries from internal table.

Former Member — Fri, 29 Jan 2010 05:30:26 GMT

Press F1 on Delete syntax

Re: delete entries from internal table.

Rushikesh_Yeole — Fri, 29 Jan 2010 05:32:08 GMT

i have 2 internal tables ITAB1 and ITAB2 with different entries.

data: ITAB2 type table of TAB2.

TAB2 is standard database table.

i have to delete entries from ITAB1 where TAB2-FIELD is not blank.

TAB2-FIELD is not present in TAB1.

Please suggest the code.

Re: delete entries from internal table.

Former Member — Fri, 29 Jan 2010 05:36:03 GMT

hi.

there has to be atleast something common.

the 2 database tables fromm where you populated the internal table has to have something common betweeen them.

Re: delete entries from internal table.

Former Member — Fri, 29 Jan 2010 05:37:58 GMT

DELETE ADJACENT DUPLICATE ENTRIES FROM TAB1 COMPARING

Re: delete entries from internal table.

Former Member — Fri, 29 Jan 2010 05:43:01 GMT

Hi,

You will need common fields in table itab1 and itab2. As per my understanding, table itab2 is having structure of standard tble tab2. And internal table itab1 is of some different structure.

So, in order to delete entries from itab1 based on itab2-field i.e. tab2-field, you need releation between two tables. There must be some common fields in itab1 and itab2. You will have to loop at table itab2 and read table itab1 with the key fields and then use

if itab2-field is blank.

delete itab1 index sy-tabix.

endif.

Thanks,

Archana

Re: delete entries from internal table.

Rocky1 — Fri, 29 Jan 2010 06:03:11 GMT

Hi,

There must be some link between the two tables..

If primary key of table TAB2 is present in TAB1

Then you can go ahead like this:

SELECT common_field<preferably primary key> INTO

table itab3 FROM TAB2

WHERE TAB2-FIELD NE space.

LOOP AT ITAB3 into wa_itab3.

DELETE ITAB1 WHERE common_field EQ wa_itab1-common_field.

ENDLOOP.